Error when trying to open an Excel file with macro

[jcck2003]

Hi All:

one of the box we have running windows 2000 and Excel 97 SR2, encountered a problem when trying to open an Excel file:

Microsoft Visual Basic:

Permission to use object denied

then the file would open but nothing shows up

what permission does it talking about ?

Thanks for help
J

 

[SteveBausch]

More detail, please.

Have you Googled the exact phrase? What comes back?


What exactly is the code doing? It works on other machines, right?

What are the differences between the problem machine and the good machines?

What are the additional references, if any, the project requires?

 

[jcck2003]

I googled it many times and forms, but it came back VBA related information, we not really using the VBA programming, but just trying to open that particular Excel files, there maybe some macro in that file somebody wrote but we are not sure about its details