ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   random VBA errors (https://www.excelbanter.com/excel-programming/278538-random-vba-errors.html)

Chuck[_6_]

random VBA errors
 
Looking for a starting point to solve this problem:

Have an Excel 2000 workbook with Userform and supporting
VBA code, including code to e-mail entire workbook. When
it's e-mailed from PC-A to PC-A, it can be saved and
opened with no problems; likewise from PC-B to PC-B.
Problems occur when e-mailing from PC-A to PC-B, and vice
versa; both have identical OS and Excel versions.
When "offending" code is deleted, same problems happens at
a lower line of code.

Any ideas where to start looking? Thanks.



Bill Li

random VBA errors
 
Maybe the problem is in the e-mail code. Do you have any
link in the code referring to the local PC?

-----Original Message-----
Looking for a starting point to solve this problem:

Have an Excel 2000 workbook with Userform and supporting
VBA code, including code to e-mail entire workbook. When
it's e-mailed from PC-A to PC-A, it can be saved and
opened with no problems; likewise from PC-B to PC-B.
Problems occur when e-mailing from PC-A to PC-B, and vice
versa; both have identical OS and Excel versions.
When "offending" code is deleted, same problems happens

at
a lower line of code.

Any ideas where to start looking? Thanks.


.



All times are GMT +1. The time now is 05:49 AM.

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