vba - Outlook macro that checks if Excel macro is running -
i have excel macro opens internet explorer, searches & requests export each item in column a.
the export sent outlook email , automatically filters import/export folder. @ point, when filters import/export folder, i'd an outlook macro check if excel macro running, because receive exports @ other times too.
if excel macro running i'd change/edit subject line of email filtered include text html tag (which have id for) on current page internet explorer.
** possible? if have suggestion on better way go i'd happy hear it.
in excel, before first export save 1 text file. once exports done, put excel sleep short time mail can reach outlook save 0 text file.
in outlook, assume excel requesting exports if text file contains 1.
edit:
sample code excel how create , write txt file using vba
sample code outlook: read/parse text file line line in vba
Comments
Post a Comment