using variable with .Activate

  • Thread starter Thread starter Super Slueth
  • Start date Start date
S

Super Slueth

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
 
Enclose the string in double-quotes:

MyString = "C:\path\filename"

The Sheets().Activate selects a tab not a workbook
 
Use the filename only, not path and filename.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Dim MyString AS String
Dim MySheetName AS String


MyString = "filename.xls" ' no path
MySheetName = "sheet1" ' as an example



Windows(MyString).Activate

Sheets(MyFileNAme).Select
 
Back
Top