Hi all!
I'm new to this forum, but somewhat familiar with VBA in MSAccess97. What I am hoping to accomplish is to create a macro, to be run with a button click that will perform the following functions:
1) Delete some unecessary columns from one spreadsheet that will always have the same column headers in the same format, but updated every day
2) Delete specific data from one column, i.e., fields contain a number like 415444459-01, I want to delete the -01 part and leave the rest of the number
3) Export the newly formated data, minus header row, into an existing table in MSAccess97 (which I may have to do via append query within Access)
I'm really hoping for some suggestions and/or direction on how to begin coding this macro. I've been browsing this forum for a few hours now, and looking through some code, but can't seem to figure out how to program correctly to do the things I need. Any help would be tremendously appreciated!
Thanks
Bookmarks