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?

02-01-2013, 01:54 AM

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,521

Try:
If iRow > 0 Then Cells(iRow, 2) = B ' This line puts the imported values into the excel sheet

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:15 PM.