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
----------------------------------
Tidak ada komentar:
Posting Komentar