Solved

Easiest way to make a visual basic.net program automated

Posted on 2008-06-25
6
178 Views
Last Modified: 2013-11-26
I created a program for a client that extracts data from a database and then writes it to a textfile.  I originally built it with a form with a button that they would need to click to start the program.  A message then pops up that the export completed successfully and then they have to close the program.  They now do not want any of this.  They want to be able to schedule the .exe using windows scheduler.  What is the easiest way to make this program automated?  I want to remove the form, button etc....  

Thanks!!!!
0
Comment
Question by:stephaniem712
  • 3
  • 3
6 Comments
 
LVL 85

Accepted Solution

by:
Mike Tomlinson earned 500 total points
ID: 21867309
For VB.Net 2003, add a Module and make a Public Sub Main in there.  Then put your code in "sub main".  Finally change the "startup object" in Project --> Properties to "sub main" and recompile.  The new exe should simply run your code and then end.

Module Module1
 

    Public Sub Main()

        ' ... put your code in here ...

    End Sub
 

End Module

Open in new window

0
 

Author Comment

by:stephaniem712
ID: 21868604
I created a new project and added a module.  I copied the code as instructed and I'm getting messages that I need to declare
psCompanyINI
psCompany.....etc. even though they are all declared as shown below in the piece fo code I attached..

Module DataExport

    Public SubMain()


    Dim FILE_NAME As String = "C:\Rolligon\Data\POPayHist.txt"
    Dim psCompanyINI As String = ""
    Dim psCompany As String = ""
    Dim psUN As String = ""
    Dim psPW As String = ""

    Dim textr As TextReader = New StreamReader("C:\ExportINI.txt", False)

        psCompanyINI = textr.ReadToEnd
        textr.Close()
        psCompany = Split(psCompanyINI, "Company=")(1).Split(ControlChars.CrLf)(0)
        psUN = Split(psCompanyINI, "UN=")(1).Split(ControlChars.CrLf)(0)
        psPW = Split(psCompanyINI, "PW=")(1).Split(ControlChars.CrLf)(0)
0
 
LVL 85

Expert Comment

by:Mike Tomlinson
ID: 21868860
You sure have the spaces in there correctly and the mathching End XXX parts?
Module DataExport
 

    Public Sub Main()

        Dim FILE_NAME As String = "C:\Rolligon\Data\POPayHist.txt"

        Dim psCompanyINI As String = ""

        Dim psCompany As String = ""

        Dim psUN As String = ""

        Dim psPW As String = ""
 

        Dim textr As New StreamReader("C:\ExportINI.txt", False)

        psCompanyINI = textr.ReadToEnd

        textr.Close()

        psCompany = Split(psCompanyINI, "Company=")(1).Split(ControlChars.CrLf)(0)

        psUN = Split(psCompanyINI, "UN=")(1).Split(ControlChars.CrLf)(0)

        psPW = Split(psCompanyINI, "PW=")(1).Split(ControlChars.CrLf)(0)

    End Sub
 

End Module

Open in new window

0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:stephaniem712
ID: 21869061
I created a new project - a windows application.  Is this correct?  It includes a form.  When I delete the form and copy in the code (which now appears to be ok), I get build errors..  having to do with the deleted form..
0
 
LVL 85

Expert Comment

by:Mike Tomlinson
ID: 21869108
You need to go into Project --> Properties and change the "Startup Object" to "Sub Main".
0
 

Author Comment

by:stephaniem712
ID: 21869328
I apologize. You did say that.  That worked!   Thanks for the help!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now