| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate workbook using partial name
This also worked perfectly. Thanks for the help.
"Per Jessen" wrote: Hi If the workbook DONE* is the active workbook when the macro is started you can use this before the macro create the new workbook: Dim wbA as Workbook Dim wbB as Workbook Set wbA = ActiveWorkbook Set wbB=Workbooks.Add 'Your code 'More code wbA.Activte Hopes this helps --- Per "aileen" skrev i meddelelsen ... Is it possible to activate a workbook using only part of the worbook name? e.g. windows("Done.*").Activate. I have two workbooks open, my macro creates one of the wb's and the other is already open, but the end of its name will change everyday. For example, today the wb name is DONE3209.xlsx but tomorrow the wb name may be DONE3509.xlsx. The first 4 letters in the wb name will always be the same so I would like to use that part of the wb name only to activate the wb. Thanks in advance for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| activate workbook | Excel Programming | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| Reference a workbook with only a partial name | Excel Worksheet Functions | |||
| Workbook.activate | Excel Discussion (Misc queries) | |||
| Activate Other Workbook | Excel Programming | |||
Hybrid Mode
