VBA macro needed : Two saves for the price of one ?

J

Jojo

Hi,
Could someone please put me a tiny script together ...
Here's what I need done.

I'm using MS Visio and I want to save my current files as a VSD file and
then save it again but as a PNG.
The PNG filename would be based on the currently focussed VSD filename.
(i.e. the one I just saved as VSD.)

The problem is
grabbing the filename out of the text string and
adding the PNG foldername and
zapping the VSD extension and
adding the PNG extension and
confirming that I want to squash the existing filename.PNG and yest to any
other options.

I'm no good with VBA. I know it's no big deal.
I could spend an hour on it and get it done.
But I have very little time and a deadline.
That's why I'm asking for help.

TIA

Jojo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One Macro needed, Save as VSD and export as PNG 1
Macro Needed, Two Saves in One 2
Macro needed, Two saves in One 3
Macro to export all pages individually as jpg or png 1
Creating Userform From Existing Macro 0
Setting style for inserted text 2
Saving clipboard image as BMP through VBA in Excel 0
Clipboard images to Bitmap files through VBA in Excel 4

Top