Visio Files and Excel

williec00

New Member
Joined
Oct 9, 2002
Messages
12
Is there anyway that I can import a visio file as a page of a workbook? I want to get all info for a certain product into excel so my guys can hit print entire workbook and get everything they need for that product (which at this point is 2 worksheets and a visio workflow diagram). Alternatively if I could some how link the workbook and the visio file to be printed together that would work as well but I don't know how to do that either....

Any help would be AWESOME....

Thanks

WillieC
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
Willie,

Instead of exporting to XL another approach is to download and install the MS Visio Viewer from MS (freeware):

http://office.microsoft.com/downloads/2002/vviewer.aspx

Another approach is to save it as a picture and then let XL paste in into a worksheet via VBA.

However, there is certain limitation which cannot be override....

Please mail back if further help with VBA is required :)

Kind regards,
Dennis
 

williec00

New Member
Joined
Oct 9, 2002
Messages
12
I saved the file in Visio as a *.jpg. I then imported it into Visio. It definitely accomplished what I need to do but the print out is much lower quality through Excel then in Visio. I can work with it for sure but is there anyway to get the higher quality printout?

Thanks in advance..

WillieC
 

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
Willie,

Have You played around with different image-format like the EPS or TIFF?

Except for that it´s propably subject to the printers ability.

..and I´m not an expert neith with image-format and printers......

Kind regards,
Dennis
 

Watch MrExcel Video

Forum statistics

Threads
1,122,691
Messages
5,597,562
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top