If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot run RUNADDON in Visio 2003 Professional
I have a pretty large org chart (33 pages so far) that I want to have fully refreshed on opening the file (and ideally, also on demand).
Even though I have set every page to "refresh on open", only the page that is active when the file open is being refreshed. I have therefore tried setting up a macro that loops through all my pages and executes RUNADDON("Database Refresh"). The loop is working great, but the RUNADDON function is not recognised - "Sub or Function not defined" is what I get. This is driving me crazy because I am sure there is a simple answer to it - HELP please! Note I can manually refresh page by page, using the Refresh Add-on, or right-clicking on the page and selecting refresh. |
#2
|
|||
|
|||
Cannot run RUNADDON in Visio 2003 Professional
Ran into it when I was doing some timeline stuff. The runaddon format
changed Set objApp = Visio.Application Set objAddOn = objApp.Addons.Item("TheAddonName") do some setup stuff Application.DoEvents objApp.AlertResponse = 1 ' do alert response if you expect a prompt objAddOn.Run ("/cmd=3") ' the unique command is optional objApp.AlertResponse = 0 your mileage may vary, Al "Rose" wrote in message ... I have a pretty large org chart (33 pages so far) that I want to have fully refreshed on opening the file (and ideally, also on demand). Even though I have set every page to "refresh on open", only the page that is active when the file open is being refreshed. I have therefore tried setting up a macro that loops through all my pages and executes RUNADDON("Database Refresh"). The loop is working great, but the RUNADDON function is not recognised - "Sub or Function not defined" is what I get. This is driving me crazy because I am sure there is a simple answer to it - HELP please! Note I can manually refresh page by page, using the Refresh Add-on, or right-clicking on the page and selecting refresh. |
#3
|
|||
|
|||
Cannot run RUNADDON in Visio 2003 Professional
LOL, yes, my mileage does vary!
It seems I am now getting further than before but the .Run won't execute, it seems to want some parameters (error 450), and , despite searching low and high for a description of the DBRS function, I can't find anything anywhere. Perhaps someone from Microsoft can post a working bit of sample code, with explanation of the possible parameters? |
Thread Tools | |
Display Modes | |
|
|