Posted to microsoft.public.excel.programming

mudraker[_79_] mudraker[_79_] is offline

external usenet poster

Posts: 1

Ascii file import round 3

The only way I know of doing this is to open the text file ( as alread
done) then copy column a to column p

To copy from Column A to column P same sheet

Activesheet.columns("A").Copy Destination:=Activesheet.columns("A")

To Copy to a different worksheet

Activesheet.columns("A").Copy Destination:=Workbooks("Nam
Here").sheets("Sheet Name".columns("P"

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
How do I convert an Excel file to an ASCII file?	Pugh	Excel Discussion (Misc queries)	1	November 8th 06 08:57 PM
How do I convert an Excel file to an ASCII file?	Pugh	New Users to Excel	1	November 8th 06 06:57 PM
How do I convert excel file into ASCII text file with alignment?	Rosaiah	Excel Discussion (Misc queries)	2	June 27th 05 12:17 PM
ascii file import round 2	Mad Scientist	Excel Programming	1	January 8th 04 08:47 PM
Import ascii file	Mad Scientist	Excel Programming	2	January 8th 04 01:38 AM

All times are GMT +1. The time now is 04:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us