Computing.Net > Forums > Office Software > Link visio to specific wksht excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Link visio to specific wksht excel

Reply to Message Icon

Name: MrBedo
Date: June 20, 2006 at 07:37:10 Pacific
OS: Win XP
CPU/Ram: 2gb
Product: Dell
Comment:

I've not really used Visio before but now need to create a diagram with shapes that can link to specific worksheets in an excel spreadsheet.

I can create a link to an excel file without any problem, but I want different shapes to open different worksheets within that one excel file.

Is this possible ?

I'm using Visio Pro 2003 if that makes any difference.

thanks in advance for any help



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: June 20, 2006 at 08:09:25 Pacific
Reply:

I don't believe that's possible from within Visio. In Excel, you could create a macro that will take you to the sheet you desire. You may be better off creating a new workbook for each sheet.

Life is more painless for those who are brainless.


0

Response Number 2
Name: MrBedo
Date: June 21, 2006 at 03:34:56 Pacific
Reply:

Thanks for the reply, it is possible I've just figured out.

In Visio you create the standard hyperlink, you then append the worksheet name and cell range to the end. You have to use the following format for it to work:

myexcel.xls#worksheet1!A1

This would open the Excel file called myexcel.xls on the worksheet named worksheet1, and the focus would be in the cell A1

cheers
rich


0

Response Number 3
Name: Jennifer SUMN
Date: June 21, 2006 at 12:04:59 Pacific
Reply:

Oh yeah. That'll do it. LOL Glad you figured it out. :)

Life is more painless for those who are brainless.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Office 2000 Lost Document



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Link visio to specific wksht excel

Move to specific page in excel work www.computing.net/answers/office/move-to-specific-page-in-excel-work/4910.html

linking data to columns that havent www.computing.net/answers/office/linking-data-to-columns-that-havent/6833.html

i want to open different excel file www.computing.net/answers/office/i-want-to-open-different-excel-file/2461.html