SelectBeginning ' restart from the beginningįinish = InputBox('Please enter the date for next Friday', 'Date entry', Int(Now() + 8)) 'assumes that we will be running this on Thursdayįor Each Resource In ActiveProject.Resources I moved the block of code that opens the excel file closer to the macro trigger in case something in the intervening code was preventing it from working however this didn't work.

When used in the original code snippet the macro can be triggered from the MS Project file.Ĭan anyone tell me what I have done wrong? When I go into the excel file and manually trigger the macro is works so the macro isn't causing an issue, it just doeesn't appear to be triggered. No errors are produced, the code just behaves as if that specific line doesn't exist. This macro is contained in the excel file and sets some conditional formatting and enters some text to provide visional confirmation that it has been triggered. XlApp.Run (''This week report - BLANK.xlsm'!apply_conditional_formatting') When I run it on its own it works OK, however, when I put it into my code it stops working.Įdited for clarity - when I step through the macro and it gets to the line which should trigger the macro:

Open an existing Excel file and run a macro in that file through MS Project I have used a code snippet from a previous question (see below).

Excel vba open ms project file in use