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

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -