Okay, so here's the fix I found that is all right if you ask me. 1. Open Excel, create a module in the Visual Basic Editor In this Module create a Sub: Sub Auto_Open() GetInfoFromSW_Array = CreateObject("SldWorks.Application").ActiveDoc.Extension.CreateMassProperty.CenterOfMass Range("A1").Value = G...

JRL wrote:Congratulations, that is a correct answer and is the exact answer I was looking for....

Thanks for the points!!! And thanks for the fun puzzle.

Thanks for your time Marcus, I think I finally understand what's causing the headache. The problem seems to be the VBScript way of handling variable types and SolidWorks way of handing the VBScript double formated arrays. I found this post on a Matlab forum (many years old, no solution to the proble...

Ooooh ... that's pretty fundamental. Sorry for not knowing that. So in other words, it's not possible for me to retrieve the values from the SW API using VBScript? Everytime I try to assign a variable a value from the array I get the error and that's because of the limitation of VBScript? I'm really...

Yeah, Marcus... I'm always showing off

Anyway here's the not so super hard way to do the same thing:

Sorry for not sticking with the rules (I'm 50+ posts) but I have waited almost a whole week! Anyway here's a super hard coded solution to assign a variable the text "1+1". I.e. it's not very dynamic.

I still need help with this issue. Solving it would take a huge headache away from me. Sorry for spamming but I suspect that my problem is not very well explained by me. Here's my latest try: Test in Excel Below code is run without any problem using the Visual Basic Editor in Excel. The code is used...

Hello Marcus, I'm not sure we're on the same page here, I'll make a try to make it more clear: My first picture above display the code and the resulting MsgBox in Excel. The result is collected from SolidWorks using the API call. The value "1,6244...E-03" is the third (2) value in the Double() forma...

If I break it up I still get the same error when trying to assign a array value to a string. I.e. my example: "MessageToDisplay = GetInfoFromSW_Array( x )" where x = 0 or 1 or 2 (because this is the size of the array that I get from the API call). If I do the exact same thing in Excel VBA I get what...

Thank you for the reply Marcus! I still have problem passing the Double array values. I started messing around in the Excel Visual Basic editor and to my supprise the "same code" worked like a charm! Can someone please tell me I'm doing something really stupid in MS that messes upp my execution of t...

Hello, I have googled and tried to find the solution to my problem but I have yet to find it. The problem I have is that when I try to get the CenterOfMass from SolidWorks using the API I cannot snag the output. I'm really new to VB but have got this to work when just trying to obtain the "Mass" fro...

Thanks Rain for your help. I will read more about it... I'm kinda freaked out by the fact that I would need to involve more script languages = might be hard to over look when searching for errors. But I'll give it a shot. Thanks once again!

Hi there, I'm not sure how to make use of the .hta window. It cannot be dynamic as far as I can tell. It's not possible to throw stuff to it the same way as to Message> for example: Let>DOT_TO_DISPLAY= Let>NUMBER_OF_DOTS=0 Let>k=0 Repeat>k Let>k=k+1 Wait>1 Let>NUMBER_OF_DOTS=%NUMBER_OF_DOTS%+1 Let>D...

Thanks for showing this Rain. Will use it for now... it involves writing a ".hta"-file to a temp folder which is not what I'd like but it'll do for now. Thanks again Rain for helping me.

I'm hammering away on this subject: If this is ever implemented it would be great if the Message> , MessageModal> , Ask> and Input> would be HTML enabled. Alot of time I use these to inform users about errors and or update information etc. etc. and today they are really gray... It would be awesome t...