Layout of Excel reports

[TwoBeAss]

Hi,
is there any way to define the layout of an excel report ? I am talking about colours, cell outlines, text formats etc...

Thanks for you support...
Tobi

[Yacine]

Difficult.
VBA can do that. You need to identify the object, open it, format and close. Tedious.
Easier would probably be to export the report and do the formating by means of a macro in excel, instead of Visio, then re-import.
Other option, write your own reporting routine and build a smartshape to represent the table.
None of these options are simple.

[TwoBeAss]

Thanks for your reply..
I think the best way would be to report via visio and have an excel template to import the report...

[Yacine]

Has someone tested Google's new AI? I like it.
Check this chat. (I haven't tested it).
https://g.co/gemini/share/ceab70ad170f

[TwoBeAss]

Not yet but looks promising.. Thanks