Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.25 seconds.

  1. Replies
    12
    Views
    150

    MsOf10 Re: INSERT INTO without field names

    to build a string of field names, you can try like

    sql = "select * from tbl_Import"
    rs.Open sql, cn, adOpenStatic, adLockReadOnly
    For f = 0 To rs.Fields.Count - 1
    fldlst = fldlst &...
  2. Replies
    12
    Views
    150

    MsOf10 Re: INSERT INTO without field names

    use code to build your sql string from the column names in the table
  3. Replies
    12
    Views
    150

    MsOf10 Re: INSERT INTO without field names

    i found this
  4. Re: Problem with call external software

    appactivate should work with any windowed application
  5. Re: Problem with call external software

    try
    appactivate windowtitleofb.exe
  6. Re: Instantiating MSForms.DataObject or other libraries twice by calling function

    as objects are dimensioned locally (within the procedure) they are completely separate
    you should be able to, but you have not posted an example of where it is failing
  7. Re: Neat way to send multiple strings through function

    sendkeys will accept multiple keys in a single string

    from help
  8. MsOf10 Re: [Word2010] How to detect embedded Notepad (.txt, .csv, etc.) files via inlineshap

    to incorporate it into the existing code posted above, which i assume is within a for eachloop, try like

    If (InStr(myshape.OLEFormat.ClassType, "Excel") > 0) Then
    myshape.OLEFormat.DoVerb...
  9. Re: Userform calls other userform, then populate worksheet

    there is no userforms in the workbook and very little code
    the forms displayed when clicking a team are sheet dataforms, which appear to be another way of displaying a sheet and entering data,,...
  10. MsOf10 Re: [Word2010] How to detect embedded Notepad (.txt, .csv, etc.) files via inlineshap

    testing your sample document i could just activate the inlineshape


    doc.InlineShapes(1).Activate
  11. Re: Userform calls other userform, then populate worksheet

    if you post what you have i am sure someone will try to assist in making them work together
  12. MsOf07 Re: How to copy specific words from MS Word into Excel 2007 Cells

    no, this extracts the required texts from the word document
    it needs additional code to put into excel

    but as stated in other posts, members in this forum will help you with your code and fix or...
  13. Re: Userform calls other userform, then populate worksheet

    you should show the code you have tried, we will help you fix what does not work, but this is not a free coding service, you should at least attempt what you want to achieve
  14. MsOf10 Re: [Word2010] How to detect embedded Notepad (.txt, .csv, etc.) files via inlineshap

    as far as i can tell text files inserted are not embedded objects and not contained in shapes, post a sample document for inspection
  15. Replies
    3
    Views
    139

    Re: Develop a macro to solve below problem

    try removing on error resume next, so that all errors break the code, then you can find where errors are occuring, also make sure that any error handling will tell you which line caused the error to...
  16. Re: database copy issue from master workbook to current workbook

    be aware that both i and r1 are dimensioned as variant

    if at any point a non match is found then no further cells will match, unless you decrease i by 1 , incrementing j will cause a row to be...
  17. Replies
    8
    Views
    152

    Re: How to make unchangeable checkbox?

    checkbox controls have a locked property, this will prevent the user from clicking, the value can still be changed by code
  18. Replies
    13
    Views
    568

    MsOf10 Re: File Not Found Error Message

    i doubt it, but you could add code to check that the autoopen code still exists in the file before saving, and check that the file path is valid after saving and /or closing

    you could also try...
  19. Replies
    7
    Views
    205

    Re: Comparing field names of two tables

    from an existing recordset, i am sure it can work with a table too,
    note if field names contain spaces, some special handling would be required, also some differences working with excel sheets as...
  20. Replies
    7
    Views
    205

    Re: Comparing field names of two tables

    you can build query in code, based on the fields in your existing recordset


    for each f in rst.fields
    lst = lst & f.name & ","
    next
    sql = "select " & lst & " from [sheetname$]may need...
  21. Re: database copy issue from master workbook to current workbook

    please explain, error? wrong result? other?
    the code as posted, still required you to set the workbook object etc, as in your original code

    if you had posted a sample i would have tested against...
  22. Replies
    9
    Views
    270

    Re: Code to copy from Notepad to Excel

    in fact csv files do not generally contain semi colons, csv being
    comma separated values

    it you want the semi colons to show, how do you want the file to be positioned into cells
    all in a single...
  23. Replies
    1
    Views
    110

    Re: Dynamically create named Ranges

    afaik you are adding the name correctly, but you are doing it within the loop of column A, so the named range would always end up being a single cell, the last cell, in column M

    you need to add...
  24. Thread: Outlook Help

    by westconn1
    Replies
    1
    Views
    137

    Re: Outlook Help

    i may not be correct, but it would appear your code should be in the top procedure (myRuleMacro), where item is the email passed to the procedure from the rule

    as my version of outlook does not...
  25. MsOf07 Re: How to copy specific words from MS Word into Excel 2007 Cells

    this code is tested to work with your test document, to extract the 3 fields you want, you can then put the 3 fields into a worksheet

    Set doc = ThisDocument
    For Each t In doc.Tables
    For r =...
  26. Replies
    5
    Views
    227

    Re: Visual Basic in Microsoft Word

    probably need to start again with your own code, as you only have part of the code from somebody else

    or at least describe what you are actually trying to do
  27. MsOf07 Re: How to copy specific words from MS Word into Excel 2007 Cells

    post a word document in correct format with some sample data
  28. Replies
    5
    Views
    227

    Re: Visual Basic in Microsoft Word

    as it would appear to be some sort of object, try as a variant, which will work with anything

    though from the code it looks like IncreasePercent could actually be a textbox or similar, so not a...
  29. Re: database copy issue from master workbook to current workbook

    you can try like

    Set sht = ThisWorkbook.Sheets("sheet1")
    Set src = wkbA.Sheets("sheet1")
    nxt = sht.Cells(sht.Rows.Count, 1).End(xlUp).Row + 1
    For Each cel In src.Range("a:a")
    If IsEmpty(cel)...
  30. Re: database copy issue from master workbook to current workbook

    it is really hard to see those images

    you code can not work, as after the first inserted row, none of the other data can match
    if the rows stayed in the same order, but could have differences to...
  31. Re: database copy issue from master workbook to current workbook

    can you post a workbook with sample data and sheet with desired result?
  32. Replies
    3
    Views
    205

    Re: Using VBA to Sum rows

    you can also use a worksheetformula (sumif) in VBA

    or you can use ADO to read the worksheet as a database, using SQL query to put results into recordsets
  33. Re: database copy issue from master workbook to current workbook

    remove the exit for from the loop
  34. Re: vba help for adding updated data from one workbook to another

    probably better to find erow once, then add +1 each time data is written

    i do not believe the problem is in the code pasted here, you would need to post more, as in your other thread
  35. Re: database copy issue from master workbook to current workbook

    after a first non-match of data, the procedure does not look for any further differences??
  36. MsOf13 Re: [Microsoft Word 2013 & vb Script] vbscript to Open Files and Run Macro in Word 2

    the files you see there, startin with ~ are the files created by word, whenever word opens a file, to eliminate these, try like

    For Each FIL in FLD.Files
    if not left(fil.name,1) + "~" then...
  37. Replies
    13
    Views
    568

    MsOf10 Re: File Not Found Error Message

    if you make the file with the code read only, does it help the code not to disappear?
  38. MsOf13 Re: [Microsoft Word 2013 & vb Script] vbscript to Open Files and Run Macro in Word 2

    have you tried closing each document after processing?

    Call AutoPDF
    ActiveDocument.close
    End Sub
  39. Re: Changing Default Folder in Excel VBA for Application.GetOpenFilename

    thread tools above 1st post
  40. Re: Interop Excel querytables.add visual studio

    is rs1 a valid recordset a that point?
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.