ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Errors on other PCs (https://www.excelbanter.com/excel-programming/308205-errors-other-pcs.html)

Madvark

Errors on other PCs
 
I created a workbook with several macros and user forms (calendars)
that works well on my PC. I copied the file and have sent it to
several other users at different sites and it works on some and not on
others. They get erros referencing 'project not found' and '400' when
simply executing a macro or opening a calendar. I thought all
necessary files were included when the file was saved. Can anybody
help? I knew enough VBA to create a great program that doesn't work
for anybody but me. I'm dangerous.

Bob Flanagan

Errors on other PCs
 
if you go to

http://www.rondebruin.nl/calendar.htm

Ron has an excellent writeup on using the calendar control. Most likely the
machines with the error do not have the dll installed and thus need to
install it.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Madvark" wrote in message
om...
I created a workbook with several macros and user forms (calendars)
that works well on my PC. I copied the file and have sent it to
several other users at different sites and it works on some and not on
others. They get erros referencing 'project not found' and '400' when
simply executing a macro or opening a calendar. I thought all
necessary files were included when the file was saved. Can anybody
help? I knew enough VBA to create a great program that doesn't work
for anybody but me. I'm dangerous.




Tod[_4_]

Errors on other PCs
 
I think this may be a backward compatability issue. For
example, if you referenced Microsoft ActiveX Data Objects
2.6, but the computer the workbook is copied to only has
version 2.5, the 'project not found' error will occur. In
a case like that you'll need to reference dlls that are
likely to be on the machines of all of your users. You
have to play to the oldest software.

tod

-----Original Message-----
I created a workbook with several macros and user forms

(calendars)
that works well on my PC. I copied the file and have

sent it to
several other users at different sites and it works on

some and not on
others. They get erros referencing 'project not found'

and '400' when
simply executing a macro or opening a calendar. I

thought all
necessary files were included when the file was saved.

Can anybody
help? I knew enough VBA to create a great program that

doesn't work
for anybody but me. I'm dangerous.
.



All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com