system
May 25, 2005, 9:36pm
#1
Hi All,
I am trying to dump the result set of a BO data provider into an existing excel file.
I understand I can loop through and dump the values with code like
ThisDocument.DataProviders(“MyDp”).Columns.Item(1).Item (1)…
However, is there an easier way to do it?
Currently I save the BO query as a txt file, then start excel and open the text file. It would be great if I could skip the intermediate step of saving the BO data to a text file and then having to load it back into an excel object.
Any help would be greatly appreciated.
Thanks!
Eric
ebowden00 (BOB member since 2005-05-25)
system
May 26, 2005, 9:22am
#2
look just behind…
Hi,
I am using this code for excel export. I am getting error when i copying the sheet from one work book to final workbook.
" [b:6e5cbf0da9]source_workbook.Worksheets.Move Before:=final_workbook.Worksheets("Sheet1") [/b:6e5cbf0da9]"
Can anyone help on this..?
Thanks in advance.
Sub expToExcel()
'Things to Add
'Add a sheet in the final Excel file depending upon the number of books in the report
'as by defalut there
'***********************************************************************…
laguiff (BOB member since 2005-05-13)
system
May 26, 2005, 1:39pm
#3
However, is there an easier way to do it?
Currently I save the BO query as a txt file, then start excel and open the text file. It would be great if I could skip the intermediate step of saving the BO data to a text file and then having to load it back into an excel object.
Any help would be greatly appreciated.
Have a look at this post for some other alternatives.
Dwayne Hoffpauir (BOB member since 2002-09-19)