Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.24 seconds.

  1. Re: Run time error 94 "Invalid use of Null"

    you could either test for null value using isnull
    or easier add a vbnullstring to the return like

    strPA = objPA.GetProperty("http://schemas.microsoft.com/mapi/proptag/0x10910040") & vbnullstring...
  2. Replies
    6
    Views
    130

    Re: Pass Excel Macro output to Javascript

    why do you need a javascript messagebox?
  3. Re: I need help creating a macro to format a .rtf in Word

    it works for me, when testing, it may depend what is contained in the paragraph
  4. Re: I need help creating a macro to format a .rtf in Word

    try like

    for each p in activedocument.paragraphs
    if left(p.range.text, 1) = "Q" then
    p.range.font.bold = true
    else
    p.leftindent = 5
    end if
    nexti did not test this
  5. MsOf10 Re: [RESOLVED] Data Validation should be added when the user enter a value in a range

    another select case would be better than all the or ifs
  6. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    the sample i posted in #4 should work like that anyway
  7. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    try like

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Cell As Range
    If Target.Column = 1 Then
    Set Cell = Target.Offset(0, 1)
    If Len(Target.Value) = 0 Then
    ...
  8. Re: Private WithEvents WAP As Word.Application

    is that the full procedure?
    or is wordobject defined globally?

    was there any other versions of word previously installed on the windows7 box?

    remove on error resume next to see any error...
  9. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    how many names in the real list?
    for the number in the example a select case would work ok, but if a big list maybe some worksheet function
  10. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    forgot, i stuck cells.select in your posted code

    If Target.Value <> " " Then
    With Cell.Validation
    .Delete
    .Add...
  11. MsOf10 Re: Data Validation should be added when the user enter a value in a range of cells

    what is happening now? what specific problems are you having?

    apart from not in red this is very close to the current operation, for all values in column A, easy enough to put a select case to...
  12. Re: Private WithEvents WAP As Word.Application

    not enough information (code)
    what is wordobject?
    is it dimensioned globally?
    how is it initialised?
    what references are you using to word application?
  13. Re: Tweak VBA to Move SharePoint Files to a Folder in Same Location

    at which point in the code?
  14. Replies
    1
    Views
    127

    Re: Detecting platform/OS in Excel VBA

    www.rondebruin.nl/mac/mac001.htm
  15. Re: list subfolders and files of main folder with details

    sorry, missed that you were writing .csv file (assumed .txt)

    your original code should have put the details into separate columns when opened in excel
    works correctly when i test
  16. Re: list subfolders and files of main folder with details

    you could try separating the file details with a tab like
    ObjOutFile.WriteLine("File," & vbtab & ObjFile.Name & "," & vbtab & ObjFile.Path) , but if you want properly aligned columns that would be...
  17. Replies
    2
    Views
    100

    Re: VBA copy sheet and save as

    try like
    Filename:="S:mypath\" & format(date, "mmddyy") & ".pri"
  18. Re: web page copy - get value from first and second page

    try adding like

    Do
    Set abi = ie.document.getelementbyid("risultato").all("iban")
    Loop While abi Is Nothing
    'add here
    Set t = ie.document.all("table3")
    MsgBox abi.Value & vbNewLine &...
  19. Re: I have a software that download proxy's from internet. Can I automate It ?

    i guess you want to fill an online form and save the returned data, i am sure this is quite possible to do

    BUT
    google usually has AUP, which may not allow such, or at least discourage automating...
  20. Re: web page copy - get value from first and second page

    i would have though you could have managed that part by now

    Set ie = CreateObject("InternetExplorer.Application")
    ie.navigate "http://www.mutuissimo.it/iban-x.asp"
    do until ie.readyState = 4...
  21. Replies
    11
    Views
    242

    Re: Pasting a Named Range

    try removing the +1 from the offset, do you have the code posted within the for loop you posted originally?

    correct, as suggested above, post a sample workbook, zip first
  22. Re: web page copy - get value from first and second page

    after logging in try

    Set abi = ie.document.getelementbyid("risultato").all("iban")
    MsgBox abi.Value
  23. MsOf07 Re: Find "method" can't find date between 01.12.1990(dd.mm.yyyy) and 09.12.1990.

    something to try
    IntervalB = Range("J4").Value2
    do not convert to string after, comment out the IntervalB = Format(IntervalB, "mm\/dd\/yyyy")
  24. MsOf07 Re: [Excel] Deallocating Arrays Necessary?

    most times not necessary, but if you are having any issues, then it would not hurt to do so

    or for dynamic arrays just redim
  25. Re: How to connect multiple computers in a network?

    my guess is shared data on existing network, but who would know?
  26. Replies
    11
    Views
    242

    Re: Pasting a Named Range

    try like

    If Left(ws.Range("b" & j).Value, 2) = "DR" Then
    range("internal").copy ws.Range("b" & j).offset(1)
    range("above").copy ws.range("b" & j).offset(- (range("above").rows.count + 1))
    End...
  27. Re: [RESOLVED] Question on why my function is working this way

    if it is related add here, else mark this resolved and start new
  28. Re: Question on why my function is working this way

    only the last is integer, the rest are default, the type has to be specified for each individually
  29. Re: Linking to file directory based on data within a record

    in what application?

    what database server are you wanting to query?
    sqlserver, access, mysql, other?

    search on connectionsstrings.com for connection to your specific database

    use...
  30. Re: Question on why my function is working this way

    probably type mismatch error?


    compliantsites is probably not dimensioned as integer in the calling procedure and defaulted to variant

    a function should return some value (even success or...
  31. Re: Determining if worksheet is a specific name

    i see no point to having the label and goto statements, as next would be the next processed statement anyway
  32. Re: Looping through a Directory and changing the Excel file names based on the cell v

    you have no \ between path and filename, should be

    Filename = Dir(Pathname & "\*.xls")
    Do While Filename <> ""
    Set wb = Workbooks.Open(Pathname & "\" & Filename)or add \ to...
  33. Replies
    10
    Views
    256

    Re: Code cant run (Noob)

    pcs running at this level do not receive ctrl break during loops in excel
    put doevents in your loop to ensure ctrl break is received, to allow the code to break, without closing excel
  34. Re: Problem comparing two strings

    yes

    probably some other character in one of the strings, therefore not =
    chr(10) is a LF, is a non-printable character and does not show in most cases, but character after should appear on a new...
  35. MsOf10 Re: Macro Issue- Run-Time Error 5941- The requested member of Data Collection

    as a test, try putting the multiple tabs into a string then typetext the string
    something like

    mystr = String(10, vbTab)
    Selection.TypeText mystrchange to however many tabs you want
  36. Re: select a option of a html/java web using vba excel

    Set fdoc = ie.document.frames(2).document
    For Each ele In fdoc.all("Anno").getElementsByTagName("option")
    If ele.Value = "2010" Then ele.Selected = True: Exit For
    Next tested, working
  37. Replies
    10
    Views
    219

    Re: How to activate a hyperlink using VBA

    as there is no hyperlink in the cell, you would need to parse the url from the formula and then activate it based on the type of url

    url = Split(Range("c6").Formula, """")(1)
    will return the...
  38. Replies
    10
    Views
    219

    Re: How to activate a hyperlink using VBA

    where is the vba box?
    what type of box are you referring to?
  39. Replies
    10
    Views
    219

    Re: How to activate a hyperlink using VBA

    zip first

    i really can not see any detail from your image


    i am not sure i understand exactly what you want to do
    i guess you should use shellexecute API or some other method and pass the...
  40. Re: [RESOLVED] Excel ignores On Error GO TO / Resume next

    surely it would be better to test if the file exists, rather than rely on error handling


    if len(dir(fullpath\filename)) > 0 then
    open file
    else
    msgbox "no file for " &...
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.