Hello All,
I'm new here and to VBA too. I wrote some codes in VBA using Excel. It works fine with SolidWorks 2007 SP0. Once I upgraded to SP2.2 my code bounced back with the Runtime Error 2147417851 (80010105).
I did check all the Reference Libraries. They are fine. My guess is I'm having a...
Hello All,
I create the text annotation using this command thru the Excel VBA.
Set Note = Part.InsertNote(Range("L2").Value)
It works fine. Now, if I want to modify this text box, I try to use those line code but it didn't work.
boolstatus = Part.Extension.SelectByID2("DetailItem117@Sheet1"...
Hello All,
I would like to make my annotation, located in the center of a rectangle, on a 2D drawing to relocate when I modify one side of the rectangle.
Any guru in VBA can give me few little hints, please. TIA.
Hi All,
I just uninstalled Soliworks 2005, completely cleaned the registry and directories. Then I installed Soliworks 2007.
Everything is fine until I wrote a small macro to test the VBA. Inside the VBA, the Ctrl+space and the browser work fine but I did not have the Auto Member list drop down...
I used this formula defined in the "name" to auto-update my charts. It works fine when the range filled with all data.
As soon as I have a blank cell in my data column, instead of filling the whole column (till the end of the data) as it supposes to do, it just fills part of it. Can...
I'm using IF('sheet 1'!A1>0,'sheet 2'!A2=A1,'sheet 2'!A2="")
to transfer the value of cell A1 to A2 but I always got a False statement even if A1=15.
I think that Excel doesn't allow to copy/transfer the content of one cell to another using IF().
Can anyone help me, please. Thanks.
I built a chart using "lines on 2 axes". The first data row is filled (i.e. Monday thru Friday) but the second row is not completely filled (i.e. Tuesday and Thurday only).
The end result is the chart showed the line of the 1st data row and 2 dots with the 2nd data row. It's normal...
I'm writing a small macro to copy and paste the partial row of data. The data will be updated everyday i.e. row 30 will row 31 tomorrow. I'm using a macro to indentify the poistion of the beginning cell and the end cell but I don't know how to put it in the Range() function...
