I have this in my macro but I want to be able to do it for any invoice I specify & paste it in the active cell
for instance to open file INVOICES-644
I dont want to change the macro for every invoice I want to paste in the database
another problem how can it paste the data in the cell I want
instead of pasting on top of each other
ChDir "M:\George-Rola\DECEMBER"
Workbooks.Open Filename:="M:\GR\DECEMBER\INVOICES-630.xls"
I would appreicate any help
THANKS
for instance to open file INVOICES-644
I dont want to change the macro for every invoice I want to paste in the database
another problem how can it paste the data in the cell I want
instead of pasting on top of each other
ChDir "M:\George-Rola\DECEMBER"
Workbooks.Open Filename:="M:\GR\DECEMBER\INVOICES-630.xls"
I would appreicate any help
THANKS