The machine is a Win XP Pro PC with Excel 2003 (no other office application).
My program is trying to open a csv file in a series of specific folders.
The .csv file has a variable part to its name (ProfileTable1, ProfileTable2 or other number) so I want to use a wildcard like
workbook.open (filepath &"\ProfileTable*.csv")
If I run the macro from my own machine (which uses Win7, MSOffice2010 and Excel2010), no problem
But from the WinXP PC, I get an error message stating the file cannot be found.
I can however open the csv file if I specify its exact name.
It seems that in the WinXP configuration with Excel2003, the use of a wildcard with the workbook.open method is not practical.
However, I still need to open these files without knowing their full exact name.
Thanks in advance for any hints
Regards
Olivier