Can anyone help with this problem.

I have used the code below to open and update a PowerPoint 2007 presentation from an Excel 2007 workbook. The presentation is saved as a pptx file with each slide being a linked copy of a range of Excel cells. When the user clicks on a button in Excel it opens the presentation and forces an update of all fields. This works well on my computer, but having sent the files to somebody else (also using Office 2007) it will not work on her computer.
When she clicks on the button in Excel it opens PowerPoint but fails to open the presentation, instead giving an error message: “Object variable or with block variable not set”. I have checked various obvious problems, but cannot get to the bottom of the problem.
1. The PowerPoint file is in the correct folder on her computer
2. She has macros enabled in Excel
3. She seems to have the appropriate resources checked in Tools…References.

I would be very grateful for any ideas

Please Login or Register  to view this content.