Transfer Text with Variable file name

S

Steven

Ok, so I've got code that will go through the open file dialogue in access and now I'm trying to save the value of that file and feed it into a macro that does the transfer text delimited. I keep getting this error that the expression I'm entering is the wrong data type for the section. (the file name that I'm trying to set = to the variable that is saving the file name in my code "openTextFile".

I've also tried storing that value in a text box on a form or a command button...but no dice there either. Any help would be GREATLY appreciated

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
K

Ken Snell \(MVP\)

Are you using VBA code and/or macros? Post some more details about what
you're doing for the open file dialog, and whether you want to run
TransferText in macro or VBA, and we can suggest how to make it all work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 -- Importing Text File -- Nulls 1
Using text in a bookmark as the default Save As 2
Migrating contacts from thunderbird back to outlook 2
Unable to display Outlook 2003 Standard Toolbar 1
Export to Word with date as part of file name 0
Use external file variable in formula 2
dynamic hyperlink problems 1
VBA macro for reading text file into Excel 0

Top