+ Reply to Thread
Results 1 to 7 of 7

Old code not working in 2010

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    Old code not working in 2010

    Old version question here,

    I can get this code to work in an older excel but I cannot get it to work in excel 2010.
    Does anyone have any idea why it doesn't work?
    The code pulls data from a closed file without opening it.

    Please Login or Register  to view this content.
    Any hints welcome

    Kevin

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Old code not working in 2010

    I don't think you can get this code to work in any version of Excel. The formula you are assigning to mydata1 has a syntax error. I will bet that you changed the string for mydata1. It has an unmatched single quote. You don't need the single quote here anyway. Try this:
    Please Login or Register  to view this content.
    or if you want to use the quotes
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Old code not working in 2010

    Ok ta the mydata1 = line works fine now but the "with end with" is not working

    Any suggestions.....

    Kevin

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Old code not working in 2010

    what do you mean the with end with isn't working? (it's actually pointless here anyway because it's more typing!)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Old code not working in 2010

    All I want to do is extract 10 numbers from a closed workbook where I can define the path and name of the workbook.
    Then put them in the current workbook
    Kev

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Old code not working in 2010

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    07-12-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Old code not working in 2010

    JosephP this is superb it works thanks

    Kevin

+ 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] This code not working in Excel 2010 *SOLVED*
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-06-2013, 02:13 PM
  2. [SOLVED] VB Code working in 2010 but not 2003?
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-09-2013, 10:33 AM
  3. Marco code working in 2007 but not 2010
    By Sutty31 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-10-2012, 05:24 PM
  4. [SOLVED] Code not working in excel 2010
    By annpricks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2012, 08:40 AM
  5. Code From 2003 to 2010 excel not working
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-20-2011, 12:41 PM

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