Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.28 seconds; generated 35 minute(s) ago.

  1. Replies
    1
    Views
    61

    Re: Color insertions and accept deletions

    is this now happening on all documents, or just one?
    on what line does the error occur?

    as far as i can see the only object within either procedure is activedocument
    and it says not available,...
  2. Replies
    7
    Views
    118

    Re: Detecting mouse click within a sub

    you could loop until lastx and lasty have some new value
    something like


    Private Sub TakeGoldPicture_Click()
    ActionFlag = 3
    Snap
    Showsnap 960
    ActionFlag = 4
    Showsnap 960
  3. Replies
    7
    Views
    136

    Re: VBA to open file from HTTPS location

    can you use ftp?
  4. MsOf07 Re: What is making the difference between how these 2 examples work?

    why do you need to use directcast? when you can just use = new excel.application
  5. Re: Excel / VBA - Apply Cell Borders

    make a little user form with the available options for the user to select by option buttons, checkboxes or whatever

    or show the borders dialog and let them select there
  6. Re: Userform initialize (sometimes works, sometimes don't!)

    try forcing the position of the userform to the second monitor, by setting the top or left as appriate
  7. Replies
    7
    Views
    136

    Re: VBA to open file from HTTPS location

    i tested your code to download a docx worked fine, document opened OK

    can you post a sample docx to test with, not sure what other problem can be occurring, could the file be encrypted?
  8. Replies
    7
    Views
    136

    Re: VBA to open file from HTTPS location

    try using urldownloadtofile api instead of the above
    there are many examples in this and the vb6 forums
  9. Replies
    7
    Views
    136

    Re: VBA to open file from HTTPS location

    if you do not open the fie and put filedata is the downloaded file still corrupt?

    you can not really just write data to a word document, as a text file, you should be using Word automation, to do...
  10. Re: Autodesk Inventor 64 bit VBA 7 and Windows 10 Crash on Declare.

    try it and see


    set objsh = createobject("shell.application")
    set objbrowse = objsh.BrowseForFolder _
    (WINDOW_HANDLE, "Choose the folder you want cleaned:", NO_OPTIONS, "C:\Scripts") ...
  11. Re: Formula on filtered data@ in adjsuet column

    ? zip first
  12. Re: Autodesk Inventor 64 bit VBA 7 and Windows 10 Crash on Declare.

    you should be able to use a shell object
  13. Replies
    1
    Views
    82

    Re: Need Help with Code

    i am sure there would be, you should be able to loop through the workbooks using the current month name to connect to the correct tab then link to the data in the worksheet
  14. Re: Which is best function to use to search for char string?

    you could use instr and mid to check character is_, something like

    if instr(cel, "4090") = 1 and mid(cel, 5 , 1) = "_" thenwhere cel represents any cell value or other string
    should only find...
  15. Re: How to view a Word DOCX document in any kind of Apple or even PC web browser...

    internet explorer should just be able to navigate to a word document, firefox and chrome have extensions available, but the user would need to install, i know nothing about apples, but presume that...
  16. MsOf07 Re: What is making the difference between how these 2 examples work?

    look at the differences between the imports as i suggested and those as posted by bryce

    with the method in post #16, where the imports is assigned to an aliasname, in that example,Excel (can be...
  17. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    is this on the same computer or some other?
    can you run the other VBA code on the same computer?
    can you run this code from some other computer?
    have you tried specifying cursor type to the...
  18. Re: Copy data from one workbook and paste in current worksheet

    someone asked the same couple of days ago and posted his solution...
  19. MsOf07 Re: What is making the difference between how these 2 examples work?

    start a new project, with a button, just to test
    add a reference to excel and bryces or my sample code

    personally i prefer late binding, which requires no references and all variables are just...
  20. MsOf10 Re: [Excel] VBA for summing up one column based on the unique value in another column

    counts if the current cell value is in the cells above the current cell to see if that value has already been summed, to avoid duplicating the values into the new column
  21. MsOf07 Re: What is making the difference between how these 2 examples work?

    yes


    from what i see (note i have not used vb.net previously), you should replace the namespace import with an assignment of the excel namespace, as suggested before, you can then use the Excel...
  22. MsOf10 Re: [Excel] VBA for summing up one column based on the unique value in another column

    it is pretty easy to loop through all the cells in column A to get a running total, but easier to use excel built in formulas (sumif and countif) even in code to get the results

    here is an example...
  23. MsOf07 Re: What is making the difference between how these 2 examples work?

    Imports Excel = Microsoft.Office.Interop.Excel

    Public Class Form1if this is not at the top of the code then you would have all the problems mentioned, confirmed by testing
  24. MsOf07 Re: What is making the difference between how these 2 examples work?

    this should add a new workbook to the workbooks collection, if you want to use an existing workbook you should use the workbooks.open method
    and of course as pointed out by Bryce, you can not assign...
  25. Re: How to create & populate table from XML code?

    that should be quiet easy
    try like


    Dim rws(2) As Integer
    rws(0) = 5 ' first row
    tags = Array("left_location", "right_location", "left_content", "right_content")
    f = FreeFile
    Open...
  26. Replies
    5
    Views
    271

    Re: Exporting Access to Excel

    try ike

    DoCmd.TransferSpreadsheet acExport, 8, "MSActionQuery", "c:\somepath\StockList.xls", True
  27. Replies
    5
    Views
    271

    Re: Exporting Access to Excel

    you should provide the full path to the excel file
    i am not sure if .xlt are supported, try .xls file
    i believe, you should omit the range parameter, not use an empty string
    trailing omitted...
  28. MsOf07 Re: What is making the difference between how these 2 examples work?

    while you are dimensioning the variable here are you assigning it a value (object) some place?
  29. MsOf07 Re: What is making the difference between how these 2 examples work?

    unless you wish to show a specific range to the user, you should avoid selecting anyway
    always work with fully qualified ranges, rather than the selection object
    try to avoid references to active...
  30. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    anywhere after you create it


    but if you are still getting the error with the simplest sql there must be some problem with your connection, even though it is open

    the simplest sql string is...
  31. Re: RESOLVED: [VBA Word/Excel] Error 462 when running the code twice

    on which line does the error occur?

    this line should be

    Set WordDoc = .Documents("TestDoc")and assumes that the specific document is already open

    i do not see any other reason why the code...
  32. Replies
    18
    Views
    2,487

    Re: excel userform combobox dropdown position

    actually the verb would be dimension, which dim is an abbreviation of

    i have never been able to resolve the original problem, as it happens with many other programs too, including outlook express...
  33. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    NO, the first tells the connection is open, which we already believed, else you would have some other error, maybe object required, when trying to open the recordset
    the second tells that the...
  34. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    cn.Open strcn
    cn.CommandTimeout = 600
    msgbox cn.state 1 = open, 0 = closed
    rs.Open strSql, cn
    if rs.state = adstateclosed then msgbox "recordset failed to open"




    if...
  35. Re: MS Access 2016 Runtime error #-2147023170

    try doevents between closing the file and opening

    why do you need to close the file then reopen anyway?
    saveAs will leave the saved file as the activefile anyway, your code appears to just leave...
  36. Replies
    10
    Views
    214

    Re: hresult 0x800a01b6 on seccond pass

    which line gives the error?

    this forum is for vb6, .net has its own forum, i will request this thread moved
  37. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    what database are you working with?
  38. Replies
    26
    Views
    485

    Re: 100% processor usage

    i am not sure what the timer is actually supposed to do, as the first time, it fires it turns off, but does nothing else
  39. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    because it is failing to opening a valid recordset
  40. Re: Run-time error '3704' - Operation is not allowed when the object is closed

    the error is specific, rs.Open strSql, cn has to be failing to open a recordset, though i would have expected an error to occur
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.