How to import a text file but skip the first line regardless of characters?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to import a text file but skip the first line regardless of characters?

FAQ

Thread Tools

Display Modes

02-01-2013, 03:50 PM

macropod

Windows 7 64bit How to import a text file but skip the first line regardless of characters?

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

With the modification I proposed, the first line in your data file will always be skipped, regardless of its content. Isn't that what you wanted? Unless your data file can have multiple unwanted 'header' lines, I can't see what would be achieved by the additional testing.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import multiple text file data into word	mizankabir	Word VBA	7	09-15-2023 10:27 PM
macro, data import from the ONLY text file in current folder	ue418	Excel Programming	5	10-28-2017 12:52 PM
Junk characters (box-like characters) in Word file	Sashikala	Word	1	04-20-2010 02:03 PM
Import Text from File - Line Spacing	marshalx	Word	2	10-28-2009 02:37 AM
Help please: Keeping spaced characters on one line	EtienneOBrien	Word	3	12-24-2008 07:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 AM.