Posted to microsoft.public.excel.programming

external usenet poster

Posts: 74

string variables in file names

Can i use a defined string variable in a file name when opening? if so what
is the appropriate syntax?

example....

Workbooks.Open Filename:= _
"C:\Documents and Settings\HP_Owner\Desktop\PanelSelect\panels\16-1
letterO.xls"

i want to use a string variable named "antfile" in place of the file name
16-1letterO.xls

--
dr chuck

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
String variables	John	New Users to Excel	3	July 16th 06 09:08 PM
Inserting variables within file names	kestrel	Excel Worksheet Functions	3	June 16th 06 08:00 PM
Parse String into Variables	Gary''s Student	Excel Programming	3	September 21st 05 03:32 PM
String Variables	[email protected]	Excel Programming	1	August 30th 03 07:28 AM
variables for file names	mike	Excel Programming	1	July 9th 03 11:39 PM

All times are GMT +1. The time now is 10:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us