How can I output a table to Excel using a date on a form as part of the filename?

MobiusDick

Hippy Materialist
Local time
Today, 19:54
Joined
Aug 23, 2007
Messages
23
Hello Everyone,

I'm having a slight problem with file renaming at the moment-

Basically I have an application that has a form ([frmSplitter]) that users enter a start and end date into.

The application then goes away does a series of calculations and outputs the results into an Excel spreadsheet.

All of this works fine except that I need it to produce a dynamic filename that concatonates the file path and the date that the user entered as the start date into frmSplitter.

Does anyone know how to use the contents of a text box or combobox as part of a file name for outputting please?

Cheers
 

Users who are viewing this thread

Back
Top Bottom