Xtreme Visual Basic Talk

Xtreme Visual Basic Talk (http://www.xtremevbtalk.com/)
-   .NET Office Automation (http://www.xtremevbtalk.com/-net-office-automation/)
-   -   Scheduled VB task for Excel automation (http://www.xtremevbtalk.com/-net-office-automation/327013-scheduled-vb-task-excel-automation.html)

python01 04-30-2014 10:07 AM

Scheduled VB task for Excel automation
 
I am not very experienced in VB but I have a task I need to accomplish.

I have to run task once a day where the vb program would have to open Excel file, send some emails and close it.

I would like to get some information on how to program scheduled tasks in vb and what is the best way to process excel file.

Any help will be greatly appreciated.

JustinCase2 05-06-2014 02:47 AM

Actually
 
I don't see why you need to do anything With Your program. Just Write one that opens the file and does the work, and then set it to run once per day in Windows Scheduled Tasks.
When it comes to handling Excel, just refer to the Excel API through Visual Studio's "Add Reference". You will ofcourse need Excel installed on both Your Development computer and the eventual Client computer. If that is not possible then there are other ways to generate Excel files, but they are much more complicated.


All times are GMT -6. The time now is 03:00 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Optimisation provided by DragonByte SEO v2.0.15 (Lite) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
All site content is protected by the Digital Millenium Act of 1998. Copyright©2001-2011 MAS Media Inc. and Extreme Visual Basic Forum. All rights reserved.
You may not copy or reproduce any portion of this site without written consent.