"Analyze It with Ms Excel" filename Name

  • Thread starter Thread starter robbinma
  • Start date Start date
R

robbinma

Hello,

Is there a way of automatically calling this and specifiying the Excel
filename?
I want to send out an Excel version of a report and would like to
change the name of the report to reflect the data in there.
At the moment the filename is predetermined by the report name.
I don't want to change the report name as it is contents of the report
that define the name.

If possible I would like to avoid using SendKeys or something similar.

Regards,

Mark
 
You might try OutputTo on the click event of a command
button on form. Code would be something like:
DoCmd.OutputTo acOutputReport, "rptCertificate",
acFormatXLS, "F:\Access\Cert.xls", False

Look at the Visual Basic for Applications help topic on
OutputTo to see your options.

Roxie Aho
-----Original Message-----
Hello,

Is there a way of automatically calling this and specifiying the Excel
filename?
I want to send out an Excel version of a report and would like to
change the name of the report to reflect the data in there.
At the moment the filename is predetermined by the report name.
I don't want to change the report name as it is contents of the report
that define the name.

If possible I would like to avoid using SendKeys or something similar.

Regards,

Mark



------------------------------------------------
Click to expand...
 
Problem solved.

Found the following link on msdn which points to Output

' http://tinyurl.com/tp83

The following syntax seems to work:
DoCmd.OutputTo acOutputReport, "validation_report_rep", "microsoft
excel", "c:\valid_rep.xls", True

Regards,

Mark
 
Problem solved.

Found the following link on msdn which points to Output

' http://tinyurl.com/tp83

The following syntax seems to work:
DoCmd.OutputTo acOutputReport, "validation_report_rep", "microsoft excel",
"c:\valid_rep.xls", True

Regards,

Mark
Click to expand...



------------------------------------------------
~~ Message posted
from http://www.MSAccessForum.com/
Click to expand...
~~ View and post usenet messages directly
from http://www.MSAccessForum.com/
Click to expand...


WILL YOU SHUT THE **** UP? GOD YOU A ****ING RETARD!? IF NOT THEN WHAT THE
**** ARE YOU? **** YOU ALL IF YOU AINT DOWN WIT DA CLOWN!
 
Back
Top