Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an active worksheet in a workbook that I need to grab some data off
of. The problem is the name of the workbook that the worksheet resides in contains a date and time the workbook was created as part of the file name. I've tried to use wildcards* to acftivate the workbook but that doesn't seem to work. Here is an example of the code I'm trying to run that isn't working: Windows(BankNum & "-UserGroupReport" * ".csv").Activate BankNum comes from user input -UserGroupReport is static in the name * represents the part of the file name that contains the date/time I don't want to make this really complicated. Does anyone have any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
Copy sheet and make new sheet active | Excel Discussion (Misc queries) | |||
Need VBA Code to Let User Define Active Sheet | Excel Discussion (Misc queries) | |||
How to make chart embedded in active sheet? | Excel Programming | |||
How to make a sheet the active sheet? | Excel Programming |