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.
Any hints welcome
Please Login or Register to view this content.
Kevin
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:
or if you want to use the quotesPlease Login or Register to view this content.
Please Login or Register to view this content.
Ok ta the mydata1 = line works fine now but the "with end with" is not working
Any suggestions.....
Kevin
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
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
Please Login or Register to view this content.
JosephP this is superb it works thanks
Kevin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks