| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using variable with .Activate
Hi
I'm trying to use a variable in the following code but i get an error. Subscript out of range I am runing a For/Next loop and need to change the file name for every loop Dim MyString AS String Dim MyFileName AS String MyString = C:\path\filename MyFileName = somefilename Windows(MyString).Activate Sheets(MyFileNAme).Select Any suggestion on how to do this correctly. Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook.Activate / Window.Activate problem | Excel Programming | |||
| Can a variable be used in a Worksheet().Activate method | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Reference to a variable in windows(???).Activate | Excel Programming | |||
| How to activate a file when the filename is represented by a string variable | Excel Programming | |||
Threaded Mode
