Visio Macro that can Save as the visio sheets into html.

Hi,

Visio Macro that can Save as the visio sheets into html.
This is the continuation of Scott's macro that needs to save all all the rows converted to charts and saved as Html.

Need the file names as NTlogin's and saved as html. All files into 1 folder.

Regards
Sharath
LVL 11
bsharathAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

marklorenzCommented:
Check this out:

automate exporting a Visio drawing as an HTML document set
http://support.microsoft.com/kb/258489



0
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Sharath,

The attached file is essentially the same code we created in
   http://www.experts-exchange.com/Microsoft/Applications/Microsoft_Visio/Q_23854187.html
but it now assumes the header row in Excel is row 2 instead of row 1.

In addition, it now creates a web page for each Visio page. I've used the standard save as web page function in Visio so it creates a subfolder to contain all of the various files. After Visio creates the files using its naming structure, the macro renames each file to reflect the NTlogon of the user.

Note also that there are actually two files per user -- one is the html file and one is the jpg image of the Visio page. All html and jpg files are named beginning with "NTlogon = " so you'll find pairs of files like this:
   NTlogon = Sharathk.htm
   NTlogon = Sharathk.jpg

Just drag the html file to a web browser to see the results.

BTW, the default resolution for the jpg images is 800x600. Let me know if you'd like me to save them at a higher resolution.

Scott
Excel-to-Visio-to-html.zip
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Mark,

Thanks for the suggestion. The KB article you linked to applies to Visio 2000 -- and fortunately, there is much better and easier-to-use support for creating html pages in Visio 2003 and 2007.

You can see the code I used in the file posted above if you're interested. Otherwise, the Visio 2007 SDK has a couple of good examples (in fact, my code is adapted directly from the SDK examples).

Scott
0
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

bsharathAuthor Commented:
Thank U Scott checking now.
One question in the visio can i do any alignment. Is that allowed? Will that changes reflect in the html pages?
0
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Any changes you make on the background page called "Template" will appear on all Visio pages.
0
marklorenzCommented:
Thanks Scott - I'll check it out
0
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
One other suggestion -- you might want to save the Visio document as a .vst (Visio template) instead of as a .vsd. That way, each time you open it, it will create a new document into which to insert the pages, leaving the .vst "clean" for the next time.
0
bsharathAuthor Commented:
Thank U Scott for this help... :-)))
Works perfect...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Visio

From novice to tech pro — start learning today.