LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel 2000 importing huge ASCII files into different sheets

Hello,

I would like to load a big ascii file into Excel and split it into different
worksheets within the same workbook. The criteria to split is an empty line
with the next line being 1.0 In total the files contains 147 entities.

Anybody who could help me with VBA code?

--
Goran Stjepanovic
IT Consultant
KAS IT ServiceDesk
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel2007 - More columns when importing ascii file? MG Excel Discussion (Misc queries) 2 July 18th 07 05:44 PM
Importing Ascii file to Excell won't include Null Characters KJM Excel Discussion (Misc queries) 0 September 19th 06 09:03 PM
importing ASCII tt Excel Discussion (Misc queries) 1 March 3rd 06 03:29 AM
Saving Excel files takes a huge amount of time Heavy Excel user Excel Discussion (Misc queries) 6 January 12th 06 12:11 PM
Importing to Excel from ASCII Currie Excel Discussion (Misc queries) 5 August 26th 05 10:46 PM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"