Hello,
I have been playing around with two test spreadsheets trying to understand how I can copy data from Workbook B to Workbook A (Test Unlocker File.xls).
I have created a basic macro to open Workbook B from Workbook A. Workbook B has all it's sheets protected by a password - this I can get around (just copying in from Workbook A to clipboard to paste into input box in Workbook B)
But I am having a problem with copying even a single cell of data from Workbook B and pasting it in Workbook A.
I am currently stuck using Excel 2002 instead of my usual Excel 2003.
As you can see from my code I am no expert. Any help that anyone can please provide would be greatly appreciated.
Thanks.
Bookmarks