Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.29 seconds.

  1. Replies
    13
    Views
    219

    Re: Finding a substring in a Word document

    glad you have it sorted
    i will go back to vba land

    the full code sample in the last post is all vba anyway, though not hard to convert
  2. Re: [OUTLOOK] : for each / Case --> AppointmentItem / Items

    i can not see in this new code if objTerminGruppe2 is now a folder, or still an item collection object?
  3. Replies
    11
    Views
    228

    Re: Download a web page into a text file

    deleteurlcacheentry API
  4. Replies
    11
    Views
    228

    Re: Download a web page into a text file

    try deleting the cache entry for the url first
  5. Replies
    13
    Views
    219

    Re: Finding a substring in a Word document

    it is not relevant which year you use, it only returns the month name

    yes, but not comprehensively

    that was what my code does

    not enough information

    replace whole paragraph text
  6. Replies
    13
    Views
    219

    Re: Finding a substring in a Word document

    you can do like this

    ActiveDocument.Content.Select
    For m = 1 To 12
    Selection.Find.Execute Format(DateSerial(Year(Now), m, 1), "mmmm")
    If Selection.Start > 0 Then
    ...
  7. Re: Error no: 484 Problem getting printer information from the system. in VB 6 app

    that would defeat the whole purpose of terminal services
  8. Re: How to *drag and drop files to Excel* to get their names?

    lots of choices
  9. Re: Error no: 484 Problem getting printer information from the system. in VB 6 app

    example code?

    do some use (or try to use) the current widows default printer? whether selected specifically or not?
    how is the printer selected?
  10. Re: How to *drag and drop files to Excel* to get their names?

    i had not tested any, and no they do not work, excel must treat them differently

    have tested with most types of text files, dat file exe file zip file, and some others, the last 2 listed give...
  11. Re: How to *drag and drop files to Excel* to get their names?

    with events variables must be dimensioned in object modules, not general modules, best to use the thisworkbook module


    Public WithEvents app As Application
    Private Sub app_WorkbookOpen(ByVal wb...
  12. Re: How to *drag and drop files to Excel* to get their names?

    if you create an application with events object
    you can run an ontime procedure from the application workbook open event, that will return the name of any file dropped onto an open excel window,...
  13. Re: How to *drag and drop files to Excel* to get their names?

    you would have to use an API getcommandlineargs, though i believe there is some bug with this and need to use getcommandlineargsex

    i remember doing an example on this some years ago, i will see if...
  14. MsOf13 Re: How to make “Choose location to save dialog in VBA Powerpoint”

    if there is no application.filedialog in powerpoint, as with outlook


    Set cd = CreateObject("MSComDlg.CommonDialog")
    cd.InitDir = "C:\temp"
    cd.Filter = "imagefiles|*.jpg"
    cd.ShowSave
    getf =...
  15. Re: [OUTLOOK] : for each / Case --> AppointmentItem / Items

    should make no difference,

    i was using an existing folder, as i believed you were doing, maybe that is the problem

    here is another example

    Set cal =...
  16. Re: Finding Line in Word and deleting if starts with "search term"

    so try changing the code to

    For Each oPara In ActiveDocument.Paragraphs
    If InStr(1, oPara.Range.Text, "<!--Mobile-->") = 1 Then
    oPara.Range.Delete
    ...
  17. Replies
    3
    Views
    201

    Re: full file path when right click on it

    you can add a program to the right click menu, so that it will copy to the clipboard or a variable

    windows 7 and maybe vista already have this built in, from memory it is shift right click, copy...
  18. Re: Finding Line in Word and deleting if starts with "search term"

    post a sample document for testing
  19. Re: [OUTLOOK] : for each / Case --> AppointmentItem / Items

    @ bryce
    i would think not in .net
  20. Re: [OUTLOOK] : for each / Case --> AppointmentItem / Items

    this is a fully tested working example


    Set itms = GetNamespace("mapi").GetDefaultFolder(olFolderInbox).Items
    Set tgtitms = itms.Parent.Folders("test").Items
    For i = 1 To itms.Count
    If...
  21. Re: [OUTLOOK] : for each / Case --> AppointmentItem / Items

    that did not work for me, that is why i suggested setting the item to an object first, but i did not test completely
  22. Re: VBA code to extract informations from HTML files

    maybe, but to test some code i would need more
  23. MsOf07 Re: Screenshot of Excel Saved to Desktop

    there is no clipboard object in VBA, you can not use like VB6

    if you need to clear the clipboard, you would need to use the clipboard APIs
    or
    i have posted an activex, if you want, see...
  24. Re: [OUTLOOK] : for each / Case --> AppointmentItem / Items

    i think i pointed that out above

    should work to any folder

    i think the problem is that objTerminGruppe2 is not actually a folder but an items collection, you can try like


    msg =...
  25. Re: VBA code to extract informations from HTML files

    can you post a sample of html document?
  26. Re: for each / Case -->

    as stated above, you can not assign an item as a collection of items

    try like

    objTerminGruppe.Item(i).move objTerminGruppe2
    'OR if you want to copy
    mycopy = objTerminGruppe.Item(i).copy...
  27. Re: for each / Case -->

    afaik categories is a string list and may not be a single item match, better to use instr
    the code posted does not indicate what you are comparing to, is vcbHomeoffice (etc) a constant, variable or...
  28. Re: I am not able to see all threads in Office Development it is just showing only 55

    see thread display options below threads displayed, change time period selected
  29. Replies
    15
    Views
    324

    Re: close msg dialog in webbrowser

    once the dialog shows the timer does not fire until the dialog is closed

    you need to put this code into a separate exe then shell it before opening the dialog

    in a module

    'API used to...
  30. Replies
    15
    Views
    324

    Re: close msg dialog in webbrowser

    does the closewindow procedure ever run?
  31. Replies
    15
    Views
    324

    Re: close msg dialog in webbrowser

    i would need to access the webpage that is opening the dialog
  32. Re: Click a button after a submit form process has finished

    try another loop till readystate_complete, usually works, unless in some sort of frame
  33. Replies
    15
    Views
    324

    Re: close msg dialog in webbrowser

    it may be possible to do using findwindow and sendmessage APIs it may not be possible from within your application, as the code may not continue until the dialog is closed, may require creating a...
  34. Re: [RESOLVED] Multi-line TextBox VbCrLf Anomaly

    did you try a <br> between lines
  35. Re: [EXCEL]: Writing parts of XML data to cells

    xml is only text, so you can do whatever you want, you just need to parse out what you want and write to cells

    open the xml file using open
    read the entire content using input
    use instr to find...
  36. Replies
    2
    Views
    127

    Re: Need some advice on Word + VBA

    no need to use bookmark if you are using table for results, just place in cells
  37. Replies
    31
    Views
    493

    Re: webbrowser know item number?

    On Error Resume Next
    For e = 1 To wb.document.all.Length
    ' Set ele = wb.document.all(e)
    If wb.document.all(e).Name = "log_in" Then
    If Err.Number = 0 Then MsgBox e
    End If
    ...
  38. Replies
    31
    Views
    493

    Re: webbrowser know item number?

    what is the expected id number?
    i got a value of 71, is that correct?
  39. Replies
    31
    Views
    493

    Re: webbrowser know item number?

    you could also try


    msgbox webbrowser1.document.all("log_in").uniqueid
  40. Replies
    31
    Views
    493

    Re: webbrowser know item number?

    do you get the msgbox?
    if so just assign the value of i to a global variable

    else just run the code when you want to use the submit button


    as we do not know why you want the index of the...
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.