task scheduler

  1. R

    Task Scheduler fail to open excel and run macros

    Hi, I am facing problem for Task Scheduler to run a excel macros. When I run the Vbscript in Task Scheduler, the status shows running but nothing happen. I open the excel file manually and it shows below reasons, so i have to end the excel using task manager to let me access to the file again...
  2. dss28

    VBA excel code for saving task with frequency based on incremental date value

    I have a userform which is used for billing as well as task management. there are several textboxes in the userform but most important for this are: txb34 (srNo), txb21 (task name), txb7 (Donation), txb37 (schedule on date), txb8 (Qty.), txb9 (total price), txb1 and combobox2 arranged in the...
  3. X

    Microsoft VBA editor opens automatically when I unlock my pc

    Hello everyone. Some days ago I noticed that every time I unlock my pc the VBA editor window will automatically open, and somehow this affects a macro that's executed every morning day by the windows task scheduler (I think the macro is affected because since this issue came out the code does...
  4. K

    Find in multiple sheets and automatic print on specific time.

    I have a workbook with multiple sheets. Each sheet has unique word in cell C128. Is it possible to pop out a message box and ask me to input the unique word and search into multiple sheets and print of that found sheet range A1:F59 only (would better ask me how many copies to print). I want it...
  5. R

    VBA code not running through Task Scheduler

    Hello All, Greetings for the day! I'm having a VBA script which works absolutely fine when run manually. However when I tried to run it through windows Task Scheduler, few codes of this script not executing and hence not giving desired result. Any idea for this paradox? If required, I can post...
  6. J

    Leads and Follow-up Tracking Spreadsheet

    Hey Guys, I see this tracking-template is unavailable for download now, wondering if anyone has one similar they use for tracking marketing leads and follow-ups. https://www.youtube.com/watch?v=8Qb9rjl4XmA&t=46s Thanks!
  7. J

    VBA - Email notification when job added to list.

    Morning All, Within my department we use an excel based job register for employees to add engineering issues as they occur. Currently someone within my department has to sporadically check the register to see if any new jobs have been added and then assign them to an engineer and give it a...
  8. S

    Preventing multiple Excel instances

    Hello MrExcel-Forum, there once was a computer, who at certain times, ran a batch-file via the task-scheduler, the batch-file starts an xlsm-file, and the xlsm-file used "thisWorkbook.close false" at the end of their vba (in workbook.open. the "false" means that changes are not saved). there...
  9. J

    Windows10 task Scheduler cannot open Excel

    Hi, I want to set up my task scheduler to auto open excel.xlsm format at a specific time, but some how it keeps gives me the error message Task Scheduler--> Create a basic task-->Program/Script "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE"-->Add arguments...
  10. W

    How to run a macro with taskscheduler

    Hello all I have a weekly task that I would like to run automatically via task scheduler. I wrotte a small macro and included it in the workbooks open but I only want it to run when the file is opened by task scheduler. Does anyone have any idea if this is possible to do ? If not, is it...
  11. D

    Run macro automatically at specific time every day

    Hi All, looking for a bit of advise on how to automatically run a macro daily. I know that i can use:Sub auto_open() but i will need to access the file throughout the day and don't want the macro running every time I open the workbook. I have read online that I could use the task scheduler...
  12. A

    Conditional Formatting

    Using my example below, I used conditional formatting that will fill in columns D - K based upon the data in columns A & B. Now I need to be able to change the color of the fill from the default to "green" when there is a "C" in column C (status). Thanking you in advance - Andrea <tbody>...
  13. E

    Force taskscheduler to open excel file using Excel 2007

    How can I force task scheduler to use excel 2007 to open an excel file. Currently, task scheduler is using excel 2003 to open .xlsm file. Thanks,
  14. Jaafar Tribak

    How was the workbook opened ?

    I have a Macro that runs upon opening a workbook but I only want the code to run if the workbook was opened by the Windows Task Scheduler. Does Excel has a way of detecting how the workbook was launched ? ie via the User or via the task scheduler . Thanks all.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top