Non Access programmer needs to export report to excel

[__Stephen]

I don't do access real well I'm the DBA for our company and I write
reports that everyone wants.

Needed to have a timed run of a report on a daily basis, so my boss said to
make an Access db with linked tables and put in a repot and a macro autoexec
to preview it.

Now I want to manufacture the date in text and use that date-text as an
output name for an excel file. The printed report spans 400+ pages.

The macros look pretty simplistic in that you pick an action and fill out a
few params and poof it works. How do I crunch text and use that as the name
for saving? In word or excel I can turn on the macros recorder and it will
gen code for me. Is this trick available in Access?

In C# I'd code something like this:
string date = "WIP"+Convert.ToString(System.DateTime.Now.Date);

TIA



__Stephen

 

[Rainbow01]

from Rainbow01 Hong Kong

no recording marco in Access, not like word or excel
by your wants to do so automatic, you must write VBA coding

conclusion: Use Access---> Must learn VBA

"__Stephen" 來函：

 

[Steve Schapel]

Stephen,

In the File Name argument of the TransferSpreadsheet action in your
macro, you would put the equivalent of this...
="C:\YourFolder\WIP" & Format(Date(),"ddmmyy") & ".xls"