breilly192
Technical User
I created an import macro utilizing the TransferText action, however, it requires the specific file name to be typed into the Action Arguments. Can an InPut Box be used to prompt the user to select the file they want and then incorporate that into the macro or would it be better to just run a DoCmd in VB?
On the other end, exporting a file with a macro that uses the OutputTo action the file format is limited to .xls if I want to use the exported data as a load file for another system. When I tried .txt format the exported file included field borders and other report-type features that make it unusable as a data file. I'd prefer to have a tab-delimited output file but it isn't an option in the format selections within Access action arguments for the macro. I can export to .xls and then save it as tab delimited, but that is a step I'd like to eliminate in order to automate this as much as possible for the user.
Any help here would be appreciated. If it can be done within Access macros would be ideal, however, if it can be done through VB modules that would be good, as long as it's not too complex for my non-programmer mind to grasp.
On the other end, exporting a file with a macro that uses the OutputTo action the file format is limited to .xls if I want to use the exported data as a load file for another system. When I tried .txt format the exported file included field borders and other report-type features that make it unusable as a data file. I'd prefer to have a tab-delimited output file but it isn't an option in the format selections within Access action arguments for the macro. I can export to .xls and then save it as tab delimited, but that is a step I'd like to eliminate in order to automate this as much as possible for the user.
Any help here would be appreciated. If it can be done within Access macros would be ideal, however, if it can be done through VB modules that would be good, as long as it's not too complex for my non-programmer mind to grasp.