Dynamic Filenames

[simsjr]

Hi There.

In our department, we create a daily Excel report and drop it in a
designated folder. We use the same naming convention each day we generate the
report - for example, today's report was called "Report 092804.xls". The
numeric portion of the filename reflects today's date, ie 09-28-04. With me?

Now, what we'd like to do is add a launch button to our Access 97
application that will launch "today's" spreadsheet, and then do the same
thing again each subsequent day. Since we have a consistent naming convention
- with only the date portion of the filename changing - is there a way for
Access to match today's date with today's filename?

 

[Marshall Barton]

In our department, we create a daily Excel report and drop it in a
designated folder. We use the same naming convention each day we generate the
report - for example, today's report was called "Report 092804.xls". The
numeric portion of the filename reflects today's date, ie 09-28-04. With me?

Now, what we'd like to do is add a launch button to our Access 97
application that will launch "today's" spreadsheet, and then do the same
thing again each subsequent day. Since we have a consistent naming convention
- with only the date portion of the filename changing - is there a way for
Access to match today's date with today's filename?

You can easily create the file name using:

strFile = "Report " & Format(Date, "mmddyy") & ".XLS"

How you "launch" it is up to you, Shell?

 

[simsjr]

I take "strFile" to be a variable declaration?

Sorry. I'm a little rusty with VBA!

 

[Marshall Barton]

Well, I expect you would add

Dim strFile As String

somewhere in the procedure.