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