Import Textfile WITHOUT showing wizard..

**Armitage2k** · 09-15-2009, 04:14 AM

Hello!

I am using this code to import txt documents, but once the file has been selected and everything, the excel data import wizard shows up... I now would like to get rid of this problem, as well add a standard path to this code, so that I dont always have to start from the desktop and click through tons of folders to get the folder containing my files.

Please Login or Register  to view this content.

btw, all the files are delimited and saved in folder C:/testfolder/ . However, I dont want to import all files of this folder, only the one which has been selected.

Thanks for the help!!
A2k

**arthurbr** · 09-15-2009, 07:11 AM

I don't know if it's of use to you, but drag and dropping a text file in a XL sheet does the job without wakening the wizard

**Armitage2k** · 09-15-2009, 07:42 AM

I am afraid that is not a suitable solution, since this will not be performed by myself, and the insert data later will be adjusted by another macro and must be in certain cells from A2 downwards.

But thanks,
A2k

**pike** · 09-15-2009, 08:56 AM

ArmitageK2

try....

Please Login or Register  to view this content.

**pike** · 09-15-2009, 09:13 AM

or maybe ...

Please Login or Register  to view this content.

**Armitage2k** · 09-15-2009, 10:59 AM

well, thanks for the help, but unfortunately both codes dont do what I need to do

The data in the txt files is delimited. Both codes copy me the whole data into one cell per row, thus the "tab" separating the data is ignored.
Further, the data must be entered in A2 onwards, since row 1 contains headers and some infos I need. Afar from this, the import works fine, just not exactly how I need it

Thanks,
A2k

**Armitage2k** · 09-15-2009, 12:13 PM

well, much easier:

Please Login or Register  to view this content.

Still one more little adjustment though. How can I add a standard path to this macro? I tried to set another variable and add it to "filetoopen" but it simply ignores me somehow... any ideas?

thanks,
A2k

**pike** · 09-15-2009, 06:01 PM

Hi AK2

What the delimiter Tab?

**Armitage2k** · 09-16-2009, 03:41 AM

yes.
However, the above posted code works for me, only a possiblity to add a standard path would be on my wishlist

Thanks,
A2k

**pike** · 09-16-2009, 03:58 AM

A2k
Try..

Please Login or Register  to view this content.

**pike** · 09-16-2009, 05:14 PM

A2K can you please mark the post "solved" if it has been resolved

**Armitage2k** · 09-18-2009, 06:00 AM

Works like a charm now!
Thanks a lot!!
A2k

**pike** · 09-18-2009, 07:25 AM

your welcome
thanks for marking the post

Import Textfile WITHOUT showing wizard..

LinkBack

Thread Tools

Rate This Thread

Display

Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Re: Import Textfile WITHOUT showing wizard..

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions