Microsoft Office Forums - View Single Post - [Solved] macro, data import from the ONLY text file in current folder

Thread: [Solved] macro, data import from the ONLY text file in current folder

View Single Post

Old

05-17-2012, 05:22 PM

ue418

ue418 is offline

ue418 uses Windows 7 32bit

Windows 7 32bit ue418 uses Office 2000

ue418 uses Office 2000

Office 2000

Novice

The original poster

Join Date: May 2012

Posts: 17

ue418 is on a distinguished road

Default

I got it!

The TEXT: line should read:

(Connection:="TEXT;" + TextFilePath, Destination...blah blah

I knew it had something to do with those quotation marks near TEXT. Maybe this will help somebody...someday. Thanks.

Reply With Quote