Plot points from an import of xy absolute coordinates in a excel file

[bendesarts]

Surrogate,
If I understand, I should create this code in visual basic but in visio. --> OK
But, after how the excel file containing the xy coordinates of the points is called ?
thank you for your help

[Surrogate]

I should create this code in visual basic but in visio. --> OK

yes, you are rigth. my code for VBA IDE build-in Visio

But, after how the excel file containing the xy coordinates of the points is called ?

my code use late binding ! there i define Excel Application and Excel's ActiveWorkbook

Code Select Expand

Dim ea As Object ' Excel Application
Dim ew As Object ' Excel Workbook
Set ea = GetObject(, "excel.Application")
Set ew = ea.activeworkbook if workbook with xy-coordinates is activeworkbook, my code read these data from 1st sheet of that workbook, from first and second columns !

2. fill x values in 1st column.  fill y values in 2nd column

no magic, just code !

[bendesarts]

OK

1) May you help me to put the right code to specify correctly the full directory path to the file and the good sheet in the excel file ?

Here my proposal but the sheet of the excel file is not specified for the moment :

Code Select Expand

Dim ea As Object ' Excel Application
Dim ew As Object ' Excel Workbook
Set ea = GetObject(c:\[b]windows\test\ExcelFile[/b], "excel.Application")
Set ew = ea.activeworkbook

2) with this code, is the sheet selected the sheet1 by default ?

Thank you for you feedback

[Surrogate]

help me to put the right code to specify correctly the full directory path

You don't need put directory path to GetObject function, it is Optional argument !

GetObject Function

2) with this code, is the sheet selected the sheet1 by default ?

Yes.
try this file

[bendesarts]

Great it works well!
Perfect, thank you for your help