does Excel Viewer support macro?

V

Volodia

I have try but Excel Viewer 97 and Excel Viewer 2003 have not process a
macro.
Is it done by design, or there are some registry to enable this processing?

My task is to activate correct worksheet after file is open in Excel Viewer.

Thanks,

Volodia.
 
A

Alan

The Excel viewer is just that, a viewer to see the end product, the results
of the spreadsheet. It has no functionality at all as far as I'm aware,
Regards,
Alan.
 
V

Volodia

Yes you are absolutely right. I did simple test.

1. I have created excel file where sheet1 cells is linked to sheet2 cells
( =Sheet2!B5 )
2. By using ADO did update of Sheet2 in excel file.
3. Use Excel to open Sheet1 - correct linked value is shown.
4. Use Excel Viewer to open Sheet1 - old (before update value) is shown.

Therefore no processing is done by Excel Viewer - just view file as is.
 
Top