View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Open current database method

wrote ...

dba.OpenCurrentDatabase filepath:=stgPath,[Exclusive =
false], bstrPassword = test


Just a guess but you may want:

dba.OpenCurrentDatabase _
filepath:=stgPath, _
Exclusive:= False, _
bstrPassword:= "test"

Or briefer:

dba.OpenCurrentDatabase stgPath, False, "test"

If test is a variable, omit the quotes.

Jamie.

--