Hello all,
I am having an issue with some vb code and importing data from a .csv file. I have a software program that we export a series of data out of every morning. When the first series of data is exported it is saved in the format of "query_export_results.csv". However, the next series of data that is exported has a random file name that looks like query_export_results[1].csv or query_export_results[3].csv, where the [number] randomly changes. I'm not sure what makes the bracketed number change, but I usually have to redo the export until the number changes to a [1] otherwise the following code will not work:
Is there a way to activate this window and ignore the bracketed number? Does anyone know what may cause the bracketed number to appear or change? Temporary file maybe?
Any help would be appreciated.
Darv
I am having an issue with some vb code and importing data from a .csv file. I have a software program that we export a series of data out of every morning. When the first series of data is exported it is saved in the format of "query_export_results.csv". However, the next series of data that is exported has a random file name that looks like query_export_results[1].csv or query_export_results[3].csv, where the [number] randomly changes. I'm not sure what makes the bracketed number change, but I usually have to redo the export until the number changes to a [1] otherwise the following code will not work:
Code:
Windows("query_export_results[1].csv").Activate
Any help would be appreciated.
Darv