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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exporting to Excell

Status
Not open for further replies.

doyouknow

Programmer
Nov 5, 2002
3
CA
Hi
I have an application which creates reports. The problem is I want to convert the report to Excell. However, there is a cover page to the report which contains text and screws up the formatting when exported to Excell. Is there any way to delete the first page before exporting? I wouldnt want to completely get rid of the cover page as it contains important information for people who just print the report out. I tried copy and paste from Word and again the formatting doesnt work very well.

 
A quick solution could be:

Your report is driven by a Query or Table. It may be possible (based on your report design) to simply take the query and export it to excel.
 
Except the report is built on calculations in Visual Basic as well as the query
 
Copy your report (Make a duplicate for your use)
Remove the cover page from the duplicate.

1 report for your export and 1 for everyone else
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top