Export to Excel

[#1]

Hi,

I would like to know if there is any way to export many table object simultaneously into a single Excel file.

Thank you for your time

Ryu,

[Anonymous]

Ryu,

It can be done with a macro - export one table to Sheet1, another to Sheet2, etc.

Regards,

Michael

[Gysbert_Wassenaar · Accepted solution]

It's possible. See here for a solution.

[#4]

Thanks, that's what I thought

[#5]

Thank you very much, that was exactly what I was looking for.

[rsdhavle]

Hi Gysbert,

Thanks for the link and we could create a Export to excel feature. Few questions:

1) At access point suppose user click on the button(containing vbscript) will the excel be generated without any issue on users machine Or there are any limitations to this export to excel feature by using VBscripts?

2) If there are any limitations how to overcome those so that export to excel feature works smoothly on any local machine through access point

[#7]

HI

I am Getting the type mismatch error for this line 'Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)".

Could you please let me know.

And one more thing I want to extract to the same sheet in the work book(Can you please let me know how to do that?)

Thanks in Advance

Regards,

Rajesh

[#8]

Hi Ramesh,

Probably solved by now but for anyone searching with regards to the type mismatch error it's likely you haven't put the Sub () / end sub() on the VB subroutine.