Accessing DLL Libaries without a reference - MS ACCESS (1 Viewer)

[coxmg]

Hi guys, I have an ACCESS project where the users cannot add a VBA library reference for example, microsoft excel 12.0 object library. They are using Citrix for remote access to a server. Does anyone know a way to refer to the VBA code to these particular libraries without having to add the DLL reference?

 

[gemma-the-husky]

late binding? something like this?

dim excelobj as object

set excelobj = new("excel.application")

the only thing is, you can't then use constant members of the excel library - you have to use the explicit values instead.

 

[coxmg]

Thanks, what do you mean by contact versus explicit?

late binding? something like this?

dim excelobj as object

set excelobj = new("excel.application")

the only thing is, you can't then use constant members of the excel library - you have to use the explicit values instead.

 

[gemma-the-husky]

i can't think of excel constants

take outlook - you have a constant called olMailItem - but you can't use this with late binding, you have to use the explicit value, be that 0,1,2 etc.

eg see this excel link

http://msdn.microsoft.com/en-us/library/aa221100(v=office.11).aspx