I have an excel spreadsheet that uses an access database as the datasource. It is accessed in VBA thru ODBC.
It creates a set of querytables, which are copied and pasted with transpose.
When a user clicks a graphs button, the table is copied and pasted again to another worksheet and a series of graphs are displayed. These are programatically written using VBA.
SO far, so good.
I then select a series of graphs, and copy and paste them to a word document. At the time, I was prompted to enable/disable macros as if I was opening the excel spreadhseet. The paste works OK.
However, anyone who has opened this word document on their PC, can no longer open an Excel spreadsheet from a folder. Windows fires up an installer dialogue, as if Excel is not installed.
I can still fire up Excel from the Program menu and get to spreadsheets that way.
Any help appreciated.
It creates a set of querytables, which are copied and pasted with transpose.
When a user clicks a graphs button, the table is copied and pasted again to another worksheet and a series of graphs are displayed. These are programatically written using VBA.
SO far, so good.
I then select a series of graphs, and copy and paste them to a word document. At the time, I was prompted to enable/disable macros as if I was opening the excel spreadhseet. The paste works OK.
However, anyone who has opened this word document on their PC, can no longer open an Excel spreadsheet from a folder. Windows fires up an installer dialogue, as if Excel is not installed.
I can still fire up Excel from the Program menu and get to spreadsheets that way.
Any help appreciated.
