Macro to activate window with variable name

[Cyprian]

Hi all,

I know this can be done because I had help doing it before (over a year ago), but I am trying to find a code that will move macro between excel files with varying names. The problem is the last part of the file name changes everyday but the first part doesn't.

So if the file name is: Hyper282740.xls I would like the macro to search for only "Hyper" and activate it.

Also if the file is: DPS volume list 2011-05-25 is there a way to open today's file in the macro? Something like Today = "=today()" so DPS volume list "today".xls ?


Many Thanks,
Cyp

[Domski]

Re the second part of the question you can do something like this:

Please Login or Register  to view this content.

Assigning the workbook to a workbook object as above makes it easier to work with it later on in your code.

As for the first part of your question do you mean you can multiple files of that name and the user should be allowed to pick the one they want or that it should just open a file beginning with "hyper' if it finds one in the specified directory?

Dom

[Cyprian]

Hi Dom,

Thanks for that code. I will open these spreadsheets manually, so they will already be open. I am needing a way for the macro to select them since the exact name will be different each time.

Regards,
Cyp

[Domski]

In my opinion it's better to get the code to prompt you for the file:

Please Login or Register  to view this content.

Dom

[Cyprian]

Will do. Thanks for the help Dom.