Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

visio to excel

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
i need to move data(e.g. text) within shapes on a Visio flowchart into MS Excel cells. i found a wizard that moves data from Excel to Visio but not the reverse order which is what i'd like to do. i'm thinking i can use the VB Editor to possibly do this but i'm not quite sure of the code.
 
I haven't had any problems with this
It's probably a good idea to ignore Wizards as soon as you want any Real control over things :)
Get the excel-document with GetObject, or something
Get the desired sheet
set the values of cells by:
sheet.cells(x,y)="MyData"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top