Transfer Text with Variable file name

  • Thread starter Thread starter Steven
  • Start date Start date
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
 
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.
 
Back
Top