+ Reply to Thread
Results 1 to 4 of 4

error in excel 2007

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    error in excel 2007

    Hello to all,
    I hope my English is understandable.
    Should I use a file created with Excel 2000, in which there are several macros that have so far worked fine, and I'm forced to use it on excel 2007.
    Clicking on the various buttons combined with the macro displays this warning:

    compilation error:
    Can not find the project or library

    I have searched in google and found this solution:

    VBA Editor> Tools> References> and uncheck the reference in which it is written "missing" in my case Microsoft windows common control 5 (sp2)

    is that correct?
    Thank you,
    max_max

    -----------------------------------------------------------------------------------------------------------------------------------------

    Salve a tutti,
    spero che il mio inglese sia capibile.
    Devo usare un file, creato con excel 2000 in cui ci sono varie macro che finora hanno funzionato benissimo, e che devo per forza usarlo su excel 2007.
    Cliccando nei vari pulsanti abbinati alle macro si visualizza questo avviso:

    errore di compilazione:
    impossibile trovare il progetto o la libreria

    ho ricercato in google e ho trovato questa soluzione:

    editor VBA > strumenti > riferimenti > e deselezionare il riferimento in cui è scritto "mancante" nel mio caso Microsoft windows common control 5 (sp2)

    è esatto?
    Grazie,
    max_max

  2. #2
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: error in excel 2007

    Hello,
    sorry if I have not explained
    max_max

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: error in excel 2007

    Quote Originally Posted by max_max View Post
    VBA Editor> Tools> References> and uncheck the reference in which it is written "missing"
    Yeah, usually it helps

  4. #4
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: error in excel 2007

    Hello,
    I hope my English is understandable.
    I made ​​the change and the file works, it gives me error.
    Now I have tried various files created with Excel 2000, and containing macros and do not give me error.
    Now in tools - references of VBA I can not see: Microsoft windows common control 5 (sp2)
    A curiosity: What is Microsoft windows common control 5 (sp2)?
    Maybe we needed to excel excel 2000 and 2007 do not need?
    If I create a file with excel 2007 and excel asks me:
    Microsoft windows common control 5 (sp2)
    where is it?
    thanks again from Italy
    max_max
    ------------------------------------------------------------------------------------------------------------------
    Ciao,
    spero il mio inglese sia capibile.
    Ho fatto la modifica ed il file funziona, non mi dà errore.
    Ora ho provato vari file creati con excel 2000 e contenenti macro e non mi danno errore.
    Ora in strumenti - riferimenti del VBA non vedo più: Microsoft windows common control 5 (sp2)
    Una curiosità: cosa serve: Microsoft windows common control 5 (sp2) ?
    Forse serviva a excel 2000 e a excel 2007 non serve?
    Se creo un file con excel 2007 ed excel mi chiede:
    Microsoft windows common control 5 (sp2)
    dove lo trovo?
    grazie ancora dall'Italia
    max_max

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Compile Error in Excel 2007 Only NOT 2007 Professional
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2013, 07:29 AM
  2. [SOLVED] run-time error '1004' application-defined or object-defined error - Excel 2007
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2012, 02:46 AM
  3. [SOLVED] VBA Excel 2007 : Autofit Merge Cells Error "Run-time error '13': Type Mismatch"
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 04:10 PM
  4. excel 2007 error
    By ggomez43 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2009, 12:42 PM
  5. Excel 2007 : Excel 2007 VBA error
    By carmennorman in forum Excel General
    Replies: 4
    Last Post: 07-07-2008, 11:49 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1