Hello:
Please refer to attached 2 excel files.
Source.xls
Dest_12-01-2013.xls
Source file will have Daily Receipts for the whole month.
(I am showing only sample data)
Both these files will be in C:\Users\Riz\Desktop\Temp location.
I need a VB Macro to export Data Range E5:G13 from Source file into "Dest_12-01-2013.xls" at B8 without
opening "Dest_12-01-2013.xls".
Once data pasted, would like to save "Dest_12-01-2013.xls".
Eventually, i will be creating files for the whole month and hence i do not wish to open, will do it loop later.
Please let me know if any questions.
Thank you
Riz Momin
Bookmarks