I need some help writing a VBA code for importing data from an external file.
Can you user enter the location of the file by browsing?
While doing it manually, I import the data and format it as text in the import dialog box.
I need some help writing a VBA code for importing data from an external file.
Can you user enter the location of the file by browsing?
While doing it manually, I import the data and format it as text in the import dialog box.
Hi,
Try using the macro recorder and record your steps.
When done stop the recorder.
You can now view what you just recorded.
Hope this gets you stared.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks