Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.39 seconds.

  1. Re: Using VBNullString to disregard blanks

    you can try
    change to
    if not isempty(X(lngrow)) then objDict(X(lngRow)) = 1
  2. Re: how to programatically close outlook model pop up in vb6.0?

    you may be able to use API from your vb program to find the window and close, findwindow, findwindowex and sendmessage
    no code will run in outlook or outlook object while dialog is open

    best to...
  3. MsOf13 Re: [Word] Inconsistent error 5941 when applying style to table.

    there is no reason to activate the word application, though should not cause problem,

    any problem in code, must be in some of the omitted code
  4. Replies
    2
    Views
    92

    Re: How to add text to a new mail?

    yes, but probably easier to make new default form
  5. Replies
    3
    Views
    160

    Re: Safty USB Remover

    there is a thread in codebank (vb6) by chris007 (i think that's right)

    search on unlocker
  6. Replies
    4
    Views
    99

    Re: Adding to a Word Document -VB6

    you can use words find replace method in a loop for each string to be replaced within the document

    i will request this moved to office development, where you are more likely to get replies
  7. Re: [Excel] Macro to delete rows based on values, help please

    when deleting rows you should start at the bottom as when working from top deleted rows change the loop index

    second line is not required as i is never less than 5
    try like

    for rw = lastrow to...
  8. Replies
    3
    Views
    102

    Re: getting last element item in html

    which part does not work, setting the collection, or getting the last element?
  9. Replies
    24
    Views
    354

    Re: Very strange Overflow error

    so what is P dimensioned as?
    do you have option explicit at the top of module?
  10. Replies
    3
    Views
    102

    Re: getting last element item in html

    try like

    set eledd = WebBrowser1.Document.getElementsByTagName("dd")
    c = eledd.Item(eledd.length).innerText
    not tested, may need adjustment
  11. Re: Deleting a range of (pages) in a word 2003 document

    try like

    Dim r As Range
    Set r = ThisDocument.Content
    Selection.GoTo wdGoToPage, wdGoToAbsolute, 2
    r.Start = Selection.Start
    r.End = ThisDocument.Characters.Count
    r.Delete
  12. Replies
    4
    Views
    102

    Re: Best way to sync tasks in Outlook?

    i believe it would be possible in vbscript, so presumably also in other scripting
  13. Replies
    22
    Views
    331

    Re: Need Outlook VBA Code - please help!

    you commented that part because of startup error

    in both procedures change to

    if myx.selection.count = 1 then set myitem = myx.selection(1)
    should fix the error and catch the replyAll event...
  14. Re: Simple (Set date and modify URL -> Download file)

    did you read the post?, i can still see brackets
  15. Re: Simple (Set date and modify URL -> Download file)

    i tested that part of the posted code sample, in VBA, worked without error, returned the correct result
    if you have brackets they should be removed as per the original sample
    this error is nothing...
  16. Replies
    22
    Views
    331

    Re: Need Outlook VBA Code - please help!

    variables with events must be in a object module (class or other object), may work in thisoutlooksession, else add a class module

    the above code is very similar to what i was trying (without...
  17. Re: Need help adding program to firewall exception list

    have a look at
    http://www.vbforums.com/showthread.php?682436-Add-Apps-to-window-7-firewall-for-all-Profiles&highlight=firewall+exceptions
  18. Re: Deleting a range of (pages) in a word 2003 document

    this is specific to excel, not applicable to word
  19. Re: Downloading from URL and changing the url?

    if your textbox is named enddatebox this variable (declared locally) will take preference over the object, so endatebox in the myurl string will be nothing
  20. Replies
    22
    Views
    331

    Re: Need Outlook VBA Code - please help!

    there is a replyall event, but i was unable to make it work, the mailitem kept disconnecting from the withevents object variable before the event was triggered, i did play with i for a while, but as...
  21. Re: Downloading from URL and changing the url?

    try like

    myurl = "website\stuff\stuff\startdate=" & startdate & "&edate=" & enddatebox & thenthelastoftheurl

    i do not know if you need the & in front of edate
    assumes you already have...
  22. Re: Downloading from URL and changing the url?

    try like

    myurl = "website\stuff\stuff\startdate=" & startdate & "&edate=" & enddatebox & thenthelastoftheurl

    i do not know if you need the & in front of edate
    assumes you already have...
  23. Re: Downloading from URL and changing the url?

    try like

    myurl = "website\stuff\stuff\startdate=" & startdate & "&edate=" & enddatebox & thenthelastoftheurl

    i do not know if you need the & in front of edate
    assumes you already have...
  24. Re: Downloading from URL and changing the url?

    try like

    myurl = "website\stuff\stuff\startdate=" & startdate & "&edate=" & enddatebox & thenthelastoftheurl

    i do not know if you need the & in front of edate
    assumes you already have...
  25. Re: Downloading from URL and changing the url?

    no very easy

    did you search for urldownloadtofile as suggested?
    it should do all you require

    personally, i would prefer to know the code can work first
  26. Re: Import data from CSV files to Excel Master sheet

    are all the files in the same folder?
  27. Replies
    1
    Views
    119

    Re: Help with excel macro

    this is the wscript shell being created, you would have to use some other method to download the file



    try like

    set s = s.exec(range("a4"))
  28. Re: Downloading from URL and changing the url?

    try like


    myurl = "www.somesite.com/somestuff/" & text1 & text2 ' where text1 and 2 are the names of your textboxes

    you can use urldownloadtofile API to download to specific folder, without...
  29. Re: user32 API Calls from VBA 7.1 in Word 2013

    did you check if user32.dll in in system32 folder?

    should that be
    Private Declare Function GetKeyState Lib "user32.dll" (ByVal nVirtKey As Long) As Long
  30. Replies
    6
    Views
    135

    Re: problem with ado

    is it not something like adodc.update?

    like Sam i also do not use adodc, instead preferring to ADO with standard controls
    search on why bound controls are evil
  31. Re: Export outlook email body to excel

    not quite right, try like


    'Find the next empty line of the worksheet
    rCount = xlSheet.UsedRange.rows.Count
    rCount = rCount + 1
    For Each olItem In Application.ActiveExplorer.Selection
    sText...
  32. Replies
    11
    Views
    8,763

    Re: [RESOLVED] Export ListBox data to Excel...

    index of first column should be 0 in listbox, but 1 in excel worksheet

    try starting from columnindex = 0 but add 1 to the cell column
  33. Re: Export outlook email body to excel

    i would have thought so too, but possibly it might not update the usedrange while the macro is still running

    first remove on error resume next so if any error occurs you will know

    if each email...
  34. Re: user32 API Calls from VBA 7.1 in Word 2013

    what version of windows?
    64 bit?
  35. Re: Deleting a range of (pages) in a word 2003 document

    if you make a loop, you can keep deleting page 2 until only one page, if you need to keep a page you then need to start deleting page 3 and so on

    generally when deleting anything from within a...
  36. Replies
    3
    Views
    117

    Re: Type Mismatch error

    did they also upgrade their office version?
  37. Re: Excel - Use VB to find next first blank cell in a row... With a twist!

    of course

    you can use find for each named range, or else just offset by the plot number from the top of each table
  38. Re: Placing Text From A .txt File At The Cursor Position

    i do not believe you can do as requested, excel can not be automated whilst in edit mode
  39. Re: Error in Excel VBA code for inserting combo box - "Insert method of Range Class f

    set mysht = workbooks("mybook.xls").sheets("sheet1")
  40. Re: using relative file paths instead of absolute

    if you want to find current users folders or other system folders, you should be returning from the special folders collections

    to do this you can use API, wscript shell object or environ...
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.