Hello dan_l,
Thanks for your time, I'm afraid I do not know anything about ADO at all :(
Is there any other way to achieve the above?
Here's what I am trying to use but can't proceed because I'm not that knowledgeable in Excel coding. In reference to this sample file which works perfectly...
Hello Experts :)
May I please ask for your assistance on how I could achieve this report process:
1. I have a workbook (WB1)with one sheet with various data (Staff Name, Project Worked, Date, Hours Spent)
2. I need to transfer some data from WB1 to a closed workbook (WB2) from my desktop into...