Parse once.
Excel has X entries.
Parse second time.
Remove old entries and only keep the new entries in Excel.
Excel has X entries.
Parse second time.
Remove old entries and only keep the new entries in Excel.
Hi Bob,
That is a good question. I have created a post with a small example:
http://www.automatedemailparser.com/b/r ... excel-rows
That is a good question. I have created a post with a small example:
http://www.automatedemailparser.com/b/r ... excel-rows
Thanks for writing the code. But, what I meant was, not to delete the entire excel file.
But to just delete the previous entry.
So that only 1 batch is sent each time.
i.e. New parsed information
BOB 123 Teal Street 463-8738372
send mail
Delete all parsed information in excel file, but not the file itself.
----------------------------------------------------------------------------------
how do I amend this script?
del /f "C:\Users\Administrator\Desktop\SPEEDNOTE1001.xlsx"
Thanks
But to just delete the previous entry.
So that only 1 batch is sent each time.
i.e. New parsed information
BOB 123 Teal Street 463-8738372
send mail
Delete all parsed information in excel file, but not the file itself.
----------------------------------------------------------------------------------
how do I amend this script?
del /f "C:\Users\Administrator\Desktop\SPEEDNOTE1001.xlsx"
Thanks