Creating VBScript file Excel

Question

I don't have much knowledge in creating a VBScript file. I have a code i want to automate to send email out every month. With some research i found the code below:

dim EXL
    set EXL = CreateObject("Excel.Application")
    'not required
    EXL.Visible = true

    'your file and macro    
    EXL.Workbooks.Open "full path to your excel file including extension here" 
    EXL.Run "Fixing"

    'close everything
    EXL.Quit
    Set EXL = Nothing

My Question is: do i implement this code into my excel module or is in the worksheet event?

Once i have this correctly applied i will be able to set the Windows Task Scheduler to run at the particular time.

Just save the VBscript file as a *.vbs file. Create a text file (txt), copy your code and save the file with the vbs extension. Next go to the Windows Task Scheduler and choose Run a Program and locate your VBS — AnalystCave.com
– AnalystCave.com, Commented Jun 2, 2015 at 10:30

AnalystCave.com · Accepted Answer · 2015-06-02 10:35:32Z

1

Just save the VBscript file as a *.vbs file. Create a text file (txt), copy your code and save the file with the vbs extension. Next go to the Windows Task Scheduler and choose Run a Program and locate your VBS.

Sending emails from VBscript

http://www.analystcave.com/excel-send-email-excel-workbook/

Scheduling programs to run in Windows

http://windows.microsoft.com/en-au/windows/schedule-task#1TC=windows-7

answered Jun 2, 2015 at 10:35

AnalystCave.com

5,1242 gold badges25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating VBScript file Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related