I had this idea but I am not sure how to go about implimenting this process. I have a combo box on my form that when loaded houses my table names (From Access). I want to be able to open an Excel file and compare it with this table, then spit out the differences in another Excel file. I am just not sure how to go about bringing in the Excel file to compare.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.