topic Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell in Robot Structural Analysis Forum

(API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Rafal.Gaweda — Fri, 14 Nov 2014 12:53:10 GMT

Macro for dumping all opened tables in Robot (with all tabs) to Excell

Wait patiently until "Dumping finished" message appears on screen

ANSI csv files are stored in windows %temp% (loaction can be changed in macro if one wants) so they can be reused if needed

(if files are not properly open in Excel, open VBA editor and play with code changing separators characters, relevant code marked in macro)

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Rafal.Gaweda — Mon, 21 Sep 2015 08:23:14 GMT

Newer version in attachment

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Rafal.Gaweda — Mon, 23 Nov 2015 08:15:12 GMT

Corrected opening files in Excel

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

ledinhchinh0409 — Mon, 29 Jan 2018 08:48:18 GMT

hi. @Rafal.Gaweda

Thank you, this is very helpful. But can export results in the 'sheet' in an excel file instead of the 'excel file' as it is now?

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Rafal.Gaweda — Mon, 29 Jan 2018 13:28:22 GMT

Hi @ledinhchinh0409

Here you are

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

ledinhchinh0409 — Mon, 29 Jan 2018 23:18:18 GMT

hi. @Rafal.Gaweda

Thanks very much. However when I export to excel it does not have the desired format.

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Rafal.Gaweda — Tue, 30 Jan 2018 08:02:39 GMT

Hi @ledinhchinh0409

Try attached.

If it does not work as you expect please change List Separator in Windows Regional Settings onto ";"

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

piperr — Tue, 30 Jan 2018 10:25:06 GMT

This is amazing @Rafal.Gaweda !!!

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

ledinhchinh0409 — Tue, 30 Jan 2018 23:51:04 GMT

@Rafal.Gaweda

It worked very well. Thank you very much!

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Muhammed.OPERA — Wed, 31 Jan 2018 00:03:54 GMT

That's very useful, amazing @Rafal.Gaweda

Keep on

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

jmmarin — Thu, 01 Feb 2018 07:48:49 GMT

Thank you. It is very useful!!

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

WALIDGIO — Sat, 29 Jun 2024 22:01:34 GMT

it does't work for my ROBOT 2025 and excel 2021

any way to fix it ?

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Stephane.kapetanovic — Tue, 19 Aug 2025 14:11:45 GMT

hi @WALIDGIO

You must first create the tables in your project so that the program can read them

Best Regards

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

LionelDallenne — Wed, 07 Aug 2024 14:06:31 GMT

Hi @Stephane.kapetanovic ,

As you said, robot tables need to be created so that the program can read them. However, it also only works when the table are visible and shown in Robot. Any ideas how to automate this? To make it more tangible, I would need the following table for instance to be retrieved (Results - Forces), hence autoatically opened in Robot.

Thanks!

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Stephane.kapetanovic — Thu, 22 Aug 2024 03:12:50 GMT

hi @LionelDallenne

Here is a brief example of the use of tables for the extraction of forces in bars

Best Regards

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

LionelDallenne — Fri, 09 Aug 2024 13:40:11 GMT

Thanks @Stephane.kapetanovic

It seems I'm now able to create the table I need within Robot.

Thanks for your help so far.

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

HoshangMustafa — Fri, 23 Aug 2024 07:34:48 GMT

Hi @Stephane.kapetanovic

I tried your excel file without success

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Stephane.kapetanovic — Thu, 17 Jul 2025 13:29:43 GMT

hi @HoshangMustafa

no problem here, are you sure you authorized the workbook macros when you opened it?

After downloading the file from the forum, you sometimes might need to unblock it via its properties to bypass security restrictions.

Best Regards

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

LionelDallenne — Sun, 25 Aug 2024 16:34:03 GMT

Hi @HoshangMustafa,

please make sure as well to unblock the Excel file in the file properties in Explorer.

Best regards,

Re: (API) Macro for dumping all opened tables in Robot (with all tabs) to Excell

Stephane.kapetanovic — Sun, 25 Aug 2024 17:26:27 GMT

hi @LionelDallenne

this is not the case it is an excel 97-2003, so no additional blocking

Best regards