I have the following... it works well.
What I need now is to "call" that same sheet to do the following:Please Login or Register to view this content.
"FName.xlsx" does not work... any ideas?Please Login or Register to view this content.
I have the following... it works well.
What I need now is to "call" that same sheet to do the following:Please Login or Register to view this content.
"FName.xlsx" does not work... any ideas?Please Login or Register to view this content.
Try this...
Windows(fName & ".xlsx").Activate
Or
Workbooks(fName & ".xlsx").Activate
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Alpha Frog THANKS!!
you can also use a workbook variable
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks