Hi all,

I have this code to autorun a macro - however, it's gone horribly wrong as I have obviously put that chunk of code in the wrong place - now, my spreadsheet autocloses as soon as I open it and the only way I have been able to actually get it open is to disable the macros in the program.
The whole point is to open the workbook (scheduled task on my PC), auto run a macro at 2:00 AM when the office is closed and then save and close the workbook. I have no idea where I am actually supposed to put each section of code, but it works somewhat...I ran a test last night and it worked, when I looked this morning, the macro and run and the workbooked saved and closed - but then I couldn't re-open it because the code to autosave and close in the 'workbook open' code - I wasn't sure how else to make it work...any help would be welcome - Thanks!
Please Login or Register  to view this content.