Workbook OpenText File command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read Only 3
Macro to push data to another workbook 0
Multiple Workbooks using same macro 4
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Active Workbook 8
Workbooks.OpenText method help 3
Saving a workbook with a makro 2
problem with macros and protections 5

Back
Top