nathagt Posted March 10, 2017 Posted March 10, 2017 Do I have to turn on logging? When I go to Tools > Log it opens a spreadsheet that is blank except for having a sheet named UDI. Is this normal? I want to see what happened when a particular program ran and if it evaluated as true or false.
DennisC Posted March 11, 2017 Posted March 11, 2017 Once Excel opens you should see a dialog box asking if you want to either open or run (I think it says macro??), not sure of exact wording and I am not by a computer. Say yes and the file should open. If you are not seeing the dialog you may be blocking this from running and need to check Excel settings.
nathagt Posted March 11, 2017 Author Posted March 11, 2017 Ok I enabled macros but now I get an error pop up at says: Run-time error '75': Path/File access error Continue is grayed out, End and Debug are options. If I click Debug it goes to line 7 in the macro, ChDir (ThisWorkbook.Path)
Recommended Posts