Skip to content

Project.xls, Activity.xls

Johnny XuMember for 24 years 5 months
Created
9
2
0
Hi, folks,

When I want to open the Project.xls or Activity.xls, the error message prompts out:
“Could not load an object because it is not available on this machine”

When I want to locate the project and click on "browse" button, the error message prompts out with Microsoft Visual Basic window:
Microsoft Visual Basic
Compile error:
Variable not found

Any solution?

Many thanks.

9 replies

Oldest first
  1. 0
    Dayanidhi Dhandapany ·
    Dear Johny,

    I think you are talking about Primavera’s Ra application in Excel. You have to check with the variable associated with the browse button option in Excel VBA. Have you done any modifications in the Excel VBA files before? Try to run the program in debug mode and find the soultion or send me the files to plannerdaya@yahoo.com. Let me try it from my pc here and tell you whether i get the same message or not.

    Regards

    Daya
  2. 0
    Mk Tse ·
    Some Office components not been installed on your machine.
  3. 0
    Mk Tse ·
    Further may I know which Microsoft Office version you have installed?

    To add those missing component, from Control Panel, a list of installed program listed, select MsOffice and click the icon, a wizard will guide you to repair, add/remove component etc. Please make the Office CD ready also since some action may call CD.
  4. 0
    Johnny Xu ·
    Thanks.

    I am using MS Office 2000 SR-1.

    Johnny
  5. 0
    Mk Tse ·
    That’s fine. Normally, not all Office components are installed in typical installation. Check those missing one related to VBA.
  6. 0
    Dayanidhi Dhandapany ·
    Hello Johny,

    Have you received the attachment to check the library items to be included in the VBA Editor(Tools->References......)in your Excel application.

    i need your feed back..........


    Cheers!!

    Daya
  7. 0
    Johnny Xu ·
    Mr Dhandapany,

    Yes, I did check the first 4 check-box under tool>reference, but it still doesn’t work. And I tried using my home computer, it works. I think it is something to do with my office windows or office envirenment settings.

    Thank for you help.

    Johnny
  8. 0
    Dayanidhi Dhandapany ·
    Dear Johny,

    Good. may be you can seek your company’s IT team support to rectify the problem.

    Good Luck.

    Regards

    Daya
  9. 0
    Mk Tse ·
    Different version to those components may cause the problem.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?