Running Macro from workbook embedded in PPT

[malasingh]

Hi All,

I am using Office 2007.

I have an intriguing problem with a ppt addin.

The default PPT addins location is ‘C:\Documents and Settings
\Administrator\Application Data\Microsoft\AddIns’ – it is a trusted
location.

I have 2 files in this folder – a ppt addin and a ppt presentation
containing 2 slides – each of the slides has an embedded Excel 2007
workbook containing macros.

The PPT addin is registered as an active addin in Powerpoint.

The addin does this: Adds 2 buttons to the Addins tab in PPT and opens
the ppt presentation in the background (without a window). Clicking
one of these buttons in the add-ins tab copies one of the mebedded
Excel workbooks from the invisible ppt to the current slide. So far so
good. Since the ppt addin is in a trusted folder (C:\Documents and
Settings\Administrator\Application Data\Microsoft\AddIns is marked as
trusted) – the addin code runs.

BUT…

The inserted workbook also contains macros – when I activate the
embedded workbook newly pasted in the current slide to edit the data,
the macros are disabled. Adding the C:\Documents and Settings
\Administrator\Application Data\Microsoft\AddIns folder to trusted
locations in Excel options does not work – a reason could be that the
workbook is not saved in this location as a file – it is an embedded
(macro enabled) workbook on a ppt slide.

The end user cannot allow setting macro option to allow all macros to
run.

Apart from using digital signatures, is there a way to do this?

Thak you,
Mala

 

[Chirag]

You could perhaps make an Excel add-in with the workbook macros in it and
then call the Excel add-in's functions from your PPT add-in.

Another way is to directly automate Excel from PPT. This requires the
workbook macros to be available from PPT add-in. The workbook macros would
probably need to be modified to work from a PPT add-in.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html


Hi All,

I am using Office 2007.

I have an intriguing problem with a ppt addin.

The default PPT addins location is ‘C:\Documents and Settings
\Administrator\Application Data\Microsoft\AddIns’ – it is a trusted
location.

I have 2 files in this folder – a ppt addin and a ppt presentation
containing 2 slides – each of the slides has an embedded Excel 2007
workbook containing macros.

The PPT addin is registered as an active addin in Powerpoint.

The addin does this: Adds 2 buttons to the Addins tab in PPT and opens
the ppt presentation in the background (without a window). Clicking
one of these buttons in the add-ins tab copies one of the mebedded
Excel workbooks from the invisible ppt to the current slide. So far so
good. Since the ppt addin is in a trusted folder (C:\Documents and
Settings\Administrator\Application Data\Microsoft\AddIns is marked as
trusted) – the addin code runs.

BUT…

The inserted workbook also contains macros – when I activate the
embedded workbook newly pasted in the current slide to edit the data,
the macros are disabled. Adding the C:\Documents and Settings
\Administrator\Application Data\Microsoft\AddIns folder to trusted
locations in Excel options does not work – a reason could be that the
workbook is not saved in this location as a file – it is an embedded
(macro enabled) workbook on a ppt slide.

The end user cannot allow setting macro option to allow all macros to
run.

Apart from using digital signatures, is there a way to do this?

Thak you,
Mala