I Am creating a massive procedure which creates a powerpoint based on information which is E-mailed to my database's E-mail address (yes, it has it's own E-mail address). It gather's information from an XLS attachment in the E-mail. All of that works just fine. The problem I'm having seems really simple:
within the VB application
Set ActivePresentation = GetObject("c:\manning data\enlisted manning shell.ppt" 'Named to avoid confusion
Set PowerPoint = ActivePresentation.Application
blah, blah blah... (code to alter the powerpoint this all works just fine)
ActivePresentation.SaveAs ("c:\Manning Data\Manning" & Format$(Now(), "ddmmyy" & ".ppt"
ActivePresentation.Close
PowerPoint.Quit
Set PowerPoint = Nothing
Set ActivePresentation = Nothing
The problem lies in the fact that in the task manager, powerpnt.exe remains, and I can only open the file it was saved as (SaveAs line) in Read-Only. And the only way I have to open it in non-read only is to end task on powerpnt.exe ... not cool, I need it automated. The person who will be clicking the button linked to this procedure doesn't even know what the task manager is! Please help. My computer doesn't love me anymore!
PervinPJ
within the VB application
Set ActivePresentation = GetObject("c:\manning data\enlisted manning shell.ppt" 'Named to avoid confusion
Set PowerPoint = ActivePresentation.Application
blah, blah blah... (code to alter the powerpoint this all works just fine)
ActivePresentation.SaveAs ("c:\Manning Data\Manning" & Format$(Now(), "ddmmyy" & ".ppt"
ActivePresentation.Close
PowerPoint.Quit
Set PowerPoint = Nothing
Set ActivePresentation = Nothing
The problem lies in the fact that in the task manager, powerpnt.exe remains, and I can only open the file it was saved as (SaveAs line) in Read-Only. And the only way I have to open it in non-read only is to end task on powerpnt.exe ... not cool, I need it automated. The person who will be clicking the button linked to this procedure doesn't even know what the task manager is! Please help. My computer doesn't love me anymore!
PervinPJ