VBA code to open a file with a dynamically changing filename

[orangeman2003]

Hi,

I have a command button that when clicked exports an Access table to an Excel spreadsheet but the filename is dynamic so it adds a string (currently 'Test') as well as the date the file was exported. Now I want to add code to open the file once the data has been exported. However, I am not sure what to do about the filename since it is dynamic and not static. I can't point VBA to a specific file since the file to open depends on the day the data was exported

Thanks

[June7]

You want to open the file immediately after the export? So you know the name of the Excel file that was just created because you just built that file name with the code that did the export?

Review http://allenbrowne.com/func-GoHyperlink.html