Text File import program not functioning

**Oliver H** · 01-22-2010, 01:04 PM

This code is from an edited macro & is designed to import a text file which is stored automatically with a date based name

"Ext" reffers to pre defined file extention string, and the FileName string is made up of information from cells in the spreadsheet. I have tested this string and it is producing the correct filename (I think!).

The code will not function and I can't figure out why. When I debug, it highlights the final line " .Refresh BackgroundQuery:=False". Any fix or alternate code sugestions would be very welcome.

Please Login or Register  to view this content.

**Rick_Stanich** · 01-22-2010, 01:23 PM

Please read the forum rules.
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.
http://www.excelforum.com/forum-rule...rum-rules.html

**Oliver H** · 01-25-2010, 04:49 AM

Basically, I just want to import a text file to a worksheet and then delimit it by 'Space'. Anyone have a solution for this please?

**Oliver H** · 01-25-2010, 05:48 AM

I have attached the xls 2003 file. Could someone please have a look at my codes. The file also contains a macro to return the full file path in order to check it's integrity.

**Oliver H** · 01-25-2010, 06:40 AM

Please help. Noone is responding to my post... which is leaving me a little worried. Have I neglected to include some vital bit of information, or is this queiry simply too petty for your godly excel powers??

Even if someone doesn't have an exact fix, if there are anny comments or suggestions as to where my problem may be, they would be helpful. If anyone has bypassed this, thinking that the solution is obvious, then please let me know what that solution is, or at least point me in the right direction.

I'm feeling a little unwelcome....

I have a feeling the problem is somewhere in the path name, an may be due to the fact that the file is on a networked drive.... Any suggestions??

**Rick_Stanich** · 02-16-2010, 04:13 PM

1. Commnets such as this may make members look away.

or is this queiry simply too petty for your godly excel powers??

I'm feeling a little unwelcome

2. Make sure the UNC path is "eaxctly" the same as it appears in a dialog box. CAPS are important. (I believe).

"Ext" reffers to pre defined file extention string, and the FileName string is made up of information from cells in the spreadsheet. I have tested this string and it is producing the correct filename (I think!).

3. Try removing the offending line temporarily?

Please Login or Register  to view this content.

Think about how your original question is stated it may be unclear to many what aid you need.

Usually I find the path to be the problem, whether it is due to the string (CAPS, not caps, ParTiAL CaPS, or some portion of the path string may be wrong).