Accessing Arcobjects from Excel

Question

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

NeilClemmons_GISinc · Answer

Use IAoInitialize.

VikramS · Answer

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

NeilClemmons_GISinc · Answer

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.