Open Dynamic Filenames

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
strFileName = "Report " & Format$(Date(), "mmddyy") & ".xls"

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top