Excel 2016 to Visio 2003 Data Transfer -- 2



Require some code that takes a value from Excel 2016, opens a Visio 2003 file and adds that value to a slelcted textbox shape on a slelect Visio page.

So, we need:

Two pages in Visio file so code can be tested selecting correct page.

Two Shapes on Visio Page so we can test Selection of shape.

To transfer value from Excel to that selected shape.


This must be done using Late Binding.

I already have code (using early binding) doing this working with Excel 2010 & Visio 2003, but the Office or Excel Object Library in 2016 has changed and that code no longer works.

So need to use late binding, unless you have a better idea.

To recap.

From Excel, record a value, open a selected Visio file, open to selected visio page and add Value to Slelected Shape on page.

Aptitudini: Excel, Microsoft Visio, Visual Basic pentru aplicaţii

Vezi mai multe: transfer data word excel, transfer data book excel, transfer data pdf excel, need transfer data entry excel file, transfer data ms excel ms word ole technology, transfer data access excel sheet, transfer data outlook excel 2007, transfer data excel word using vba, transfer data excel word vba, transfer data excel works word, transfer data excel, install microsoft excel 110 object library, transfer data excel word, transfer data excel multiple sheet access table, write code transfer data sql server excel

ID proiect: #12131911