Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.23 seconds.

  1. 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...
  2. Re: Runtime error 438 Object doesn't support this property or method

    which line gives the error?
  3. 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
  4. Replies
    13
    Views
    216

    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
    ...
  5. Replies
    4
    Views
    404

    Re: Excel Macro Divide By Zero Error

    post a workbook with the code and some sample data
  6. 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...
  7. MsOf13 Re: Accessing results from Document.Compare in VB.Net

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

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

    try doevents after inserting cell
  10. 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?
  11. Replies
    4
    Views
    404

    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...
  12. 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...
  13. Re: Finding the MODE of a list of integers

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

    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...
  15. 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...
  16. 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,...
  17. Replies
    7
    Views
    308

    Re: PowerPoint basic macros?!

    numbercorrect = 0
    numberwrong = 0
    after displaying the result
    or before starting the next set
  18. Replies
    3
    Views
    122

    Re: Cancel Button on Userform to Exit Sub

    you may need doevents within the code to create presentations, to allow the cancel button to be processed
  19. Replies
    1
    Views
    118

    Re: VBA Help: RegisterHotkey

    is this actually in VBA (visual basic for applications)?
    looks like VB.net, for which this would not be the correct forum, though someone may answer

    if it is vb.net, better to pm an mod and ask...
  20. Replies
    7
    Views
    308

    Re: PowerPoint basic macros?!

    do you set the count back to zero after each set?
  21. MsOf13 Re: How to get Tab-index from user form in ascending order

    the only real use for the tab index is to change the order that controls can be moved to by tabbing
    most controls also have an unused tag property that can be assigned a string for a reference of...
  22. Re: Excel VBA: Auto-Emailer, Mark Important, Delivery Receipt etc.

    try

    .importance = olImportanceHigh
    .OriginatorDeliveryReportRequested = True
  23. MsOf13 Re: How to get Tab-index from user form in ascending order

    what is the problem and what are you trying to achieve?
  24. Replies
    1
    Views
    124

    Re: How to detect a new file in a folder

    not required, there is a callback method

    all credits to authors
    some mods and testing by me as part of a current project


    'Please include the following comment in your source code
    'if you...
  25. Re: 'code execution has been interrupted' - phantom breakpoints?

    does your code write to vba modules?
    either way show the code that has problem, indicating which lines break the code
    or better post a sample workbook that demonstrates the problem
  26. Replies
    3
    Views
    213

    MsOf07 Re: Get Cell Location of Mouse Click

    the cell where you click the mouse becomes the activecell, so you can return activecell.row etc, but there is no way to tell if the cell was activated by mouse or keyboard
  27. Replies
    1
    Views
    209

    MsOf10 Re: Word Userform hiding behind document

    try, display the userform modally
    UserForm1.Show vbModal
  28. Replies
    2
    Views
    164

    Re: help with VBA Code for Outlook 2013

    you can try like

    for each itm in objsourcefolder.items
    Set cpy = itm.Copy
    cpy.UnRead = True
    cpy.Move objdestfolder
    Nextof course this does not take into account if the item has...
  29. Re: determine number of copies whicht we want print

    print how?
  30. Replies
    5
    Views
    211

    Re: browser control to fill a value

    you could use
    for each ele in wb.document.all

    you could also try
    for each ele in doc.getelementsbytagname("h5")
    which would be better, but i have not tested if this is valid for header tags
    ...
  31. Replies
    5
    Views
    211

    Re: browser control to fill a value

    there are hundreds of examples in this forum, but each page is specific, you can try like

    set frm = wb.document.forms(1)
    frm.all("usename").value = text1
    frm.submitchange element names and...
  32. MsOf13 Re: Excel 2013 - How to have the macro check if already executed

    you can use a static variable within the procedure like


    Sub DeleteEmptyRowsInActiveSheet()

    Application.ScreenUpdating = False

    Dim lngI As Long
    static runalready
    if not runalready then
  33. MsOf10 Re: Wait untill the Excel Sheet is finished calculated

    you can use application.wait, but you would need to specify the time to wait, based on some expectation
  34. Replies
    16
    Views
    319

    Re: objCommand.Execute takes incredibly long

    it there are variables used in the sql it will fail or cause errors when read from a text file, which may indeed increase the time to execute
  35. Replies
    16
    Views
    319

    Re: objCommand.Execute takes incredibly long

    regardless of what language is used to call the query, possibly this would be better answered in the database forum, but if you can not post the sql query (even if proprietry information is...
  36. Replies
    1
    Views
    122

    Re: Disable WebBrowser SUBMIT button

    you could try
    buttonelement.disabled = true
    once you have set an object to the button element
  37. Replies
    5
    Views
    245

    Re: A space issue in Outlook

    then put them in a table, with an empty cell between or padding
  38. Re: VBA Code to replace data in Greek and English

    yes, i could not make the vlookup work within existing formula, though it tested fine within someother cell, but figured it should be possible with all information to hand
  39. Replies
    5
    Views
    211

    Re: File copy existing "open" file

    you can try a function like

    Function manyfiles(fn As String)
    mypath = Left(fn, InStrRev(fn, "\"))
    ext = Mid(fn, InStrRev(fn, "."))
    tmp = Mid(fn, InStrRev(fn, "\") + 1)
    fname =...
  40. Replies
    5
    Views
    245

    Re: A space issue in Outlook

    you could try <br> or <p>
    or &nsp
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.