A previous question asked how to run a visio macro from within excel. The response code worked - but only if the Visio doucment was closed and required opening:
'Set objVisioDoc = objVisio.Documents.Open("C:\...\Visio file.vsd")
objVisioDoc.ExecuteLine "nameofmacroinVisio" 'change to the name of the macro within the Visio document that you want to run
How can I run this macro when the file is already open and I want it to remain open?
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.