Automation Errors

  • Thread starter Thread starter Mike Larson
  • Start date Start date
M

Mike Larson

Hello,

I have created a macro that can load text data into a worksheet then perform
some various calculation and make some graphs from the data.

The macro works fine on my computer. However, when it is opend on another
computer an error "Automation Error, Unspecified Error" pops up. The
buttons that I created to begin the calculations and charting are displayed
but when they are clicked another "Automation Error" occurs.

I am on a Win2K machind runngin Excel 2000 9.0.3821 SR1, the other computer
is WinXP Pro Excel 2000 9.0.2720.

Is there some type of setting that excel need turned on to run macros?

Any advice would be welcome.

Thanks.

Mike
 
Try changing the security levels in Tools/Macro/Security - In XP ProSP2
macros are blocked unless signed by the author(for the same machine but a
different user) or by an external validation source for running you
spreadsheet macro on another machine.
 
The security has been set, the other computer does not ask it the macro can
be accessed, it just does.

Perhaps my question was wrong.

The macro uses the VB (scripting?) editor to create it. The error is thrown
in at least two places 1) when the workbook is first opened, before the
worksheet is availabel for editing and 2) when accessing a .Range property
of a worksheet.

Is there any option, tool, or utility that has to be turned on in excel in
order to use all function/properties/methods of the worksheet object in the
VB editor?

Thanks.

Mike
 
Back
Top