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@yahoo.ca>
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
>
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