Results 1 to 8 of 8
  1. #1
    tdhw
    Guest

    Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    Hi,

    I m a student current working for a project which contains more than 10 Excel worksheets with many macro/VBA behind. My proj nearly finshed and all the programs/marcros completed work very well but made on an old machine that is Window 95 and perhaps Office 97 (I doubt whether it is 97 version although "about MS Excel" shows 97). Now when I tried to test/transfer these programs on others machine of the company (basically NT4 and Office 97), they don

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    It sounds like at least part of your problem is that the references set on Tools/References are not the same on the different systems. You may also have different addins loading.
    Legare Coleman

  3. #3
    tdhw
    Guest

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    Thanks Legare,

    I did try Tools/Reference in my home PC. When opened the files with msg "cannot find proj or lib.." for a simple function, I checked Reference box which shows: MISSING Acrobat Control for ActiveX. It seems not logical that Acrobat file related to this program. Anyway, the missing file location shows: C:Acrobat3ReaderActiveXPdflib.TWD. This fold is basically empty as I havd installed Acrobat 5 recently (nothing in Reader folder and Reader is the only folder under Acrobat3).
    I tried two ways: set a ActiveX folder under Reader and copy the file Pdflib.TWD from Acrobat 5 to ActiveX folder; used Browser button to Add Reference and Open the file name, but the missed file didnt go in the Reference box. I restarted machine and tried times, nothing changed, the error msg is still there, same as before. Then I tried second way: I deleted the Acrobat3 folder completely and restart the machine, well same error msg, same problem again when open the file. The Missing file was still Acrobat Control for ActiveX and the location showed the same file/folder again.

    I also tried to reinstall Office 2000 in my home PC (removed the existing on before installation), nothing changed too.

    Do you have any clue how can I attack the problem?

    TIA

    David

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    I know little to nothing about Acrobat. I hope someone else can jump in with an answer to that.
    Legare Coleman

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    Hi David,
    Did you actually uncheck the MISSING: reference? If Acrobat is not involved in the spreadsheet in any way, the simplest solution is to remove the offending reference.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    tdhw
    Guest

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    Thanks a lot Rory. It is a very good suggestion. I didnt do the uncheck.
    Now after I unchecked the MISSING ref and saved and opened the file again, the file shows no error msg and all the listboxes contents are loaded in. It is great! However, the files got such msg are backup/older files which I save wks ago. All the new files recently completed and tested successful in one machine of the company and many machines in my univ are still the same in my PC, show the error msg "

  7. #7
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    Some of your problems are caused by a different set of 'references' between your development PC and the other computers. From the VBE, go to Tools/References and see what's listed with check marks. You probably have some selected (but they're not used) and those are not found on the other PCs. One by one, uncheck the references and if no error messages, then it's okay to remove them. If you use anything but the 'standard' set of Excel references, then you need to make sure that the other PCs have those installed as well (any PC that will run your workbook).

    To answer your question about version, you probably do have Excel97. The About box doesn't list the version (it does in xl2000 and above, however). In VBA go to the immediate window and type the following:
    <pre>?Application.Version
    </pre>

    Press ENTER and you'll see something like 8.0e. Excel97 is "8.x" and Excel2000 is "9.x" and ExcelXP is "10.x", etc. I do this type of checking in my projects too because sometimes I need to write code that is version specific.

    Deb <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

  8. #8
    tdhw
    Guest

    Re: Problem run diff machine of my VBA/Excel (Excel 97 and 2000)

    Thanks Deb,

    I cheched my PC, it is surely Excel 2000 (9.0). My old files which can be opened without errors have 6 ref files. When open Excel as blank/new, I found it contained 4 of 6 the ref files.The missed two are MS Forms 2.0 obj. lib and MS Word 9.0 obj. lib. I wonder how to change the setting on the tool/ref for my Excel in general, not for a particular file cause once I made the change to the ref, Excel asks to save in a named file, but when open a new/blank file again, its tool/ref is the same as before. If the diff ref is the reason that I couldnt open my new files and I have to change the setting inside the files, it means I couldnt do that at least in my PC cause they cannot be opened.

    Now is later Friday here, next week I ll do checks the machines in the company and let you know the result .

    This is the first time I come to online discussion abt my problem, many of you may agree that not many people know much abt VBA and little ref books available while in my case nobody arround know that at all, so all of these replies help me a lot. Thanks again.

    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •