Need help with Macro

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
 
J

Jeff Boyce

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top