Need help with Macro

  • Thread starter Thread starter Ultsun1
  • Start date Start date
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
 
This sounds like a question that the folks over in the Excel groups might be
better suited to answering.

By the way, you don't need to export/import (i.e., move) data between Excel
and Access. Access allows you to "link" to data in Excel.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top