Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.23 seconds.

  1. Replies
    1
    Views
    62

    Re: Help with two *.txt files.

    if you are doing this in 2010, it would appear to be a known problem in specificationname see
    support.microsoft.com/kb/2581495

    have you already created the specificationname in access?
  2. Re: Application-defined or object-defined error

    @ bryce
    this is the workbook sheetchange event, check thisworkbook code pane
    cover all sheets in a workbook

    i would assume that in all cases that the activesheet would be returned in SH...
  3. MsOf10 Re: Obtaining Name or index of selected CustomDocumentProperty

    what field types are you using for your document properties?
    unless you are using some numeric name for your customdocumentproperties, the above will not work, assuming your field indexes are in...
  4. Re: Foreign Language issues with commandbars in Excel

    i would assume that if you want to disable copy item on menu, you would probably also want to disable the standard toolbar button as well

    i only have excel 2000 on my computer, excel 2013 on a...
  5. Re: Foreign Language issues with commandbars in Excel

    i tested on 2013, index of in-built menus is 37, i found there to be 3 edit menus within the built-in menus
    test code worked correctly, but i am unsure if any menus are used (displayed) in this...
  6. Replies
    5
    Views
    161

    Re: run time error 1004 - see script below:

    this is not a valid file name, file names can not contain wildcard characters, if you want to work with all files in a folder named
    G:\Finance, Performance & Business Planning\Management...
  7. Replies
    2
    Views
    113

    Re: with Application.FileSearch

    you can use filesystemobject
    if you search application.filesearch alternative you should find several alternatives with code
  8. Re: Foreign Language issues with commandbars in Excel

    your workbook opens OK for me, but i can not test the included result, i will look, later, if i have a newer version of excel on any machine,

    the value of 90 i used earlier was the index of the...
  9. Replies
    2
    Views
    108

    Re: delete browser cache from code

    check out
    DeleteUrlCacheEntry API
  10. Re: Foreign Language issues with commandbars in Excel

    i tested initially using

    For Each cbBar In Application.CommandBars
    Debug.Print cbBar.Name, cbBar.Index
    Nextwhich gave me the index value of 90 for Built-in Menus
    this obviously...
  11. Replies
    4
    Views
    156

    Re: Error on Creating Excel File

    what is the content of m_var when the code runs?
  12. Re: Automatically send multiple emails with attachments

    what code are you using now to send the emails?
    in outlook, each attachment has to be added to the email
  13. Re: Foreign Language issues with commandbars in Excel

    check if the index of 90 is correct for the built-in menus for your version of excel
    msgbox zb.name

    it worked correctly when i tested

    do the names of controls change in different language...
  14. Re: Run Time error 13 type mismatch

    what is the typename of myitems(itemcount) when the error occurs?
    perhaps some other type has arrived in your folder that does not match any of the existing criteria, better to change to

    if not...
  15. Re: Where are Excel VBE icons stored

    try
    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
    or whatever updated install path
  16. Re: Private WithEvents WAP As Word.Application

    have you tried running the program elevated?
    runAs administrator

    or try creating an new object withevents, rather than from one that is created without events
  17. Re: Foreign Language issues with commandbars in Excel

    you can try liike


    Set zb = Application.CommandBars(90)
    Set xb = zb.FindControl(, 30003)
    For Each yb In xb.Controls
    If yb.ID = 19 Then yb.Enabled = True
    ...
  18. Re: VBA code which copy data from a web page in excel

    i will look later, if you send the login
  19. Replies
    8
    Views
    221

    Re: Pass Excel Macro output to Javascript

    of course it would be possible to output the result to javascript
    write the result out as part of an html page and display in browser,
    just does not make any sense to do so, unless it is to apply...
  20. 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...
  21. Replies
    8
    Views
    221

    Re: Pass Excel Macro output to Javascript

    why do you need a javascript messagebox?
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
    ...
  27. 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...
  28. 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
  29. 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...
  30. 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...
  31. 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?
  32. Re: Tweak VBA to Move SharePoint Files to a Folder in Same Location

    at which point in the code?
  33. Replies
    1
    Views
    139

    Re: Detecting platform/OS in Excel VBA

    www.rondebruin.nl/mac/mac001.htm
  34. 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
  35. 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...
  36. Replies
    2
    Views
    108

    Re: VBA copy sheet and save as

    try like
    Filename:="S:mypath\" & format(date, "mmddyy") & ".pri"
  37. 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 &...
  38. 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...
  39. 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...
  40. Replies
    11
    Views
    267

    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
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.