Random bracketed number in file name [3].csv 1

[darvistor]

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:

Windows("query_export_results[1].csv").Activate

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

 

[PHV]

Something like this ?

For Each w In Application.Windows
  If w.Parent.Name Like "query_export_results*.csv" Then
    w.Activate
    Exit For
  End If
Next

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[darvistor]

Awesome PHV! This works perfectly. You have no idea how happy you have made my group now as they wont spend so much time re-exporting data. Thanks!

 

[mscallisto]

The bracketed number may be changing from:
query_export_results[1].csv to
query_export_results[2].csv simply because

query_export_results[1].csv was already a "taken" file name so
query_export_results[2].csv is the next availble.

Before each import maybe you should remove the old files.