developingprogrammer
asked on
programmatically adding reference Microsoft Excel 11.0 or 12.0 Object Library
hey guys, i'm in an environment where some people have excel 2003, some have 2007.
i'm using 2007 and i have a Microsoft Excel 12.0 Object Library reference in my Access application.
could yall give me a function on how to:
1) detect if the user is using Excel 2003 or 2007
2) add the appropriate Microsoft Excel Object Library
thanks guys!! = ))
i'm using 2007 and i have a Microsoft Excel 12.0 Object Library reference in my Access application.
could yall give me a function on how to:
1) detect if the user is using Excel 2003 or 2007
2) add the appropriate Microsoft Excel Object Library
thanks guys!! = ))
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You want to avoid a method, late-binding, which would solve the problem?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@peter57r,
Couldn't agree more.
Couldn't agree more.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
whao guys, super duper cool stuff here. i need to read more in depth to respond to yall individually ya = )
but at the moment - gustav, i'm using Access 2007 and when i go to tools references i don't see Microsoft Excel Object Library for 2003, i only have Microsoft Excel Object Library for 2007. how can i reference to Microsoft Excel Object Library for 2003?
i think your solution would be the easiest for a newbie like me to implement! = )
but at the moment - gustav, i'm using Access 2007 and when i go to tools references i don't see Microsoft Excel Object Library for 2003, i only have Microsoft Excel Object Library for 2007. how can i reference to Microsoft Excel Object Library for 2003?
i think your solution would be the easiest for a newbie like me to implement! = )
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i see, thanks MacroShadow! and
1) are the coding differences using 2003 and 2007 excel reference?
2) how do i detect whether the reference is 2003 or 2007 reference? so that i can insert different code based on the 2003 and 2007 reference.
thanks guys!! = ))
1) are the coding differences using 2003 and 2007 excel reference?
2) how do i detect whether the reference is 2003 or 2007 reference? so that i can insert different code based on the 2003 and 2007 reference.
thanks guys!! = ))
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
guys, thanks for all your help and wonderful solutions!! just reading them has taught me a lot! = ))
MacroShadow, you mentioned previously in your post
if you don't mind, could you kindly give me the sample code for this? i'm probably going to go your route = )
MacroShadow, you mentioned previously in your post
peter57r
That's easy enough, just read the "path" key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsof t\Windows\ CurrentVer sion\App Paths\excel.exe
Then you could also use the InStr function to return the installed version, without having to use a custom build function.
If the OP is interested I will give some sample code.
if you don't mind, could you kindly give me the sample code for this? i'm probably going to go your route = )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
guys thanks so much for your help!! i've bought the FMS Total Access Ultimate Suite and going to try and implement this using their Admin product. will let yall know how it goes should i run into any issues, but hopefully it's all good!! thanks for all your help and advice guys!! = ))
You wouldn't need that expensive package for this.
/gustav
/gustav
ASKER
Yup bitsqueezer did share with me a few other free products but I think right now I'm really new so I need the crutches and the support at the moment, so it's like getting a product instead of implementing it myself. They did all the implementing already. I also got vbWatchDog for global error handling and their email product as well. Just trying to really get this project off and running. I think if I have more experience and time I could learn to manually write all these, and I would love to just that now I don't have that resource at the moment, and y'all are already doing so much to help me!! = ))
ASKER