topic Accessing Arcobjects from Excel in ArcObjects SDK Questions

Accessing Arcobjects from Excel

VikramS — Tue, 06 Mar 2012 18:37:05 GMT

Hello ,

I am trying to access arcobjects from excel vba . But I am getting an error . Below is my script . i have added all the references relating to ESRI .

Dim pworkspacefactory As IWorkspaceFactory2
Set pworkspacefactory = New FileGDBWorkspaceFactory
Dim pworkspace As IWorkspace
Dim s As String
s = "H:\\SPSD\\SPSD1.gdb"
If pworkspacefactory.IsWorkspace(s) Then
Set pworkspace = pworkspacefactory.OpenFromFile(s, 0) getting error here (Run-time error '-2147220952 (80040228)')
MsgBox pworkspace.PathName

I have another question as well .. Can we pass parameters to Arcmap if we open it through a batch file

Please help me

Re: Accessing Arcobjects from Excel

NeilClemmons — Tue, 06 Mar 2012 19:17:03 GMT

Are you checking out a license? If not, then your code won't run. Also, if you're using ArcGIS 10 then you will also have to bind to a product before checking out the license.

Re: Accessing Arcobjects from Excel

VikramS — Wed, 07 Mar 2012 12:34:19 GMT

Are you checking out a license? If not, then your code won't run. Also, if you're using ArcGIS 10 then you will also have to bind to a product before checking out the license.

Hi Neil ,

Thanks for the reply . I had a quick question .. How to check out a license ?

Thanks

Re: Accessing Arcobjects from Excel

NeilClemmons — Wed, 07 Mar 2012 12:38:28 GMT

Use IAoInitialize.