I have recently inherited a PowerPoint file with 100+ shapes that have embedded Excel files that are linked to MS-SQL server views (yeah, I know ...)
There is a VBA procedure that is supposed to loop and and refresh these things. But the procedure keeps having unexplained issues: it can't find the server (it's there), commands to excel about backgroundquery=false run but don't change the property, variables don't hold values (I have a counter figuring I could start over at the last bad one, not at the beginning) ... Basically, it seems to me the Powerpoint VBA engine is a pile of dung; I can call any other program in the Suite from Access and not have anywhere near this amount of problems ...
Which leads to the question, should I just run the code from Access, calling PPT and Excel from our old friend (this all ver 2010 btw.)
thanks for letting me vent,
Steve Conklin
__._,_.___
Posted by: Steve Conklin <stephenmconklin@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (15) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar