Hi,
I needed to override the Data Import Wizard so I have created a macro
which functions perfectly. However, the filename is hard coded in the
macro and I need to run the macro on different files and select each
file individually. After searching through the Mr Excel Forum
archives, I learned about the following instructions which prompts me
for the filename:
filename = Application.GetOpenFilename("Text Files (*.txt), *.txt")
If filename <> False Then
MsgBox "Open " & filename
End If
http://www.mrexcel.com/archive/VBA/7026.html
This is great! However, I need to substitute the captured filename in
two places. Once containing the full path and filename and again with
just the filename.Thanks in advance for any assistance you can
provide.
Kind regards,
Greg
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
