I am trying to automate this procedure. It imports a .csv file by clicking the "External Data" tab => "Text File." That part works, but is not automated. The only way I've seen to automate it is by selecting "TransferText" under the macro section and filling out the necessary info.
This way has been working terribly. It has become very inconsistent, rarely ever working. Seems to have problems overwriting an old file, and I'd rather use a variable as the filepath if possible. Is their any VBA code I can use to attempt to perform this? TransferText is not helping much at all.