Thanks: With your MRExcel online reference and John Walkenbach's 1999
chapter Interacting with Other Applications (discovered on my own
bookshelf), I am now much more competent to do things off PowerPoint VBA
code. I can create as an object the Excel application, and ask for its
.Name, as well as .Quit it. And after much further trial and error, I
can now step through myExcelApp.Workbooks and open the workbook I want
to show, and then pick the sheet I want to show, all with Excel VBA
commands issued from PowerPoint VBA to myExcelApp.
This seems to also add a pushbutton solution to my problem "Opening a
workbook automatically always to the same Sheet (and Range)" of Nov. 17,
2011, answered with several solutions above my head at the time, by
David's Message #14831.
Roger Belling
P.S.: I have Office 2007, not Excel 2010, but besides, embedding is I
think not a solution for my slide show situation, because I like to show
my graphs in a context, where I can on request also show the data behind
the graph and how I got to them. My paper offers an "open books" policy
which I can follow up e-mailing a compressed "Background Package for
Drive D", and the equivalent in my slide show is to be able to browse
through the workbook I open from PowerPoint, and still be able to get
back to the next slide and the structured show.
--- In ExcelVBA@yahoogroups.com, "David Smart"
<smartware.consulting@...> wrote:
>
> Have you looked at opening it from PPT VBA ... perhaps from a button?
>
> The following thread talks about doing that and solves a problem
someone was
> having. http://www.mrexcel.com/forum/showthread.php?t=77613
> When you open Excel via VBA, your Excel Auto_Open won't run, I don't
think.
> Instead, you can use the PPT VBA to jump to the right place in the
Excel.
>
> If you're using 2010, then it looks as though you can embed your
spreadsheet
> in your presentation, which might be another solution.
>
> Regards, Dave S
>
> ----- Original Message -----
> From: "Roger" rogerbelling@...
> To: ExcelVBA@yahoogroups.com
> Sent: Tuesday, January 10, 2012 8:48 AM
> Subject: [ExcelVBA] Can I have Excel VBA check what PowerPoint slide
show is
> loaded?
>
>
> >I was unable to get Excel workbooks opened to a specifiable sheet and
> >perhaps cell range (by a run statement switch), and tried to
improvise with
> >an Auto_Open macro. This has the disadvantage that the workbook opens
to
> >the same point, no matter from where it is opened. I have a
PowerPoint
> >slide show that opens an Excel workbook (via hyperlink), and I would
like
> >the workbook to open normally when opened normally, and to a certain
graph
> >when opened from the slide show. So the Auto_Open would have to
detect at
> >least if any slide show is loaded, if possible which is its current
slide.
> >I noticed there are constants like xlMicrosoftPowerPoint, with which
Excel
> >VBA could conceivably look into other applications. Does anyone know
more
> >about that?
> > Thanks if you can help.
> > Roger Belling
> >
> >
> >
> >
> > ------------------------------------
> >
> > ----------------------------------
> > Be sure to check out TechTrax Ezine for many, free Excel VBA
articles! Go
> > here: http://www.mousetrax.com/techtrax to enter the ezine, then
search
> > the ARCHIVES for EXCEL VBA.
> >
> > ----------------------------------
> > Visit our ExcelVBA group home page for more info and support files:
> > http://groups.yahoo.com/group/ExcelVBA
> >
> > ----------------------------------
> > More free tutorials and resources available at:
> > http://www.mousetrax.com
> >
> > ----------------------------------Yahoo! Groups Links
> >
> >
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 10.0.1416 / Virus Database: 2109/4132 - Release Date:
01/09/12
> >
>
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar