U
Ultsun1
Hello,
I need to create a macro to import into Access from Excel.
The macro should do the following:
Table Macro:
1. Delete first 8 rows
2. Delete All columns except for A, B, C, D, I, and L
3. Find Row that contains = "Elimination Totals" Column C; and delete
that row and every row below it.
4. Expand all of the remaining rows and columns so that all the rows
are visible and all columns are expanded as necessary.
5. Import this macro into Access, and run it every time a user clicks
the "Upload Spreadsheet" command button on the Upload Form.
When i ran the macro on another spreadsheet it only left me with the
last three columns and took out the first three that i needed. It did
not work right for me. Can someone tell me how i can go about
creating this macro?
~Ultsun1
I need to create a macro to import into Access from Excel.
The macro should do the following:
Table Macro:
1. Delete first 8 rows
2. Delete All columns except for A, B, C, D, I, and L
3. Find Row that contains = "Elimination Totals" Column C; and delete
that row and every row below it.
4. Expand all of the remaining rows and columns so that all the rows
are visible and all columns are expanded as necessary.
5. Import this macro into Access, and run it every time a user clicks
the "Upload Spreadsheet" command button on the Upload Form.
When i ran the macro on another spreadsheet it only left me with the
last three columns and took out the first three that i needed. It did
not work right for me. Can someone tell me how i can go about
creating this macro?
~Ultsun1