Search:

Type: Posts; User: Sean04

Page 1 of 3 1 2 3

Search: Search took 0.05 seconds.

  1. Replies
    6
    Views
    796

    Re: Add folder files to a drop down

    Thanks guys

    Works great paul!
  2. Replies
    6
    Views
    796

    Re: Add folder files to a drop down

    Hey thanks! Works great! How would I just get the filename rather then the entire directory? :p
  3. Replies
    6
    Views
    796

    [RESOLVED] Add folder files to a drop down

    Hey,

    How would I get the full name of a file(s) and put them all into a drop down list. Essentially what i'm trying to do is have a list of temples that are in a folder and a user can pick which...
  4. VS 2008 Re: how to transform textboxes to excel within my prorame

    Yeah I see what you mean. I'm not to sure how to write it but obviously your going to need a loop that goes through the rows each time you click the submit button.

    You should just use a list box...
  5. VS 2008 Re: how to transform textboxes to excel within my prorame

    why dont you make it so that all textboxs have to be filled in before data gets exported to the excel sheet?
    and each update it just reopens that specific sheet?
  6. VS 2008 Re: how to transform textboxes to excel within my prorame

    So what exactly are you trying to do?
    You can do something like this if you want textbox values to go to different cells:



    xlApp.Range("A1").Value = TextBox1.Text
    xlApp.Range("A2").Value =...
  7. Replies
    5
    Views
    712

    VS 2008 Re: problem transform textboxes to excel

    Oh I just noticed you said "from a textbox" :p

    In that case you can simply use:




    Dim xlApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)
    ...
  8. Replies
    5
    Views
    712

    VS 2008 Re: problem transform textboxes to excel

    Post your code, all you should have to do is replace the textbox.text with the variable name. Let me take a look.
    And by the way, myRandomNumVariable should be replaced with YOUR variable name.
  9. Replies
    5
    Views
    712

    VS 2008 Re: problem transform textboxes to excel

    I'm sure you got this correct? Just use what I gave you here and instead of the TextBox1.Text, just put your variable.

    http://www.vbforums.com/showthread.php?t=607821



    Imports...
  10. VS 2008 Re: [RESOLVED] Sending email of selected items in listbox

    Good glad it worked out! :)
  11. VS 2008 Re: how to transform textboxes to excel within my prorame

    Sorry that I didn't get back to you on time.

    I'm glad you found everything and glad everything is working :)
  12. VS 2008 Re: Sending email of selected items in listbox

    Hmm.. its the strangest thing.. but yeah take a look for the dll.. if still no luck come back and post here, i'm sure someone will give you a hand! And I'll try and check it out as well. The weird...
  13. Replies
    8
    Views
    966

    Re: Writing Data to an Existing Excel File

    Try this..



    Dim xlApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)
    Dim xlAppWorkbook As Excel.Workbook =...
  14. VS 2008 Re: how to transform textboxes to excel within my prorame

    Start by adding the Microsoft.Office.Interop.Excel reference. You can do this by going to Project > Add Reference > (under the .NET Tab add) Microsoft.Office.Interop.Excel

    Add a button and a...
  15. VS 2008 Re: how to transform textboxes to excel within my prorame

    Try something like this..



    Dim xlApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)
    Dim xlAppWorkbook As Excel.Workbook =...
  16. VS 2008 Re: Sending email of selected items in listbox

    I'm pretty sure anything thats under the .NET Tab comes with the .NET framework... maybe download the .NET 3.5 Framework? If that doesn't work then try and look for the .dll file. Besides that I'm...
  17. VS 2008 Re: Sending email of selected items in listbox

    hmm.. maybe add the Microsoft Office 12.0 Object Library then take a look in the .NET tab?
  18. VS 2008 Re: Sending email of selected items in listbox

    Is there anything under the .NET tab that has outlook in it?
  19. VS 2008 Re: Sending email of selected items in listbox

    Before the class even starts. You might have to go to Project > Add Reference > (and under the .NET Tab add) Microsoft.Office.Interop.Outlook
  20. VS 2008 Re: Sending email of selected items in listbox

    You might have to use this instead of your code. This works:




    Dim ListBoxValues As String = Nothing

    For Each ItemInListBox As Object In ListBox1.SelectedItems
    ...
  21. VS 2008 Re: Sending email of selected items in listbox

    No problem!

    Yeah I was checking that out. I thought something like this would work as it seems to give the line break in the messagebox but not in the body of the message:




    Dim...
  22. VS 2008 Re: Sending email of selected items in listbox

    Oh right sorry..




    Dim ListBoxValues As String = Nothing

    For Each ItemInListBox As Object In ListBox1.SelectedItems
    ListBoxValues = ListBoxValues + ItemInListBox &...
  23. VS 2008 Re: Sending email of selected items in listbox

    This will get all the selected values in the listbox:



    For Each ItemInListBox As Object In ListBox1.SelectedItems
    MessageBox.Show(ItemInListBox)
    Next
  24. VS 2005 Re: Determine a dataset column data type???

    Try this..


    Dataset1.Tables.Columns("column").DataType
  25. Replies
    7
    Views
    11,135

    Re: Run a macro at a specific time..

    Thanks westconn,

    I was looking around and thats exactly what I found


    Application.OnTime TimeValue("13:00:00"), "Macro"

    This doesn't seem to work for me.. either that or I'm not putting it...
  26. Replies
    7
    Views
    11,135

    Re: Run a macro at a specific time..

    Thanks for the reply LaVolpe, I managed to get rid of the security warnings with your suggestion.

    As for auto running a macro, I'm aware of the load event that will run a macro on start up but I...
  27. Replies
    7
    Views
    11,135

    Run a macro at a specific time..

    Hey,

    So I have an Access Application and I'm using a Scheduled Task to run it everyday at say.. 5:00 pm. How would I run a macro at a specific time (lets say 5:01 pm).

    And I know this isn't an...
  28. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    Thank you koolsid! Works perfectly! :)

    Sean
  29. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    hmm... mine doesn't seem to work and yes I have implemented your edit. Could you send me your code? I'm probably missing something small.
  30. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    It still seems to give me the same result as before where most are red. Should I be removing String.Format? I'm not to sure...

    Thanks,
    Sean
  31. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    Sorry about that..

    Red dates are suppose to be weekends
  32. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    I attached my code.. thats all I have though!
  33. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    Like the code? Or a screenshot of the excel file and what it actually looks like?
  34. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    This is what I currently have. All the cells listed have a date in them and its displayed like March 10, 2010. For some reason after the 15th, all the cells become red. Am I doing something wrong?
    ...
  35. Replies
    5
    Views
    3,034

    Re: Call an excel on click function with vb.net

    Hey thanks sapator. I actually just came across that site and it worked perfect!

    Thanks again though,
    Sean
  36. Replies
    5
    Views
    3,034

    Re: Call an excel on click function with vb.net

    thank you for the reply Hack, but is there any other way that this can be done? like running a macro from an excel doc from a vb.net application.
  37. Replies
    5
    Views
    3,034

    [RESOLVED] Call an excel macro with vb.net

    I have an excel document that has a button that i need to activate through vb.net. Anyone have any idea?

    Thanks,
    Sean
  38. Thread: getting name

    by Sean04
    Replies
    6
    Views
    823

    VS 2005 Re: getting name

    This works..



    Dim lines() As String
    Dim string1 As String
    string1 = TextBox1.Text
    lines = string1.Split(":")

    Dim Result As String
  39. Replies
    1
    Views
    463

    VS 2008 Re: Retrieving Information from a Web Page

    Look into regular expressions. That should help you obtain the exact information you need every time you execute the program. As long as the webpage is updated, you will be to :p
    ...
  40. Replies
    16
    Views
    2,959

    Re: Find Weekends? (vb.net/excel)

    Thanks for the reply guys,

    cicatrix, I am looking more for the WEEKDAY() as I knew it exsisted but didn't know how to use it :p thanks though!!

    Koolsid, in my excel sheet I have dates going...
Results 1 to 40 of 103
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width