Automated Excel Reports

Wow - thanks so much! The report needs to update and ran every Monday. And the only thing that needs to be done is to right click and refresh data.

Again,thanks so much...

any chance you could forward the file? could you confirm that you have a personal.xls file? you can do this by opening up my computer clicking on program files>microsoft office>office>XLStart you should see personal.xls or

1. Open excel
2. click on "Windows" thats the one next to the help button
3. see if you see personal if not click on unhide and see if it says personal.

the reason for this is that you need to have a way to fire off the macro at some point so what I was thinking is as soon as you open excel it must check to see if it is a monday if it is then to open your file then refresh then email then close.

I am not able to upload the.xls file. I am receiving an "Invaild File" error. Thanks for all of your help!!!

thats because you cannot upload a .xls here directly what you need to do is make it a zip file and then try upload it.

Do you have a personal.xls file?