Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using the following code to get the filename I want to open:
my2ndFileName = Application.GetOpenFilename("All Files (*.*), *.*") where the actual filename is "C:\Downloads\LAS6014" and I use the following to open the file: Workbooks.OpenText Filename:=my2ndFileName,... and because I don't now how to use the variable filename in the following, I hard code it as follows: Windows("LAS6014").Activate So the question is: how do I activate the worksheet (or is it a workbook) for the variable filename? Thanks, Bernie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make the filename in a link variable based on a cell valu | New Users to Excel | |||
Nested String Filename Variable | Excel Worksheet Functions | |||
Variable in a filename reference in Excel 2000 | Excel Discussion (Misc queries) | |||
Entering a filename as a variable into cell similar as for footer | Excel Discussion (Misc queries) | |||
Put Filename Variable in Macro | Excel Discussion (Misc queries) |