Jump to content
Macro Express Forums

STrange Behavior I cannot figure out....

Recommended Posts

I run a macro every morning that triggers a batch file and logs to a log.  I recently added a check in the macro that looks for the file it expects before it runs the batch file so that the batch does not run if the file does not exist.


Here are the log entries (the bold redish brown text is me adding the file that shows it was there).  I also created a simple macro that simply looks for the file with full file name and with wild card and both worked in my test macro YET I consistent get the error file does not exist.  Before you ask I manually put that file there so FOR SURE it was there @ 7:15am.


5/18/2023 7:15:05 AM Starting JIRA Update Macro
5/18/2023 7:15:05 AM JIRA '\\nw\data\737_Systems\Integration\23 737MAX\55_Requirements\JIRA_Automated\RAW\JIRA_export_05-18*.xlsx' does not exist!!
                                                   '\\nw\data\737_Systems\Integration\23 737MAX\55_Requirements\JIRA_Automated\RAW\JIRA_export_05-18-05-55-00_734.xlsx
5/18/2023 7:15:05 AM Ending JIRA Update Macro



I am really hoping someone finds something glaringly wrong but I have looked it over and over and cannot find anything; I even re-wrote it a couple times; I am going to have to remove the file existence check because this is NOT the only macro I have where it fails.





JIRAUpdate.mex JIRAUpdateTRIGGER.mex

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...