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

Mark Forums Read

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 »

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
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 10:59 PM.