Search:

Type: Posts; User: Resource Dragon

Page 1 of 4 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    5
    Views
    7,878

    Re: A Basic Calculator

    I'm possibly being a bit picky here but I would put the Choose Operator frame in between the two number text boxes and label the radio buttons "Plus", "Minus", "Multiplied by" and "Divided by",...
  2. Re: Search Subfolders For File and Open It

    I think the moderator needs to move this question into Office Development.

    That said, the good people at VBForums helped me with searching through sub-folders using the following code. (I was...
  3. Re: Resetting font color in excel after update

    Aside: If your users are compulsive date dotters, you can always look at inserting a routine to change any dots in the date range (your A4:C8 above) to slashes or hyphens. It's a little extra work...
  4. VS 2010 Re: [RESOLVED] VB 2010 Express: Run .exe file on computer without .NET framework

    That's what I thought. They do selective Windows updates. I might try my search again, in case I searched wrongly. Along with the selective Windows updates, they also do selective deletions, e.g....
  5. VS 2010 Re: [RESOLVED] VB 2010 Express: Run .exe file on computer without .NET framework

    For the record, I checked on the .NET framework and discovered it was ... FW1!
  6. VS 2010 Re: VB 2010 Express: Run .exe file on computer without .NET framework

    Wow, guys! Thank you for all the info & discussion. As I'm sure you've deduced, I am very much a beginner in the world of .NET. I would agree with Niya's last comment.
  7. VS 2010 Re: VB 2010 Express: Run .exe file on computer without .NET framework

    Dear tg

    I'll try that. (I'll search for the FW2 before attempting to recompile!) There are apps that live in the various drives, so someone must have found a way of getting them to work. [If...
  8. VS 2010 Re: VB 2010 Express: Run .exe file on computer without .NET framework

    UNGG! Largely due to my ignorance, (combined with issues of the network on which the program needs to run) I might have to fall back on VBA & putting the project in a Word or an excel file. As this...
  9. VS 2010 [RESOLVED] VB 2010 Express: Run .exe file on computer without .NET framework

    I am having a few dramas with running my completed project on another computer. I created my project using Visual Studio 2010 (Microsoft Visual Basic 2010 Express).

    The error messages I get say...
  10. VS 2010 Re: how to Color wanted text in textbox???

    I'm not sure that what you want to do is possible. The best I can suggest is two text boxes (or labels) that look like one but are in fact separate entities and then you can code the colour for each....
  11. Replies
    5
    Views
    22,689

    Re: Format as currency

    The "Leave" event does the trick. Thank you all.
  12. Replies
    5
    Views
    22,689

    Re: Format as currency

    Thank you both. I'll need to fiddle a bit more, as the TextChanged event (which is the default VB.Net provides) isn't quite what I want. I need something like AfterUpdate or Exit.
  13. Replies
    5
    Views
    22,689

    [RESOLVED] Format as currency

    Please excuse a beginner in VB Net with what is probably a really dumb question.

    I am trying to write some code that will format the text in a text-box as currency, so that if the user enters "6",...
  14. Re: Edit row data in a Userform

    The code below assumes that you have a userform with two text boxes and a command button. I've also got a fairly limited number of rows of data that I'm working with.


    Private Sub...
  15. Re: Get at sub folders in a special folder

    Dear tg

    Thank you for your reply. Questions always make much so much more sense to the writer than the reader!

    The following code seems to be doing the trick:


    Sub GetTempFolder_2()
    ...
  16. [RESOLVED] Get at sub folders in a special folder

    I am trying to get into sub folders inside a special folder (the temp folder) programmatically and I am not having a lot of success. With Microsoft Scripting Runtime added to the references, the...
  17. Replies
    5
    Views
    19,170

    Re: VBA in Excel Calculator

    I haven't programmed a calculator but I have written programs that add and multiply busily. To do that, instead of having "firstnumber" and "secondnumber" and so on, I used arrays.

    Once you get...
  18. Replies
    8
    Views
    1,314

    Re: Merge field syntax problem

    You’ve lost me. Which expression returns a MailMerge object? If I try using, say, wrdDoc as a MailMerge object, VBA complains that the object or method is not recognised.
  19. Replies
    8
    Views
    1,314

    Re: Merge field syntax problem

    I recorded a macro in Word, and this is what I got:


    Sub Macro1()
    '
    ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
    Selection.TypeText Text:="Dear "
    ...
  20. Replies
    8
    Views
    1,314

    Re: Merge field syntax problem

    Dear Pete

    I'm not quite sure what you mean by "make it into a merge document", if I'm looking at Word 2007 I've got options like template & macro-enabled (or I can have a regular document). Am I...
  21. Replies
    0
    Views
    378

    Office 2010 favour request

    G'day. I was hoping someone could please do me a small favour. I have Office 2007 and I need some info from Office 2010.

    What I need is for someone with Office 2010 to open a new file in Excel,...
  22. Replies
    8
    Views
    1,314

    Re: Merge field syntax problem

    No, wrdDoc is a new, blank document until the code populates it, based on choices the user has made. (The code lives in an excel file, and opens word and outlook.)

    I've tried recording a macro in...
  23. Replies
    8
    Views
    1,314

    Merge field syntax problem

    I am trying to insert a mail-merge field and I can't find the correct syntax.

    This is what I've got so far and it doesn't work.


    With wrdDoc
    .Content.InsertAfter Format(MyDate, "dddd, d...
  24. Re: One combo box isn’t behaving itself

    Yes, using a "click" event with both combo-boxes solves the problem. Thank you for spotting that.
  25. Re: One combo box isn’t behaving itself

    Try this.
  26. Re: One combo box isn’t behaving itself

    Oops! I don't appear to have succeeded in uploading the file!

    Ah, well, here is the code instead:


    Dim row_number As Integer
    Dim the_row As Integer
    Dim Range3P As Range
    Dim RangeOP As Range...
  27. [RESOLVED] One combo box isn’t behaving itself

    I’ve got a problem with a user form which has two radio buttons and two combo boxes. The rowsource depends upon which radio button the user clicks. (See attached file.)

    The user chooses a radio...
  28. Re: combo box and excel data type problem

    The code "If Val(ComboBox1) = Sheets("Sheet3").Cells(i,1) " works for the numbers but not for the strings. If, however, I amend the code to:


    Private Sub Frequencies()
    For i = 2 To 5
    If...
  29. Re: combo box and excel data type problem

    Long numbers are like: 123456 or 89756259 or whatever. My strings look like: 05-E235664 or A908645 or 07-E34608 or whatever.
  30. [RESOLVED] combo box and excel data type problem

    I have created a combo box that picks up data from a column in an excel spread-sheet. I then want my code to populate various other labels and text boxes in my userform using the value in the combo...
  31. MsOf07 Re: Text Boxes to fill Option Buttons

    This may be a rather simplistic approach, but would something like:


    Private Sub txt_colour_AfterUpdate()
    If txt_red = "Red" then
    optRed = true
    End if
    end sub

    do the trick?
  32. Re: Office 2003 Favour Request

    Dear Sid

    Thanks for that. Much appreciated. Best wishes for Christmas & have a happy & safe holiday season.

    cheers

    The Dragon
  33. [RESOLVED] Office 2003 Favour Request

    G'day. I was hoping someone could please do me a small favour. I have office 2007 and I need some info from office 2003.

    What I need is for someone with Office 2003 to open a new file in Excel,...
  34. Replies
    7
    Views
    1,235

    Re: Mail Merge using Outlook Contacts

    For rusel and westconn1: The
    [CODE]WordBasic.MailMergeUseOutlookContacts[CODE]
    line came from recording a macro in Word 2007! (I did think it looked a bit odd...)

    I have considered using...
  35. Replies
    7
    Views
    1,235

    Re: Mail Merge using Outlook Contacts

    I've got some of the way along with this problem - apologies for the delay in postings but I've had internet dramas. The problem I have now is telling Word where I want it to insert the merge field....
  36. Re: Internet Access after virus removal

    Dear Stanav

    That didn't quite work but it pointed me in the right direction. I then went to Tools > Internet Options > Advanced and clicked Restore Settings. So I'm now back on the internet. Yay!...
  37. [RESOLVED] Internet Access after virus removal

    My PC has two user accounts. I am the Administrator. My profile was infected by a virus. It wouldn't let me open any programs from the desk top or the start menu. The other profile was not affected....
  38. Re: Automatically send multiple emails with attachments

    Not necessarily. You might, however, need to make up a larger array (say an n x 4, or n x 5) instead of the n x 3 I used to illustrate the principal. The sheet you set up with the names of the...
  39. Replies
    7
    Views
    1,235

    Re: Mail Merge using Outlook Contacts

    Thanks, Pete. I'm working on it, I'll let you know how I got & if I get something working nicely, I'll post it.

    cheers

    The Dragon
  40. Re: Cancel button on userform to exit sub

    Interesting! I wasn't aware of that.
Results 1 to 40 of 135
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width