Tags: convert, copied, excel, hard-drive, honest, macro, microsoft, msdn, public, remember, software, text, unknown, workbook

Finding macro in an unknown workbook on hard-drive

On Microsoft » Microsoft Excel

1,462 words with 1 Comments; publish: Thu, 22 May 2008 05:37:00 GMT; (30631.25, « »)

I remember I made a macro, and it has the text "convert" in it.

(Let's be honest - I copied a macro from microsoft.public.excel and

pasted it in a workbook that I forget the name of.)

I'd like to find that code and put it in my personal.xls as a macro so

that I'll be able to use it with other workbooks.

I'm searched in windows explorer for files of type *.xls with

"convert" in the file, but that didn't work. How do you find an excel

(VB) macro (in a specific workbook) on your hard-drive?

All Comments

Leave a comment...

  • 1 Comments
    • If you can pick out a constant string--not a variable name, maybe just use

      windows start button

      find

      and search through the *.xls files for files containing that text.

      You could specify the date modified, too. (Might get you closer).

      james s shoenfelt wrote:

      > I remember I made a macro, and it has the text "convert" in it.

      > (Let's be honest - I copied a macro from microsoft.public.excel and

      > pasted it in a workbook that I forget the name of.)

      > I'd like to find that code and put it in my personal.xls as a macro so

      > that I'll be able to use it with other workbooks.

      > I'm searched in windows explorer for files of type *.xls with

      > "convert" in the file, but that didn't work. How do you find an excel

      > (VB) macro (in a specific workbook) on your hard-drive?

      --

      Dave Peterson

      ec35720.excel.todaysummary.com.msn.com

      #1; Thu, 22 May 2008 05:38:00 GMT