Windows 10: I can't get the scheduler to run an excel file with vba code that creates a report and...

Hi,I have built vba code in an excel file that creates a report file and emails it to some recipients. I am trying to get the scheduler in windows 10 to run this but no matter how I do it it does not run when I am not logged in. I have now also tried in windows 11 and there it does not work there even when logged in... Anyone who has had the same problem and solved it? Kind regards Jonas

:)

 

Task scheduler is running task, but not activating the VBA code in the spreadsheet.

I have a VBA code in an excel spreadsheet that is written to save data everyday and create a seperate spreadsheet of said data. The task scheduler is used run this program, at a specific time of my choice. Right now, when I run the task, it opens up excel but the actual code embedded in the file does not activate. I've looked through the conditions and triggers and messed around with them but haven't made any progress. Also, I'm not getting any error messages, it just isn't creating the output that it should. When I run the task, the app logo for excel flashes orange. I don't know what that means. Please help if you are familiar or if I need to provide more information.

 

Vba Excel created with office 2016 and Windows 10 doesn't run in windows 7 and office 365

Hello, I have created a file excel with office 2016 on windows 10. Vba code on windows 10 runs without any problem. In my office there is a PC with Windows 7 and office 365 and vba code doesn't run correctly....

So, why????

Thanks a lot

 

Help with Excel VBA Problem?

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!