"Analyze It with Ms Excel" filename Name

[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

 

[Roxie Aho]

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



------------------------------------------------

 

[robbinma]

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

 

[Rory]

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

------------------------------------------------
~~ Message posted

from http://www.MSAccessForum.com/

~~ View and post usenet messages directly

from http://www.MSAccessForum.com/

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