macro, data import from the ONLY text file in current folder

		Microsoft Office Forums > Microsoft Excel > Excel Programming
macro, data import from the ONLY text file in current folder

FAQ

Thread Tools

Display Modes

06-16-2012, 02:44 PM

ue418

Windows 7 32bit macro, data import from the ONLY text file in current folder

Office 2000

Novice

Join Date: May 2012

Posts: 17

Okay, I got it...

I had to change the "Range" part of the command from =Range("A3") to =Range("Sheet1!A3"). Now it works fine, even when I click the macro on Sheet2! Thanks for reading.

Rick

« 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
PST Import - "Not a Personal Folder File"	stucraig.uk	Outlook	2	03-30-2011 04:00 PM
Word Macro: Save file as text with current file name	jabberwocky12	Word VBA	2	10-22-2010 12:23 PM
Import Text from File - Line Spacing	marshalx	Word	2	10-28-2009 02:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:04 AM.