Hello,
I'm trying to distribute an addin to my work team that I have made in Excel 2000 and it have proved to be only partially successful and I'm confused :-(
The addin is used to catelogue excel files to enable them to be quickly searched and retrived by the user. The catelogue of files are stored in a mdb file that the addin connects to using DAO. However, the problem that I keep getting on some of the computers is missing dll files. Strangely, all the computers are running XP-Pro and all have office 2000 installed so I'm not sure why any dll files are missing.
Additionally, I thought that if you compile a VBA project and save it as an Addin then the references etc would be included?
Can anyone explain to me why only some of my colleague's computers are not runing this Addin and is there any steps that can be taken to install the necessary support files (dll files) automatically.
All responses are gratefully recieved - many thanks in advance.
thanks
andrusski
I'm trying to distribute an addin to my work team that I have made in Excel 2000 and it have proved to be only partially successful and I'm confused :-(
The addin is used to catelogue excel files to enable them to be quickly searched and retrived by the user. The catelogue of files are stored in a mdb file that the addin connects to using DAO. However, the problem that I keep getting on some of the computers is missing dll files. Strangely, all the computers are running XP-Pro and all have office 2000 installed so I'm not sure why any dll files are missing.
Additionally, I thought that if you compile a VBA project and save it as an Addin then the references etc would be included?
Can anyone explain to me why only some of my colleague's computers are not runing this Addin and is there any steps that can be taken to install the necessary support files (dll files) automatically.
All responses are gratefully recieved - many thanks in advance.
thanks
andrusski