DougDodge
asked on
Excel VBA Append Data From Closed Workbook to Active Workbook/worksheet
I am trying to figure out a VBA macro to allow user to open a closed workbook, with the aid of FileOpen, select Sheet 1 which has data from range A7:G last row. Evaluate first row date to append the data to the active sheet in the first workbook without overwriting current data.
The opening of two workbooks and copy paste is taking too long considering there is one master and several workbooks to import from on a daily basis.
The opening of two workbooks and copy paste is taking too long considering there is one master and several workbooks to import from on a daily basis.
ASKER
Sorry, the code does not seem to work. It issues an "Invalid or unqualified Reference"
It hangs up here:
Set rng = wb.Worksheets("sheet1").Ce lls(.Rows. Count, "A").End(xlUp).Row + 1
It hangs up here:
Set rng = wb.Worksheets("sheet1").Ce
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.... A couple of slight changes and it works perfectly.
You're welcome; I'm glad I could help.
-Glenn
-Glenn
Open in new window