R
Riley
Ok- got brain freeze here- I had a database at my old company where I set up
a folder, pasted the contents of the customer folder into it(Excell
workbooks), and then be able to click a command button on a form in access,
and access would go to that specific folder "Customers Temp File"- and from
each workbook, select a range of cells from a worksheet in each workbook
called "Import", and bring them into Access, one at a time, killing the file
after the import and going on to the next until I had the important range of
cells from each workbook in that folder, and was left with an empty folder.
I'm not very good at code at all, but finally got it right, and it worked
well- but I can't get it figured out.
Customers Temp File = folder where a copy of the workbooks are kept
Each workbook is named after the customer- all different names
In each workbook I have a sheet called "Import" with a range of 7 cells that
carry values from the other 8 sheets.
I can get the formatting right in the table, and the formats for the sheets,
but just can't seem to put together the code to import, then kill the
workbook.
Your help is very appreciated.
"Partzheimers"
a folder, pasted the contents of the customer folder into it(Excell
workbooks), and then be able to click a command button on a form in access,
and access would go to that specific folder "Customers Temp File"- and from
each workbook, select a range of cells from a worksheet in each workbook
called "Import", and bring them into Access, one at a time, killing the file
after the import and going on to the next until I had the important range of
cells from each workbook in that folder, and was left with an empty folder.
I'm not very good at code at all, but finally got it right, and it worked
well- but I can't get it figured out.
Customers Temp File = folder where a copy of the workbooks are kept
Each workbook is named after the customer- all different names
In each workbook I have a sheet called "Import" with a range of 7 cells that
carry values from the other 8 sheets.
I can get the formatting right in the table, and the formats for the sheets,
but just can't seem to put together the code to import, then kill the
workbook.
Your help is very appreciated.
"Partzheimers"