dcsimg

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.62 seconds.

  1. Replies
    6
    Views
    223

    Re: my results not written into text files

    what folder are you saving to?, it looks like the same as the file that works ok

    i do not see any reason why a file would not be saved, even if it was empty, i can not tell from the code if any...
  2. Re: [EXCEL] Using EXCEL to Control Another Application - Can't Select Listbox Item

    mouse up or down?
  3. Replies
    6
    Views
    223

    Re: my results not written into text files

    what is the value contained in the variable sMeanValueBatch after this line?

    what folder are you trying to write to, if it is a protected folder requiring admin rights the file might be being...
  4. MsOf10 Re: [EXCEL] VBA OPC Communications - Error 429 in Excel 2010, Runs in 2016

    i would have thought that a 429 error would be more likely on the line above, where you are creating the object
    you should look at the object in the locals window after you have set myserver

    the...
  5. Re: [EXCEL] Using EXCEL to Control Another Application - Can't Select Listbox Item

    did you try sending a click?
  6. Replies
    6
    Views
    223

    Re: my results not written into text files

    yes show the code for writing to file
  7. Re: VBA CountIFs - What am I doing wrong

    looks like you need to try like

    If Application.WorksheetFunction.CountIfs(rngSet, ">=1", rngsest, "<=9") > 2 Then...
  8. Re: Need help reading a While Loop and reading from a file, then displaying what was

    this is really in the wrong forum as you are using scripting not vb6

    i wouldn't do it like this at all, but i guess you have instructions to it this way
    it seems silly to skip (not to read) the...
  9. Re: Abount ComboBox droplist problem

    if you click the combobox item you could use command1.value = true, no need to click at all
  10. Replies
    1
    Views
    94

    Re: Word Task Automation

    how does the result of the code compare to what you want to achieve?

    do you want the code to fill the fields?


    Dim activeDoc, filesharrepath as string
    filesharepath = "...
  11. Replies
    6
    Views
    289

    Re: VBA 7.1 Overflow Error

    i pasted your code into a new module, using your inputs, it ran without error, w10 64bit, excel 2013 32bit, so maybe it is a mac thing, i can not test
  12. Replies
    3
    Views
    193

    Re: Treeview FTP API VB5 Folders Files

    i did an example like this, though it only used a standard treeview control, populating a from either ftp server or local drive, the code to populate it should be much the same...
  13. Re: How do I send a simple notification email in VB6 via SMTP gmail server?

    there seemed to be some changes to using cdo in later updates of W10 (more security), here is a recent thread, basically what i am using on a daily basis, but not through gmail servers...
  14. Re: How do I send a simple notification email in VB6 via SMTP gmail server?

    what method do you want to use to send emails?
    personally i use cdo.message, for which there are several examples in this forum
    some people do not want to lower their security for this but as you...
  15. Re: Automation Error -2147417848 The object invoked has disconnected from its clients

    try putting some delay, maybe it does not load fast enough in the exe, even just a messagebox for testing, before the line that errors
  16. Re: Can't get this code to work with Outlook 2019

    did you have any success with this?
    if you get any solution, please post here to help others (and me, though it is unlikely i will be upgrading office anytime in the forseeable future)
  17. Replies
    2
    Views
    180

    Re: VBA PowerPoint TextBox Validation

    as the keydown will fire for each time a key is pressed it will always error for the first 3 keydowns even if they are a partial match

    if the enter key causes the focus to leave the textbox you...
  18. Replies
    12
    Views
    411

    Re: Custom VBA Matrix Operations

    just out of interest, i tested your code exactly as posted #8
    apart from taking a while, the only error was overflow on row, so changed to long, no other errors or changes, ran through to completion...
  19. Replies
    7
    Views
    631

    Re: Updating Windows and Excel

    i doubt you can update from office 2010 to office365, without signing into microsoft and paying subscription
  20. Re: Can't get this code to work with Outlook 2019

    if it is 64 bit office that could happen

    you can test running access elevated (run as admin)
    OR try adding a reference to outlook and

    set objol = new outlook.application

    as i don't have...
  21. Replies
    13
    Views
    470

    Re: random text file one month summary

    does this do what you want?


    Private Sub Combo1_Click()

    On Error GoTo plo

    Call BuscarItems(Combo1.ListIndex + 1)
    Exit Sub
    plo:
  22. Re: Automation Error -2147417848 The object invoked has disconnected from its clients

    it is difficult to test by remote for differences between running an exe against running in the IDE, the main differences can be file locations and registry entries, either of which may have been...
  23. Re: Can't get this code to work with Outlook 2019

    which line is high lighted?
  24. Replies
    13
    Views
    470

    Re: random text file one month summary

    i ran your project, there nothing in the listbox when the form loads, so selecting anything in the combobox just returns a messagebox ( MsgBox "El Mes " & Combo1.Text & " no existe.")

    so far i...
  25. Re: Automation Error -2147417848 The object invoked has disconnected from its clients

    can you test if vm_htlm contains the same in the exe as in the IDE?
  26. Replies
    15
    Views
    626

    Re: How to Put Index(match(index)) Into VBA

    2 choices to try

    cell.Offset(0, 1).reszie(3).Formula = "=INDEX($B$2:$B$100,MATCH(E45,$A$2:$A$200,0),1)*I45"

    ' OR

    cell.Offset(0, 1).Formula =...
  27. Replies
    15
    Views
    626

    Re: How to Put Index(match(index)) Into VBA

    i had already fixed this, when testing, but not updated the post
    ok, will fix
    same issue as above, also already fixed
    this is cased by the above problem, so is also fixed already

    test this...
  28. Replies
    15
    Views
    626

    Re: How to Put Index(match(index)) Into VBA

    this will occur if there is not a sheet named to match the value in column A

    i had been testing with empty cells and values > 0, so that explains why it did not work for you

    this should have...
  29. Re: Automation Error -2147417848 The object invoked has disconnected from its clients

    for testing, try running the exe elevated
  30. Replies
    13
    Views
    470

    Re: random text file one month summary

    of course you always open the same fille , the code specifies to open ruta, which is assigned a hard coded filename
    maybe you should be opening strfetcha, but i guess you would need to prepend the...
  31. Re: Run-Time error -2147217913 Data type mismatch in criteria expression

    you can not rely on recordsets from excel worksheet being the data type you expect

    if you just create a recordset "select * from worksheetname" for testing, you can look in the locals window to...
  32. Replies
    15
    Views
    626

    Re: How to Put Index(match(index)) Into VBA

    yours is quite correct, i got it right a couple of lines later with fnd

    as i thought i had it wrong originally i changed to find zero values, for non zero values it should be

    set fnd =...
  33. Replies
    13
    Views
    470

    Re: random text file one month summary

    according to the code, no matter what you click in the combo, it will always open App.Path & "\database.txt"

    as there appear to be several files for each month, and as is suggested by the code,...
  34. Replies
    15
    Views
    626

    Re: How to Put Index(match(index)) Into VBA

    i did test, with correct result, before posting, though i was possibly testing for first row with value in B, rather than empty, which was what the formula appeared to be doing

    you could use union...
  35. Replies
    10
    Views
    249

    Re: Cheque Leaf Printing problem

    use code tags when posting code, makes it much easier to read

    the user should be able to edit the database to adjust the print positions, there is always some trial and error with different...
  36. Replies
    10
    Views
    249

    Re: cheque printing software

    if they are single page cheque, then you do not need to height or width, just print positions and send .newpage or .enddoc to printer
  37. Replies
    9
    Views
    397

    Re: Rename Folder

    at least you have something to help diagnose
    do you run your IDE elevated?
    check if your virus scanner can be blocking it

    these problems seem to be more prevalent in later versions of windows,...
  38. Replies
    9
    Views
    397

    Re: Rename Folder

    right click, run as admin

    you have to determine the difference from the IDE to run exe as normal user

    from memory command returns the filepath enclosed in quotes, so you may need to strip the...
  39. Replies
    9
    Views
    397

    Re: Rename Folder

    try running the compiled elevated

    you can send a message, using broadcast, for all windows to update
  40. Re: Error Importing Data from Excel

    for testing, you could try closing the database and reopening, no idea if it will help, or run some simple select or count query in between updates
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width