Workbook OpenText File command

S

surveyorinva

I am running a macro in where a text file is opened in a new workbook. Right now I have to define the file location and name in the macro code. I would like the file location and name to be user defined that can be asked when the macro is started. Is there a way to do this
Any help would be grea
Thanks
C. Fillmore
 
B

Bob Phillips

see response in programming

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

surveyorinva said:
I am running a macro in where a text file is opened in a new workbook.
Click to expand...
Right now I have to define the file location and name in the macro code. I
would like the file location and name to be user defined that can be asked
when the macro is started. Is there a way to do this?
 
Top