Robot Structural Analysis Forum
Welcome to Autodesk’s Robot Structural Analysis Forums. Share your knowledge, ask questions, and explore popular Robot Structural Analysis topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

10 REPLIES 10
SOLVED
Reply
Message 1 of 11
Rafal.Gaweda
3689 Views, 10 Replies

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

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)



Rafal Gaweda
10 REPLIES 10
Message 2 of 11
Rafal.Gaweda
in reply to: Rafal.Gaweda

Newer version in attachment



Rafal Gaweda
Message 3 of 11
Rafal.Gaweda
in reply to: Rafal.Gaweda

Corrected opening files in Excel



Rafal Gaweda
Message 4 of 11

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?

Message 5 of 11

Hi @ledinhchinh0409

 

Here you are



Rafal Gaweda
Message 6 of 11

hi. @Rafal.Gaweda

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

Message 7 of 11

Hi @ledinhchinh0409

 

Try attached.

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



Rafal Gaweda
Message 8 of 11
piperr
in reply to: Rafal.Gaweda

This is amazing @Rafal.Gaweda !!!

Message 9 of 11

@Rafal.Gaweda

It worked very well. Thank you very much!

Message 10 of 11

That's very useful, amazing @Rafal.Gaweda

Keep on Smiley Happy


Muhammed Mamdouh (OPERA)
Structural Engineer, Instructor
Facebook |LinkedIn

EESignature

Message 11 of 11
jmmarin
in reply to: Rafal.Gaweda

Thank you. It is very useful!!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report