Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 7.10 seconds.

  1. Re: Error 1004 - Application-defined or object-defined error VBA Excel

    what about excels copyfromrecordset method?
  2. Replies
    3
    Views
    135

    Re: Print barcodes for multiple records.

    of course it can be done, depending on the desired result as to how best to set it up
    for multiple barcodes on a single form, you could use an array of pictureboxes
    or you could use the printer...
  3. Replies
    5
    Views
    140

    MsOf365 Re: Word - Fill Image in Mail Merge

    { INCLUDEPICTURE "c:\\staff\\pictures\\
    { MERGEFIELD “FirstName” }.jpg"
    \*MERGEFORMAT \d } https://onmerge.com/articleIncludePicture.html
    this site offers detailed instructions for includepicture...
  4. Replies
    5
    Views
    140

    MsOf365 Re: Word - Fill Image in Mail Merge

    do you want different images for each merge doc?
  5. Re: Excel VBA Macro to start a local video in fullscreen mode using a shortcut

    the events would only work with a wmp object as created in your original code


    it does seem strange, that the wmp object has no quit method
  6. Re: Excel VBA Macro to start a local video in fullscreen mode using a shortcut

    there are a heap of WMP events, one of which may fire when the video is finished playing

    i would try playstatechange or statuschange first
  7. MsOf07 Re: Cant copy/paste from workbook when using shortcut/hot key

    i pasted your code into a procedure and assigned a hotkey ctrl+m, the code worked as expected either using the hot key or from the ide

    did you try specifying the full path to the file?
  8. Re: Excel VBA Macro to start a local video in fullscreen mode using a shortcut

    you can try

    WMP.fullscreen = True i could not test as i did not have any media files on this computer, fullscreen only works while the player is playing

    i did not find any method to quit the...
  9. Re: Copying data from different sheet to sheet 1 on Excel

    sorry i do not understand the hierarchy of your workbooks

    if you are working with multiple workbooks you should fully qualify your objects to specify the workbook as well as the worksheet
  10. Re: Copying data from different sheet to sheet 1 on Excel

    it worked with your sample workbook, and should in most cases, but it may not be correct based on the alternative scenarios as in post #4

    then maybe

    call Copyvariation
    Call Splitbook
  11. Re: Copying data from different sheet to sheet 1 on Excel

    that was what i was suggesting
  12. Re: Copying data from different sheet to sheet 1 on Excel

    not sure that i understand what you are saying but

    maybe


    call newcode
    Call Splitbook
  13. Re: Sending folder with files, to a remote ip address machine

    your program should be able to do whatever the user can do from within explorer, if they can not create or copy a folder to the drive then your program will not be able to either

    you will need to...
  14. Re: Sending folder with files, to a remote ip address machine

    from what i understand this is just a server on a lan, with a mapped drive
    if this is the case and the user has access then it is just like working on the local machine with file i/o

    i don't see...
  15. Re: Copying data from different sheet to sheet 1 on Excel

    you need to put the entire code within a procedure (Sub), all code must be within a procedure (sub or function), only declares and variables (when required at module level) are in the general section...
  16. Replies
    11
    Views
    281

    Re: Timestamp on data change

    how do you call the function? from some other procedure or as a userdefined worksheet function

    if you are using it as a worksheet function then you can not read or write to other ranges and have...
  17. Re: Copying data from different sheet to sheet 1 on Excel

    you can test this to see if it will do as requested

    Dim sht As Long, nxtrw As Long, oset As Long
    Dim dept As Worksheet, dt As Worksheet, vrow As Range, rw As Range, fnd As Range, fndval As Range...
  18. Re: Finding a subfolder with the highest number that matches a pattern

    here is another option
    from https://www.tek-tips.com/viewthread.cfm?qid=1356727
    the link in the post seems to be dead now, but enough posted to give the idea
  19. Re: [RESOLVED] Containing bunch of checkboxes into an array - errors

    have a look at
    http://www.siddharthrout.com/index.php/2018/01/15/vba-control-arrays/
  20. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    at a guess, i would believe you should change to

    rnge = Globals.ThisAddIn.Application.selection
  21. Re: [RESOLVED] Blinking numbers on the clock-face....

    use the # button for code
  22. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    even though this might work, which sort of surprises me, it is really bad programming and may lead to all sorts of error or other problems
    any object that is not fully qualified may prevent you...
  23. Re: Blinking numbers on the clock-face....

    the flashing may be to do with the speed of the different computers
  24. Re: Programmatically Apply The Same Formula To Each Cell In A User Selected Range

    am i missing something here? if you try to use a formula to increase the value in the same cell i will give a circular reference, and if saved will overwrite the previous value in the cell with the...
  25. Re: Containing bunch of checkboxes into an array - errors

    the proper way to work with multiple controls, if you want the same event to fire for each control, is to use a class then set each control to an instance of the class and add each instance of the...
  26. Re: Change background color of an Excel cell.

    try

    xlWorkSheet.Cells(i + 2, j + 1).Interior.Color = dgv.Rows(i).Cells(j).Style.BackColor

    depending what the backcolor of the dgv returns you could also .ColorIndex
  27. Replies
    9
    Views
    438

    Re: Textbox with calculator?

    i like this idea, i have a commercial program that has this feature, though it is only a line calculator, no buttons just keyboard input, i use it all the time
    i have previously designed a calendar...
  28. Replies
    2
    Views
    261

    Re: clear the data by vba macro

    i am currently unable to open your samples, but based on your description

    p1 = "c:\temp\"
    p2 = "C:\temp\"
    Set wb1 = Workbooks.Open(p1 & "book1.xlsx")
    Set wb2 = Workbooks.Open(p2 & "book2.xlsx")...
  29. Re: Excel to HTML Text File - Formatting/Highlighting

    first go back and edit your posts to wrap all the code in code tags, so it is more readable
    highlight the code and press the # button in the toolbar

    your code can be abbreviated by creating loops...
  30. Re: Getting a compile error : stub or function not defined error in VB6

    option explicit at the top of all modules, will help to prevent those type of errors
  31. Replies
    5
    Views
    294

    Re: VLookup of date and time

    i assume that a396 contains 25.09.2020, so the returned lookup is correct closest value below the lookup time, what do you want it to find in this case?
    the values here are all text, no dates,...
  32. Re: Runtime error 424 when referring to class method

    as my is dimensioned within the form load event, it is out of scope for the timer procedure, you should dimension it at module level or globally for all modules

    you should move the Dim My As...
  33. Re: Getting a compile error : stub or function not defined error in VB6

    do you have a sub or function addlog?
    i am guessing that is the one it is not finding, test if it will run if you comment out that line
  34. Replies
    5
    Views
    294

    Re: VLookup of date and time

    this seems to work correctly, it will pick up the one before the time looked up, not one after the time, so while 2pm would be closer to 14:08, vlookup would find the 13:08, if you need to find the...
  35. Re: Looking to make this macro Faster

    depending how many rows are involved, i am sure it would be faster to to read the values into an array, do the calculation, then write the array back to the range

    or probably even faster, use an...
  36. Replies
    4
    Views
    353

    Re: [Powerpoint]Working with group shape

    i am not sure that you can do a pickup of the group, maybe only the individual shapes
  37. Replies
    2
    Views
    351

    Re: Changing Object Fill Color

    you can try like

    With Worksheets(Sheet2.Name).Shapes("Oval 52")
    .Visible = msoTrue
    .Fill.ForeColor.RGB = RGB(112, 48, 160)
    .Shadow.Transparency = 0
    End With
  38. Replies
    21
    Views
    596

    Re: OUT of memory in VB&

    why use a text file at all? seems like a database would be more appropriate
  39. Replies
    5
    Views
    380

    Re: Moderators please delete

    why delete? just mark resolved, it may help someone searching the same problem
  40. Re: [RESOLVED] Error 35600 ListView Index Problem

    yes i picked that in post #2
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width