Hi All,
I have a third-party application that has a facility to export a data set directly to Excel (which the application opens without any interaction on my part). The file name that the application gives to the Excel data is in the format "Portal_nnnnnnnnnnnnn.xls" where "nnnnnnnnnnnnn"is a zero filled random number. (The file is created in C:\DOCUME~1\user\LOCALS~1\Temp\Portlet_nnnnnnnnnnnnn.xls")
I have another workbook that uses VBA to extract data from Portal_nnnnnnnnnnnnn.xls and format it in to something more visually appealling. Within my code I have had to hardcode the filename each time I generate the data from the third-party application.
Can anyone advise me on a VBA method of identifying the third-party-generated Excel instance so that I can reference it dynamically without having to hardcode the file name each time?
Many Thanks
dp
I have a third-party application that has a facility to export a data set directly to Excel (which the application opens without any interaction on my part). The file name that the application gives to the Excel data is in the format "Portal_nnnnnnnnnnnnn.xls" where "nnnnnnnnnnnnn"is a zero filled random number. (The file is created in C:\DOCUME~1\user\LOCALS~1\Temp\Portlet_nnnnnnnnnnnnn.xls")
I have another workbook that uses VBA to extract data from Portal_nnnnnnnnnnnnn.xls and format it in to something more visually appealling. Within my code I have had to hardcode the filename each time I generate the data from the third-party application.
Can anyone advise me on a VBA method of identifying the third-party-generated Excel instance so that I can reference it dynamically without having to hardcode the file name each time?
Many Thanks
dp
