Search:

Type: Posts; User: RichardSmith

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    1,209

    Re: VB.Net Script File

    What I meant by VB Scrip was I was hoping to have an executable file, that I just had to double click on and the process would execute from start to finish.
    For the recursive file search I tweaked...
  2. Replies
    3
    Views
    1,209

    VB.Net Script File

    Can someone provide me with a vb.net script file that will cycle thro directory's/sub-directory's and if a .mdb (or .accdb) file is found, copy the sub directory (and of course the database file) to...
  3. Re: Passing Connection & SQL String from VB.Net to VBA

    BUMP ---- Anyone have any insight into this?! Or can it be done, can it not be done?
  4. Passing Connection & SQL String from VB.Net to VBA

    I just discovered that you can use VS 2010 to create a Excel 2007 (or 2010) workbook. I can then use that to create a connection to SQL Server and code in a few queries etc and set the destination...
  5. Replies
    14
    Views
    1,413

    Re: VB.Net & USP

    I didn't think the table name piece was possible at all, but I wasn't crystal clear, so I wanted to ask and know for certainty.

    EDIT ---
    I was only asking due to the fact I was going to run the...
  6. Replies
    14
    Views
    1,413

    Re: VB.Net & USP

    Seeing it together like above helps the pieces fall into place. That is essentially what I was getting at in post # 5. Now I am able to take the steering wheel and drive this train on home.
  7. Replies
    14
    Views
    1,413

    Re: VB.Net & USP

    I no try to make you upset with myself. I just do not understand the examples listed in your CodeBank. It seems to me that I would use the below:


    Parameters.AddWithValue("@EmployeeName",...
  8. Replies
    14
    Views
    1,413

    Re: VB.Net & USP

    ----- A data reader...All I want to do is view the records, not add/update/edit
    ------- I see the Using Command line of code, but I am still in the dark as to how I would pass the parameters.
  9. Replies
    14
    Views
    1,413

    Re: VB.Net & USP

    I only want to pass to a Select statement...and if I follow the examples correctly, is this how it should be?


    Using connection As New SqlConnection("connection string here")
    Using adapter As...
  10. Replies
    14
    Views
    1,413

    Re: VB.Net & USP

    This is what I would be doing....Retrieving multiple records for display that will not be updated


    Using connection As New SqlConnection("connection string here")
    Using command...
  11. Replies
    14
    Views
    1,413

    VB.Net & USP

    How would I pass parameters from VB.Net to a SQL Server Stored procedure?
  12. Re: Create a New Workbook with VB.Net

    I stand corrected! Thank you again! Amazing guide btw
  13. Re: Create a New Workbook with VB.Net

    That site is a tremendous help, thank you for the assistance. One question that I do not see covered....How can I take a selection and make the font bold?


    Dim xlsApp As Excel.Application
    Dim...
  14. Re: Create a New Workbook with VB.Net

    I did read your 1st post, it just didn't click until I saw it in action. I am very new to VB.Net and am trying to learn the ins and outs on my own/forum assistance.

    Do I need to actually add a...
  15. Re: Create a New Workbook with VB.Net

    Ah that makes sense than as to why:


    Dim excelApp As New Excel.Application
    Dim excelBook As Excel.Workbook = excelApp.Workbooks.Add()


    This worked because I assigned the...
  16. Re: Create a New Workbook with VB.Net

    I found this code and it works, but I don't understand why it is different than what I posted above.


    Dim excelApp As New Excel.Application
    Dim excelBook As Excel.Workbook =...
  17. Re: Create a New Workbook with VB.Net

    I modified my code to this:


    Application.Workbooks.Worksheet.Add()

    Would that be a sufficient way of adding a workbook with VB.Net? If so, I am getting an error of NullReferenceException was...
  18. [RESOLVED] Create a New Workbook with VB.Net

    I thought this would work, but it doesn't:


    Dim newWorkbook As New Excel.Workbook = Me.Application.Workbooks.Add()


    And this gives an error of end of statement expected

    How can I add a...
Results 1 to 18 of 18



Click Here to Expand Forum to Full Width