G
Guest
I created a batch (.bat) file containing the move function
to change a file from .xls to .txt and it works fine. My
question is can I execute the batch file in a macro, then
use the TransferText function to grab the newly renamed
file and import it into access. What I have do so far is
to just use the below file address in the command line
section and then in the TransferText file name field I
gave the file name as what it would be it the .bat file
executes successfully. But when I run the macro, the
command (DOS) prompt opens up, but the file does not
change from .xls to .txt.
to change a file from .xls to .txt and it works fine. My
question is can I execute the batch file in a macro, then
use the TransferText function to grab the newly renamed
file and import it into access. What I have do so far is
to just use the below file address in the command line
section and then in the TransferText file name field I
gave the file name as what it would be it the .bat file
executes successfully. But when I run the macro, the
command (DOS) prompt opens up, but the file does not
change from .xls to .txt.