Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can i use an excel template when exporting

Status
Not open for further replies.

funkmonsteruk

IS-IT--Management
Joined
Feb 8, 2002
Messages
210
Location
GB
I'm running several BO reports which export data to an excel spreedsheet using: report.exportasrtf("filename" & ".xls")

This works fine but i'd like the reports to do something when they are exported or altenatively i'd like to export the reports to an existing excel workbook, creating a new worksheet. Does anybody have any ideas?
 
If you have licensed the SDK you can use a VBA macro Stick to your guns
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top