Hello Riz
I just tested the VBA program again. My copy is working properly. At first glance it does seem like it's not doing anything, because the program is silent and very quick. Also the original program code adds the new data to the bottom of the spreadsheet out of sight.
That would usually work just fine, but while I was testing the VBA code, I added a few hundred rows of test data to sheet 1, and instead of deleting the rows, I used clear contents. Sorry about that. Excel was adding the new rows way down at row 300 or so.
To fix the problem, I just deleted all the extra rows The next time you run the macro, the new data will be added at row 67.
I also modified the program to inform you that
invoice xxxxxx dated xx/xx/xx has been imported.
Bookmarks