Menu

VBA code to import stacked text files

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Tom Ogilvy Tom Ogilvy is offline

Tom Ogilvy is offline

external usenet poster

Posts: 6,953

Default

VBA code to import stacked text files

If you want to send a sample text file to I will take a
look for you

--
Regards,
Tom Ogilvy

"SportyJim" wrote:

The Data Menu - Import will not work because there are several lines of data
per order and I want all the data for each order on one line. There is a line
number for each item on an order. Additionally, the subsequent lines do not
have the order number on the respective lines. You know that the data for the
order is complete because it has the "Order Total Cost: 0.00" on the last
line for each order. Thanks for the thought though. If anyone can help, I
would appreciate it beyond belief!

Thanks in advance,

Jim

"Joel" wrote:

Have youtried to use in the Data Menu - Import. You may not need to write a
macro.

"SportyJim" wrote:

I have never attempted to write VBA code, but would like to know how to
import a report with data in a text file that is stacked that I want to
import to excel on one line in columns. Can someone help with this?

Reply With Quote

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 text files into EXCEL	Annette	Excel Discussion (Misc queries)	1	March 1st 09 10:16 PM
import few text files from subdirectories	bratek	Excel Programming	7	July 26th 06 01:14 PM
Import of Multiple Text Files	yanks6rule[_2_]	Excel Programming	1	January 26th 06 11:34 PM
Search text of external files and import	flaterp	Excel Programming	3	November 21st 05 05:45 PM
Search text of external files and import	TomHinkle	Excel Programming	1	November 18th 05 04:20 PM

All times are GMT +1. The time now is 09:22 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement