Running vb script in windows on open spreadsheet

[stu1811]

Everyday I get an email with a spreadsheet. Instead of pasting in my vb code into the macro editor, I want run a vb script from windows on the spreadsheet. Since the spreadsheet's name changes with the date, I thought it would be easiest to look for an active excel window. Any other suggestions are welcome.

 

[Norie]

Why can't you just run the code from Excel?

You could have a workbook that only contains the code.

 

[stu1811]

I'm not following you logic, please explain

 

[Norie]

Just put the code in a workbook and run it.

Code can refer to other worksheets/workbooks.

 

[stu1811]

How do I run code from another workbook? It doesnt show up as an option when I goto run macro

 

[Norie]

I think you need to explain further exactly what you want to do.

Maybe I'm missing something.

What I'm suggesting is to have a workbook with the code in it.

The code in that workbook would be used to open the other workbook and then do whatever it is you want to do to it.

 

[stu1811]

I want to open an excel file and run a macro.
The tricky part: The file name changes daily and each sheet is its own workgroup.

 

[Norie]

Well you could do this from another workbook.

But do give specific advice would require more information.

Where is the workbook located?

How does the name change?

 

[stu1811]

The date is part of the file name. All of the files are located in the same folder.

 

[stu1811]

Morning bump