B
BizMark
Hi guys - I'm new to this forum - I think I'm going to enjoy wadin
through the tips in here. I've been doing advanced Excel design an
VBA programming since 1998 but haven't come across this site before.
Anyway - I have a problem.
When using Office 97 I wrote a suite of macros for my employer whic
was designed to write variable query strings to apply to imported data
which would then be squirted into user-defined chart areas, cycle eac
'variable' variable (and all combinations thereof), copy the char
containing the data that matches, and paste into an output sheet as
metafile.
This was used to produce charts and tables for a survey whereby eac
participant needed a comparison of their data vs. everyone else EXCEP
theirs. This meant every table and chart in every copy of the repor
was unique.
I expanded this on user request to contain an option to throw out th
metafiles to slides in a newly created Powerpoint file instead of jus
piling them up in an Excel worksheet, along with all its possible pag
setup/page break problems.
This worked great until I hit Office XP. The problem occurs whe
creating a Powerpoint Presentation object from VBA, because when i
does so, the object contains an empty powerpoint window with task pan
- i.e. there is no active 'presentation' window. For some reason i
even seems impossible to 'Add' a presentation object to the applicatio
because there is no ActiveWindow.
Similarly, Powerpoint (along with Excel) doesn't allow you to 'ad
window' - i.e. you can't do Application.Windows.Add - you can only d
ActiveWindow.NewWindow - i.e. you can add a window with reference to a
existing window - but not if there is no existing window.
I've tried and tried and can just not start a Powerpoint XP object wit
a window to control the rest of the application and add presentations
slides etc. Even turning the Task Pane off doesn't help because th
app object simply contains a blank window (which doesn't count as a
ActiveWindow) reading 'Click here to create slide'. It is only whe
the user manually clicks on this area, that an ActiveWindow is the
created.
How do I get past this so that I don't have to make the applicatio
visible and wait for the user to manually click in the centre of th
screen to create an ActiveWindow? I want the process to remai
transparent and interaction-free as it was pre-XP.
Many thanks to anyone who can help.
Best Regards,
Mark Boulton
Londo
through the tips in here. I've been doing advanced Excel design an
VBA programming since 1998 but haven't come across this site before.
Anyway - I have a problem.
When using Office 97 I wrote a suite of macros for my employer whic
was designed to write variable query strings to apply to imported data
which would then be squirted into user-defined chart areas, cycle eac
'variable' variable (and all combinations thereof), copy the char
containing the data that matches, and paste into an output sheet as
metafile.
This was used to produce charts and tables for a survey whereby eac
participant needed a comparison of their data vs. everyone else EXCEP
theirs. This meant every table and chart in every copy of the repor
was unique.
I expanded this on user request to contain an option to throw out th
metafiles to slides in a newly created Powerpoint file instead of jus
piling them up in an Excel worksheet, along with all its possible pag
setup/page break problems.
This worked great until I hit Office XP. The problem occurs whe
creating a Powerpoint Presentation object from VBA, because when i
does so, the object contains an empty powerpoint window with task pan
- i.e. there is no active 'presentation' window. For some reason i
even seems impossible to 'Add' a presentation object to the applicatio
because there is no ActiveWindow.
Similarly, Powerpoint (along with Excel) doesn't allow you to 'ad
window' - i.e. you can't do Application.Windows.Add - you can only d
ActiveWindow.NewWindow - i.e. you can add a window with reference to a
existing window - but not if there is no existing window.
I've tried and tried and can just not start a Powerpoint XP object wit
a window to control the rest of the application and add presentations
slides etc. Even turning the Task Pane off doesn't help because th
app object simply contains a blank window (which doesn't count as a
ActiveWindow) reading 'Click here to create slide'. It is only whe
the user manually clicks on this area, that an ActiveWindow is the
created.
How do I get past this so that I don't have to make the applicatio
visible and wait for the user to manually click in the centre of th
screen to create an ActiveWindow? I want the process to remai
transparent and interaction-free as it was pre-XP.
Many thanks to anyone who can help.
Best Regards,
Mark Boulton
Londo