How to export a group of text box and a chart without using a macro?

[Anonymous]

Hi,

I am trying to export a group of text boxes (without loosing the format) to excel. But the server where I will publish the QV report won't accept macros.

I am trying to have the right click >Export to excel functionality for all the fields at the same time.

Is this possible without a macro?

thanks in advanced.

[marcus_sommer]

Please provide the used code and also what happens when - any error-message?

- Marcus

[Anonymous]

I just downloaded the file that you posted and tried to run it.

[marcus_sommer]

Had you adjusted the file-path and name and also the ID's from the sheets and objects and another to customizing things?

- Marcus

[Anonymous]

I didn't touch anything, I just downloaded the file to see it working, but it didn't.