iLogic Excel2016 NamedRange

iLogic Excel2016 NamedRange

Anonymous
Not applicable
444 Views
1 Reply
Message 1 of 2

iLogic Excel2016 NamedRange

Anonymous
Not applicable

Hi. 

 

I'm trying to use NamedRange with excel but everytime I run the code the excel stops responding and shutsdown and them I get an RPC Server Unavailable. 

 

The code I'm trying is the one in iLogic templates

 

GoExcel.Open("C:\Users\XPTO\Desktop\a.xlsx", "Sheet1")

MsgBox(GoExcel.NamedRangeValue("Part"))

Even with an empty excel I get the same error. 

 

I'm Using:

Inventor 2017

Windows 10 64bits

Excel 2016 64bits

0 Likes
445 Views
1 Reply
Reply (1)
Message 2 of 2

HermJan.Otterman
Advisor
Advisor

the code works form me,

 

I have excel 2013...

 

the named range has to reference only One cell!

did you check capitals? "part" "Part" "PART" 

 

If you google for RPC server Unavailable you find several items related with Windows 10 and this RPC error

If this answers your question then please select "Accept as Solution"
Kudo's are also appreciated Smiley Wink

Succes on your project, and have a nice day

Herm Jan


0 Likes