system
January 29, 2009, 5:30pm
#1
I have a multi-tab DeskI report. Using VBA, I want to export only one specific tab to excel, not all of them. Please advise if and how this can be done.
ljpitre (BOB member since 2008-04-24)
system
January 31, 2009, 10:55am
#2
There is a similar add-in the downloads section of BOB, check here
This is in continuation to [url=http://www.forumtopics.com/busobj/viewtopic.php?t=16866]this [/url]thread...
The add-in allows you to convert *.rep files to txt, xls and pdf files.
It also lets you choose which tab you want to export and much more.
We have tested the add-in in WinXP and Win2K. If you have any suggestions or questions please post them in this thread.
The fully documented version can be downloaded [url=http://www.xpertservice.com/zip/DocConversions.zip]here[/url].
One more ti…
.
haider (BOB member since 2005-07-18)
system
February 2, 2009, 2:22pm
#3
This should do it …
ThisDocument.Reports("tab name").ExportAsExcel("filename.xls")Dwayne Hoffpauir (BOB member since 2002-09-19)
(BOB member since 2008-04-24)
(BOB member since 2005-07-18)