Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 1.13 seconds.

  1. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    Sub Insertdata()
    Dim src As Workbook
    Dim fnd As Range
    Dim d As Integer
    Dim lastrow As Integer
    Dim Rng As Range

    Set src = Workbooks.Open("c:\temp\dr\age.xlsm", True,...
  2. Replies
    4
    Views
    117

    Re: New to Word Mail Merge

    create a word mail merge document (or convert an existing document) and attaching the required merge source, then place mergefields for each of the required database fields in the appropriate...
  3. Replies
    14
    Views
    167

    Re: This Macro takes 6 hours to run!!!

    i am sure it could be made faster by avoiding working with the selection object, but instead working with full qualified ranges
  4. Replies
    4
    Views
    117

    Re: New to Word Mail Merge

    not quite sure what you are asking, i would think, generally all fields are returned, just with the records by criteria
  5. Replies
    3
    Views
    171

    Re: Link in email to reply to

    the html would be like this for an html anchor

    <a href="mailto:test@example.com?subject=Testing out mailto!&body=This is only a test!">Second Example</a>you could possibly use a variable to fill...
  6. Replies
    3
    Views
    171

    Re: Link in email to reply to

    you would need to put a mailto href link into the body html of the email you send, while you can automate to fill the recipient, subject and body, it will still require the user to click send on the...
  7. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    do you want to post a workbook (zip first) with some sample data to test against
  8. Replies
    6
    Views
    268

    Re: Cannot Register vbzip11.dll

    did you elevate to register?
  9. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    use code tags when posting code

    specify which line contains the error or is highlighted, you still needed an initial value for d
    looks like missing a " before sheet1, typo do until, closing...
  10. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    this double loop looks terribly inefficient
    try like

    with src.sheets(sheet1")
    do unitl d = lastrow
    set fnd = range("a:a").find(.cells(d, 1)
    if not fnd is nothing then fnd.offset(,1)...
  11. MsOf13 Re: How do we remake the program to copy not one value value but with range in column

    i guess initial value of d = 0
  12. Re: mimic Windows 1.0 graphical interface with VB6

    you should try the vbdirectory parameter in the dir call
  13. Replies
    6
    Views
    476

    Re: excel 2000 question

    of course they can be hard coded, i assumed that you would want to match the value of some cell as
  14. Re: how do we fill in school table age column from age table using age column with vi

    well are you doing this in excel or access tables

    how is this related to your other post that asks the same question, but in excel
    in an access database you should not need to put the data in...
  15. Replies
    6
    Views
    476

    Re: excel 2000 question

    usedrange is a property of a sheet object and would work as posted would work, but you can always choose the range to search in, but as you did not give any clues about which column ( or if they...
  16. Replies
    1
    Views
    180

    MsOf365 Re: Can you find the problem with this?

    so each time any cell in column f is changed then you want to loop through all the cells in f7:f1000?
    you have not specified what problem you are having


    only a guess as to what the problem...
  17. Replies
    6
    Views
    476

    Re: excel 2000 question

    you can use excels find method, to find cell with matching text


    Set fnd = sht.UsedRange.Find(cel)
    if not fnd is nothing then fnd.interior.color = vbredwhere sht is a worksheet object and cel is...
  18. Re: fill a combobox with a sorted files in dir c:\,ydir\

    list the files into an array using DIR to return all the files from the directory, sort the array using quicksort or bubblsort (depending on your preference), then add all the files to the combobox...
  19. Re: Cannot debug 'Subscription out of range error'

    as r is returned as a fully qualified range you can not specify it on some sheet anyway
    unless the sheet is also entered in the inputbox, range r will always be on the active sheet when the inputbox...
  20. Re: Programatically Change Number Values In A String

    if that is the only string type then you could split the string on the "-" and add the +10 to both elements of the array, but if the strings could contain other characters you would need to loop...
  21. Replies
    9
    Views
    510

    Re: Move to line

    open again
    or read all into an array
  22. Replies
    5
    Views
    376

    Re: VBA Internet Explorer Click a button

    as it is internal, ask whoever designed it to provide an API, not much anyone external can do anything to help, can't see the html code of the page or test against the site
  23. Replies
    5
    Views
    376

    Re: VBA Internet Explorer Click a button

    if you want to pm me with a link to the actual site, include username and password, i will have a look and test
    other than that, if the button is on a form, have you tried tried to submit the form?...
  24. Replies
    5
    Views
    376

    Re: VBA Internet Explorer Click a button

    what code have you tried? and what results?
  25. Replies
    2
    Views
    251

    Re: Function not running from excel

    worksheet functions do not work like that

    you would probably be better to work with the worksheet change event, like

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ...
  26. Re: EXCEL cell displays the picture by Url,but not save the bitmap to the file

    you have the option of savewithdocument set to false, only linktofile is set to true
  27. Re: Issues with VBA code for a range. I'm getting Type Mismatch Error 13

    you can not return the values of a range of multiple cells to a single result as an array would be returned, hence a type mismatch
    conversely you can assign a single value to an range of multiple...
  28. Replies
    5
    Views
    546

    Re: Multiple dynamic tables VBA

    for i = 1 to sheet2.textbox3.text
  29. Replies
    5
    Views
    546

    Re: Multiple dynamic tables VBA

    like

    For i = 1 To 3
    Set t = Sheet4.ListObjects.Add(xlSrcRange, Sheet4.Range("A2").Offset(37 * (i - 1) + 3 * i).Resize(37, 5), , xlNo)
    Nextyou might have to adjust the math a bit
  30. Replies
    5
    Views
    546

    Re: Multiple dynamic tables VBA

    i am not sure from this what you actually want to do. though i am sure it is not too difficult to achieve

    you can do a loop like

    for rw = 2 to t.listrows.count ' row 1 is the header row
    ...
  31. Replies
    15
    Views
    968

    Re: Sorting Array

    so is this now resolved, you can sort your array? or you still need help with it?


    in vba there is no built in function to sort an array you will have to use code to create your own sort function...
  32. Replies
    12
    Views
    557

    Re: [RESOLVED] Simulate Enter key pressed

    possibly it is better to put all the code into a public sub in a module then you can call it from any event or other procedure in any form or other module
  33. Re: How to code to run VB6 app without needing "run as administrator" in Win 7

    even the name of an app can cause elevation to be required, though generally this is more likely to occur with w10
  34. Re: ¨Runtime Error '401': Can't show non-modal form when modal form is displayed.”

    are you running the ide elevated and the exe as standard?
  35. Re: VB6 fail to start on Win10 20H2 - Can't find file 'DAO350.DLL'

    it would have helped if you had posted the keys, bloody hard to read in the image, but i did not find any data like that in my registry
  36. Re: how can fill browser fields direct from vb6 and sumbit

    have a look selenium, there are some other threads here that discuss it
  37. Re: VB6 fail to start on Win10 20H2 - Can't find file 'DAO350.DLL'

    the attachments did not upload correctly
  38. Replies
    5
    Views
    604

    Re: SUM data from multiple sheets VBA code

    well spotted and fixed
  39. Replies
    5
    Views
    604

    Re: SUM data from multiple sheets VBA code

    you could try like

    For rw = 5 To 23
    Worksheets("Overzicht").Range("F" & rw) = 0
    Next
    For Each ws In ActiveWorkbook.Worksheets
    If ws.Name Like "WK*" Then
    For rw = 5 To 23
    ...
  40. Re: VBA in Excel 2016 - Update graphs then copy sheets

    that is the idea, but selecting an item in the name slicer seems to be unreliable, i am sure that would also apply to the date slicer, but i have not tested with it

    i tried with multiple...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width