Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation
Scheduled VB task for Excel automation Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Go Back  Xtreme Visual Basic Talk > > > Scheduled VB task for Excel automation


Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2014, 10:07 AM
python01 python01 is offline
Newcomer
 
Join Date: Jun 2008
Posts: 22
Default 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.
Reply With Quote
  #2  
Old 05-06-2014, 02:47 AM
JustinCase2 JustinCase2 is offline
Junior Contributor
 
Join Date: Apr 2006
Posts: 324
Default 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.
Reply With Quote
Reply

Tags
excel, file processing, scheduling


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
 
Scheduled VB task for Excel automation
Scheduled VB task for Excel automation
 
-->