Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.22 seconds.

  1. Re: [RESOLVED] For Statement cannot support 2 Next commands in the same routine

    you should avoid the goto, use if / else
  2. MsOf10 Re: Outlook 2010 - Delay Delivery of Emails

    post the code you have found, someone may be able to modify for you
  3. Replies
    9
    Views
    189

    Re: [Word 2010] Macro creation assistance

    you need to consider the steps required, then you can record a macro
    in general recorded macros can only help, they are not a final solution
    you would need to put the recordings together in a loop...
  4. MsOf10 Re: Excel and Vba....need to concat Excel column values as string for sql "in(1,2,3)"

    while this is not exactly what you are asking, it may enable you to work out a query to do what you want

    this selects records on sheet5 that are not on sheet1, to later, append only unique names...
  5. Re: For Statement cannot support 2 Next commands in the same routine

    remove the END keyword, as it will cause issues when called
    a search will provide plenty of detail
    exit sub would be much better
  6. Replies
    5
    Views
    211

    Re: smtp gmail sending error help please

    in the past sometimes it works and sometimes not
    it may be that google has improved (increased) login security and now preventing this script from working
    following links, brings me to a page like,...
  7. MsOf07 Re: "[Excel] insert a cell after a upper case cell found.........

    as isnumeric will not work for numbers like that, maybe you can try like

    If val = UCase(val) and lcase(val) <> ucase(val) Then
  8. Replies
    4
    Views
    150

    MsOf10 Re: Save File, Email and then delete

    try the code more like as i posted
    i did comment the relevant parts

    kill will delete files, but not while the file is open
    you can not delete an open workbook, it must be closed first
    i am not...
  9. Re: Macro Button to Print required Pages of Excel

    my test worked correctly
  10. Replies
    5
    Views
    211

    Re: smtp gmail sending error help please

    the code looks like it should be correct, very similar to what i have
    i doubt your isp will block port 465, though not impossible
    i believe smtp is enabled by gmail as default, but worth checking
  11. Re: Macro Button to Print required Pages of Excel

    try like

    printheader = true
    For rw = 34 To Cells(Rows.Count, 1).End(xlUp).Row Step 30
    If Weekday(Cells(rw + 1, 10), vbMonday) < 6 Then
    if printheader then
    ...
  12. Re: Can't compile module (easy Sub)

    i would assume that all the * should be spaces
  13. MsOf07 Re: Passing a textbox itself to a procedure to format border colors

    tb is an object (textbox), it is not referenced as control of the userform, remove the preceding . in the with block

    Case True
    With uf
    tb.BorderColor = &H80000006
    .ErrorMessageLabel.Visible =...
  14. Replies
    4
    Views
    150

    MsOf10 Re: Save File, Email and then delete

    does strnewfoldername have a value assigned at any point? it does not show in your code, which should give you a filepath\name of
    P:\\IEPTRANSFER.doc
    the double \\ could be a problem, note there is...
  15. Re: Macro Button to Print required Pages of Excel

    is this just for the first page?
    if so try


    cells(1, 1).resize(33, 10).printout
    For rw = 34 To Cells(Rows.Count, 1).End(xlUp).Row Step 30
    If Weekday(Cells(rw + 1, 10), vbMonday) < 6 Then
    ...
  16. Re: Macro Button to Print required Pages of Excel

    please explain in detail
  17. Re: Office 2007 Excel - populate opened application from userform

    findwindow should work like that, check the window caption for any extra or different characters
    test with other windows, to see if you get a result

    just about all windows have an icon, should...
  18. MsOf13 Re: [Excel] How do I copy specific rows in another sheet based on criteria

    post a sample workbook with some data and example
  19. Re: How to make Footer Page Numbering to continue from previous sheet

    apart from counting the horizontal and vertical page breaks, i do not know if you can return the number of print pages from each sheet,
    though using google i found this

    MsgBox...
  20. Re: Macro Button to Print required Pages of Excel

    that is a really great explanation!!

    what happens?
    do you get an error?
    wrong result?
    nothing happens?
    are you sure the code is called?

    and yes as bryce suggests the date is on line 5, i...
  21. Re: Macro Button to Print required Pages of Excel

    you can test if this works as you want


    Sub printweekdays()
    Dim rw as Integer
    For rw = 4 To Cells(Rows.Count, 1).End(xlUp).Row Step 30
    If Weekday(Cells(rw, 10), vbMonday) < 6 Then
    ...
  22. Re: Macro Button to Print required Pages of Excel

    please post the attachment in the forum
    if it is .xls zip first
  23. Re: run vbs from vba and output results back to vba

    did you try like

    Set wsh = VBA.CreateObject("WScript.Shell")
    Set objWshScriptExec = wsh.Exec("ipconfig /all")
    myvar = objWshScriptExec.StdOut.ReadAll
  24. MsOf07 Re: Toggle Buttons hides/unhides a table below it

    you can test this to see if it works for you
    this assumes that each table is a named range and the button is placed over part of table

    Private Sub ToggleButton1_Click()
    For Each n In...
  25. Re: Office 2007 Excel - populate opened application from userform

    try
    findwindow
    findwindowex
    sendmessage
    and other
    API functions

    you will find many examples in this and the VB6 forums and many more on google
    one example here...
  26. Re: Runtime error 438 Object doesn't support this property or method

    which line gives the error?
  27. Re: Runtime error 438 Object doesn't support this property or method

    this does not look right, even if it works it would insert the images into the range for each cell in the column

    i have requested this moved to office development
  28. Replies
    13
    Views
    255

    Re: DAO idiosyncrasies

    if you want an example for that, update the Visdata project included with VS6
    the instructions are online

    here is the link, in case anyone is interested
    http://support.microsoft.com/kb/252438
    ...
  29. Replies
    4
    Views
    460

    Re: Excel Macro Divide By Zero Error

    post a workbook with the code and some sample data
  30. Re: Sendkeys to IE window with a specific title

    will appactivate work to some other window or application on the machines that give error?
    are they using 32 or 64 bit os?

    are you filling in a web form or a dialog box?
    for webforms, i am sure...
  31. MsOf13 Re: Accessing results from Document.Compare in VB.Net

    set revs = doc1.revisions
    For Each r In revs
    MsgBox r.Range.Text
    Next
  32. MsOf13 Re: Accessing results from Document.Compare in VB.Net

    what have you tried so far?
  33. MsOf07 Re: "[Excel] insert a cell after a upper case cell found.........

    try doevents after inserting cell
  34. Re: Sendkeys to IE window with a specific title

    you need to supply more details and what code you are using that does not work correctly
    what are you actually trying to send to the internet explorer window?


    what operating system?
  35. Replies
    4
    Views
    460

    Re: Excel Macro Divide By Zero Error

    when the code stops, it normally will go into debug mode, but if it is not there is some error handing code that overrides the default break mode

    you need to find where the error handling is...
  36. Re: How to identify row number containing cells matching data user enters as search?

    i am sure your users would appreciate if you were to use a userform, instead of all those message boxes, all the information could be entered into textboxes with some radio buttons to choose the...
  37. Re: Finding the MODE of a list of integers

    if excel is available to automate, you could just use the worksheet function
  38. Replies
    7
    Views
    326

    Re: PowerPoint basic macros?!

    Sub Results()
    MsgBox ("You got " & numberCorrect & " out of " & numberCorrect + numberWrong & ", " & UserName), vbApplicationModal, " IT Quiz"
    if msgbox("start again?",vbyesno) = vbyes then start...
  39. Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.

    on the CD
    silly as it may seem the VBA help file is an optional install when installing office
    i always do a custom install so i can select VBA help and deselect the stupid office assistant...
  40. Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.

    lol

    most of the information is in the vba help file, that is where i looked the value
    else google
    unfortunately, as there are multi values for importance, vba true = -1, is not one of them,...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.