From 1 workbook, I'm trying to open a 2nd workbook and then copy a value from this and paste it into the 1st. The code below is opening and selecting the right sheet but it doesn't copy the value from the 2nd workbook.
Any help would be greatly appreciated.
Please Login or Register to view this content.
Last edited by Katharine Evans; 09-24-2014 at 03:33 PM.
It looks like the code with only transfer the last value for PONumber1. Without the example workbook, its difficult to see what this might be - could it be a blank?
Martin
Thanks Martin,
PONumber1 definitely has a value, the problem seems to be copying data from Workbook1. The workbook opens but can't select, copy or paste into it.
This is my first post, is it possible to upload the example workbook?
Go to advanced and there is a file upload mechanism available.
Thanks Martin. Here are the 2 workbooks.
Is workbook1 locked for editing? Can you try opening it as readonly?
Workbook1 is definitely not locked. I appreciate you confirming that the code looks OK.
I think we've figured out the problem; it appears that a setting has been changed which is affecting how ActiveX buttons work. When we assign the code to a Form Control button it works, when it's assigned to an ActiveX Control button it doesn't. We're still not sure exactly why this is happening (maybe it could have something to do with a recent software update) but at least we've got the code working now.
Thanks again for looking into this for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks