Unable to run the macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have one macro which connects to database and gets the data to the
sheets.

I am able to run this macro in most of the systems but in one of our
terminal box I am not able run it.

It is giving the following error "Can't find project or library"

I am using the same excel in both the machines but not able to run in this
RDP box.

I am using Excel 2003. Do I need to install anything else. Please help me in
this.

Thanks,
Mahesh
 
On the affected machine open the file and go to the VBE. Check Tools ->
References for something tagged as missing. Being database I suspect that it
is

Microsoft ActiveX Data Objects 2.? (2.8 probably)

In your source file change the reference to something lower that is common
to all of the machines that will use the spreadhseet and save the file. A
lower version should not hurt anything...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Macro to generate powerpoint slides 43
Run code from another workbook 7
Run Macro on All Sheets Q 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Private Macros 3
Unable to run macros... 7
Automating macro to run macro from Access 3

Back
Top