F
fluharme
Guest
I've created a macro that does the following:
open a table
transfer an excel spreadsheet
show all records
save the table
close the table
open a report
stop macro
It works almost flawlessly but I have two small problems. The table has a column called "startdate". I want the macro to look at the last entry in the "startdate" column in the table and compare it to the first entry in the "startdate" column of the import file. If the two "startdate" columns match I want the macro to stop running and present an error similar to, "Start dates match-check to make sure you have the proper file" or something to that degree. If the "startdate" doesn't match then continue with the macro. I can't figure out how to tell the macro to compare the import file to the table.
I'm trying to keep it from importing the same excel file more than once. Each import file should be advanced by the next day of the last record of the table.
Any help?
open a table
transfer an excel spreadsheet
show all records
save the table
close the table
open a report
stop macro
It works almost flawlessly but I have two small problems. The table has a column called "startdate". I want the macro to look at the last entry in the "startdate" column in the table and compare it to the first entry in the "startdate" column of the import file. If the two "startdate" columns match I want the macro to stop running and present an error similar to, "Start dates match-check to make sure you have the proper file" or something to that degree. If the "startdate" doesn't match then continue with the macro. I can't figure out how to tell the macro to compare the import file to the table.
I'm trying to keep it from importing the same excel file more than once. Each import file should be advanced by the next day of the last record of the table.
Any help?
