Ilogic prompting excel save? Help!

Ilogic prompting excel save? Help!

mslosar
Advisor Advisor
353 Views
2 Replies
Message 1 of 3

Ilogic prompting excel save? Help!

mslosar
Advisor
Advisor

I've use this bit of code numerous times in the past and now for some reason it's giving me an odd problem.

 

NewMat = GoExcel.CellValue("File.xlsx", "Info", "F30")
NewMat  = CStr(NewMat)

iProperties.Material = NewMat

 Nothing special - just go into Excel, find a value and make that value the material for the part.

 

Now, for some reason, everytime that code runs it's popping up a dialog to save the excel file. Why? it's not changing anything, just reading a value. Worse yet, it'll leave dead excel.exe's running in the task manager. Oddly not 1:1, not uncommon to be working and have it pop up 10 times then see 5 excel's in the TM.

 

Why is it trying to save the excel file now when it never did before?

0 Likes
354 Views
2 Replies
Replies (2)
Message 2 of 3

mslosar
Advisor
Advisor
Not sure why this started no working last week, but, adding displayalerts = false and a close statement seem to have fixed the issue...

Now, if I could understand why it wasn't a problem in the other stuff I've done over the last 18 months.........
0 Likes
Message 3 of 3

Anonymous
Not applicable

i'm haveing this same issue with Excel file wanting to save when no changes have been made. i'm still kinda new with iLogic so i'm curious to know what/how you wrote your code so that i can fix my issue.

 

thanks

0 Likes