VBA Importing Text File makes the file longer to load everytime

**Hudas** · 01-15-2014, 09:41 AM

Hi -

I have a recorded macro of the Get External Data - From Text but I noticed that when after saving and when I open again the file its always taking the longer to load?

Is there some kind of explanation for this?

Thank you
Hudas

**Norie** · 01-15-2014, 09:44 AM

Do you still have a connection to the text file?

Have you tried using OpenTextFile?

**Hudas** · 01-15-2014, 10:25 AM

Hi Norie

Not sure what you mean but below is the code that i record and made some changes on.

Please Login or Register  to view this content.

Thank you

**Norie** · 01-15-2014, 10:29 AM

Your code sets up a connection to the text file.

That connection could be being refreshed when you open the workbook, hence the slow opening.

Either break the connection or use a method of import that doesn't create one in the first place, eg OpenTextFile.

**Hudas** · 01-15-2014, 11:26 AM

Hi Norie

I added this to code above. I think this solves the problem.

Please Login or Register  to view this content.

Thank you

VBA Importing Text File makes the file longer to load everytime

LinkBack

Thread Tools

Rate This Thread

Display

VBA Importing Text File makes the file longer to load everytime

Re: VBA Importing Text File makes the file longer to load everytime

Re: VBA Importing Text File makes the file longer to load everytime

Re: VBA Importing Text File makes the file longer to load everytime

Re: VBA Importing Text File makes the file longer to load everytime

Thread Information

Users Browsing this Thread

Similar Threads

Importing a data from a text file - user-defined file

[SOLVED] importing text file into excel file using macro

Importing a text file to an existing sheet, with a dialog to pick the text file

code to check file size everytime an Excel file is opened

Importing text file, only option to edit existing file

Bookmarks

Bookmarks

Posting Permissions