Re: ActiveX



I believe the first argument has to be the path with the file name. The
second argument is the class. It appears that you have the file name as the
second argument. I'd try including the file name with the first argument
and not including any argument for the second.

Hope this helps,

Tony

"Locomotiva" <titurbina@xxxxxxxxxxxxx> wrote in message
news:SoHCe.79932$h5.3354734@xxxxxxxxxxxxxxx
> In an application of VBA for Solidworks in which use EXCEL
> I obtain the following mistake:
>
> Error of Run Time 429
> Component ACTIVEX isn't in degrees to create object
>
> In correspondence of command:
>
> Set Excel = GetObject("H:\Prova\VBA SOLIDW\EXCEL\", "DATI.SPLINE.xls")
>
> The complete lis it results
> Sub main()
> Dim SWapp As SldWorks.SldWorks
> Dim part As SldWorks.ModelDoc2
> Dim Excel As Object
> Dim I As Integer
> Dim XPT As Double
> Dim YPT As Double
> Dim ZPT As Double
> Set SWapp = Application.SldWorks
>
> Set part = SWapp.ActiveDoc
> Set Excel = GetObject("H:\Prova\VBA SOLIDW\EXCEL\","DATI.SPLINE.xls")
> part.Insert3DSketch
> I = 1
> Do While Excel.CELLS(I, 1) <> ""
> XPT = Excel.CELLS(I, 1)
> YPT = Excel.CELLS(I, 2)
> ZPT = Excel.CELLS(I, 3)
> I = I + 1
> Loop
> part.InsertSketch
> End Sub
>
> I can anyone it know what do?
> Thank you.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


.



Relevant Pages

  • Re: trouble installing WMP11
    ... Prev version system is ... Setup version 10.00.00.3646.] ... ERROR: WMC_CopyFile: Could not find source file ... Current command line: '/UpdateWMP'. ...
    (microsoft.public.windowsmedia.player)
  • Using Select Case to evaulate a new field entry
    ... >it work by using a command button, ... >automatically update after changes to the base fields. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: IF & OR Functions
    ... > Please keep all correspondence within the Group, ... >> I'm trying to check a cell on sheet 1 for certain text such as ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Can I access the previous version of a saved file?
    ... >I overwrote an excel file by mistake, using the save as command to an ... > incorrect file. ... Is there any way to recover the previous file before I ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • CD Drive not being recognized
    ... Edward S. Baiz Jr. ... Prev by Date: ...
    (comp.os.linux.setup)