yes I am still embedding. I had to reverse the first 2 lines and put the iProp portion in front to keep the excel file from being written to.
iProperties.Value("Custom", "Gauge") = GoExcel.CellValue("3rd Party:Mild Steel Gauge Chart.xls", "Sheet1", "A1") iProperties.Value("Custom", "DecValue") = GoExcel.CellValue("3rd Party:Mild Steel Gauge Chart.xls", "Sheet1", "B1")
'MultiValue.List("Gauge") = GoExcel.CellValues("Mild Steel Gauge Chart.xls", "Sheet1", "A2", "A35")
'MultiValue.List("DecValue") = GoExcel.CellValues("Mild Steel Gauge Chart.xls", "Sheet1", "B2", "B35")
'Parameter("Thickness") = DecValue
'Parameter("Gauge") = Gauge
iProperties.Value("Project", "Description") = Gauge & " x " & Length & " x " & Width
I figured out why the Muli value list were failing.... there was no "3rd Party:" in the statement. I used the snipett so I figured it should have been right....
Then I got to thinking about jletcher responce and figured out what was missing. Now I just need to figure out how to get the Gauge and DecValue to change correctly so that if I pick 12Ga then the thickness changes to .1046
The thing is your code is not correct for embedding.
It should be 3rd Party:Embedding 1
Your code is telling it to find a excel file...
If you code is some what working it may see the excel file you made before Embedding. (un-likley)
To me the code will not work for embedding.
What are you sheet metal styles named?
To me you are still going a long way to get what you are asking.. To me all this should be done with ilogic forget about the excel file..
Let me see if I have a few minutes to put a sample together. Till then look into just using ilogic.
Do me a favor take a snap shot of the browser with it expanded..
I guess I am not sure what you mean by just using iLogic.....
Something like this...
If Gauge = 12 Then
Thickness = .1046
Ok after looking at your Browser you are not Embedding you are linking they are not the same so this is why you are having issues.
Yes and no on the code for ilogic.
There is some set up to do.
Let me ask this do you have sheet metal styles set? If so give me a snap of your styles..
But as far as your code you have it will not work because your excel file is not Embedded Look at this pic this is embedded.
See the difference?
I would give you my templete but the styles have to be the same..
Ok then if I am not embeddeing, which I wasn't sure I was, how then...noob question comming....do you embed a file and get it to function?
As far as the sheet metal style set goes...since I have no idea what you are talking about .the answer is nope...
I figured out I needed to "Insert Object" in order to have it embedded. See attachment for results.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.