Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all - looking for a little help here.
I've recently complete a large Excel 2000 vba project (3.5 mb sans data). I have noticed that many functions that worked in Excel 2000 fall apart in XP. For example: buffer = Space(varLength) the keyword "Space" does not work in XP So, in my searching of the news groups I've come to realize that I need to include MSVBVM60.dll in my references. However, when I try to add it (it's named "Visual Basic For Applications") I get the error "Name conflicts with existing module, project, or object library". Sure enough there's another reference also named "Visual Basic For Applications" which points to a newer version of MSVBVM60. But, when I try to remove this newer reference I get the error "Can't remove control or reference; in use" and I can't figure out how to rename either. (or is it the MS Excel 9.0 and MS Office 9.0 Obj Libraries that I'm missing??) So, what the heck am I supposed to do to make these basic functions work (other then debugging all 3.5 mb of code line-by-line)? Also, does anybody know how I can get the mmcontrol1 reference in there too? I don't see this any longer either. Thanks in advance! Trip |