Wildcard in filename of activate window code

Davefrisch

New Member
Joined
Jun 19, 2008
Messages
28
I have a situation where a program (which I have NO control over) will dump a data set into an excel file and label the workbook CH567_Current_Date/Time. Since the CH567_ will always be the same, but the current date and time will chane by the second, I was wondering if there is a way to have a macro move between workbooks using a wildcard.

I tried windows("CH567"*).activate, but I'm sure you already realized that would not work. I also tried different variations to no avail. I would greatly appreciate any assistance.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Perhaps

Code:
Workbooks(Workbooks.Count).Activate
 

Davefrisch

New Member
Joined
Jun 19, 2008
Messages
28
I guess if I do this in a certain order and plan out the the macro steps accordingly it should work.... I think... Thank you very much for your suggestion!
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,604
Messages
5,597,128
Members
414,126
Latest member
jellevansoelen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top