Thanks Samdot , that worked well. I used ExportasHtm to write from each tab in the report to Html files, then opened each of these in Excel and copied them over to one Excel WorkBook. I didnt work each cell, I just copied using Workbool.Cells.Select. It worked but in the final Excel file, the...
How can I export data from within a report macro to Excel ? I can do an export to Text or RTF or HTM but I can seem to get it to go to Excel. anyone has any sampe code ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.