Tag Archives: macro

VISIO: Auto Save Pages to PNG

Hello again! This particular post is again an actual solution to one of the problem that my team faced. As you all know that we use VISIOs in every project to make process flows, organization chart and lot of other non-project things 🙂 to present the information in a very nice manner.

Also, the VISIOs are normally kept together in pages of a single VSD file. It happen to be the case that we were asked to create PNG/Images from the VISIOs – all pages and embed into word document. There were 4 VISIO files with 40 pages each and it was damm time consuming to do -> File -> SaveAs -> PNG for all VISIO pages.

I happened to know a bit of VB programming under VISIO and wrote a small piece of code. This code requires a new VSD to be created and give input the VISIO/VISIOs to save all pages to a PNG file based on the page name.

Now, my team is using this utility to manage the change reflect all the PNG in fraction of sections.

Procedure to use this code:

1. Create a new VSD file
2. Enable Macro
3. Open Code Editot Alt+F11
4. Paste the Code
5. Run

Below is the code:

VISIO_PAGE_PNG

The code can be download from HERE.

Hope you find it useful!

“Automation does not make optimism obsolete.”
– George Keith Funston

Advertisements

Excel Auto Numbering with INDENT

This post is about a situation I ran into last week. I was supposed to prepare a very-long WBS (we all know how long a WBS can be for a quite significant program). I was putting sections in the WBS with indentation and grouping as normally all of us do. Hence I prepared something like below (of course this was not my WBS 🙂 but on the same line)

After preparing a WBS with ~800+ rows, I came across the complete view of the WBS where I have to put in the index and that too as per the INDENTs as below for example:

You can assume how much time it could take to index w.r.t the indents manually. Also, take into consideration the N number of reviews that happen in WBS and result in addition or deletion of rows. So, I thought of using Macro in EXCEL for this situation. Finally after some time, I was able to automate it with just a click of button! I loved it!

Just download the module for the macro HERE and import into excel application. Save it. Just use the function in the CELL as shown in the below:

Automation can be useful!

“The secret to creativity is knowing how to hide your sources.”
– Einstein