peterhall

Junior Member

Posts: 1

import txt with VB

Hi there. I'm trying to import a text file to a sheet in excel, where I can click a button, open the explorer, select the file and import to the active sheet, all this in VB.

I've got also a file in txt with more than 300 columns to import, but in this case, I want to split in 2 sheets when I'm importing, because excel doenst accept all of them...

Can you explain me how to do it?

Tks in advance...

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import XML	aushknotes	Excel Discussion (Misc queries)	0	April 7th 10 03:29 AM
import XML data...Is there a size limit on the import?	MatthewG	Excel Discussion (Misc queries)	0	February 10th 09 05:57 PM
2P import	Accounting user	Excel Discussion (Misc queries)	2	July 17th 08 04:48 PM
How to Start Excel in Text Import Wizard for data import	rlelvis	Setting up and Configuration of Excel	0	July 10th 08 08:40 PM
import	Mindy	Excel Discussion (Misc queries)	2	April 12th 05 05:26 PM

All times are GMT +1. The time now is 03:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us