Macro to load text file not working.

**calvinle** · 03-14-2014, 04:33 PM

Hi,

I need to load a text file into an excel, but to paste all only in the column A and not having to split them out to other column.

Here are the sample files:
HELP.xlsm
HELP.txt

If anyone can tell me where is wrong?

Thanks.

**apo** · 03-14-2014, 05:56 PM

Hi..

Try this.. change the file path to suit..

Please Login or Register  to view this content.

or this with a File Browser Dialogue..

Please Login or Register  to view this content.

**jindon** · 03-14-2014, 06:36 PM

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**calvinle** · 03-20-2014, 10:53 PM

The final code is:

Please Login or Register  to view this content.

But how can I mod so if they cancel and dont load any file, it will prompt a message saying, you did not select any file?

Thanks.

**jindon** · 03-20-2014, 11:05 PM

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Macro to load text file not working.

LinkBack

Thread Tools

Rate This Thread

Display

Macro to load text file not working.

Re: Macro to load text file not working.

Re: Macro to load text file not working.

Re: Macro to load text file not working.

Re: Macro to load text file not working.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro Working fine until last line of text file

VBA Importing Text File makes the file longer to load everytime

How to load macro file Automatically in Excel

Opening a browse and load file box in a macro

[SOLVED] Can I load text file into Excel seting field delimter using cmd li

Bookmarks

Bookmarks

Posting Permissions