Search:

Type: Posts; User: Domenic; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.77 seconds.

  1. Re: Macro to pull members from distribution list.

    The following macro will first create a new worksheet, and then list the details of the specified distribution list in the newly created worksheet. Change the name of the distribution list...
  2. Replies
    8
    Views
    95

    Re: Worksheet Loop searching for yellow

    Try...


    Option Explicit

    Sub CopyRows()


    Dim destinationWorksheet As Worksheet
    Dim currentWorksheet As Worksheet
  3. Replies
    8
    Views
    172

    Re: Help with index match formula

    It looks like the source data contains dates specified as the first of the month. If so, your lookup value needs to be a date that represents the first day of the specified month. However, if the...
  4. Replies
    8
    Views
    95

    Re: Worksheet Loop searching for yellow

    To check whether a cell contains "XYZ", try...


    If InStr(1, currentCell.Value, "XYZ", vbTextCompare) > 0 Then


    To check whether a cell contains "XYZ" and is highlighted in yellow, try...
  5. Re: Create .csv file from a workbook sheet with new filename and timestamp

    As I mentioned, you should be using the Mac equivalent of the Dir function. Unfortunately, I don't use the Mac, so I can't be of any help to you. So, basically, you need to ensure that you're...
  6. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    I think your solution is much better. It would eliminate the need to store the images within the file itself, which would reduce the size of the file. And, it would eliminate the need to create a...
  7. Replies
    10
    Views
    185

    Re: How to click hyperlink on webpage

    Sorry, I don't see off hand why you're getting an error. Maybe John (or someone else) might be able to pinpoint the problem.
  8. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    It would suggest that the file specified by temporaryFile does not exist. Other than calling ReplaceRectangleImage from another procedure, did you change the code at all?
  9. Re: Create .csv file from a workbook sheet with new filename and timestamp

    Also, you said that you wanted to add a time stamp as well, so maybe something like this...


    MyFileName = "GROWBOTSSS" & Format(Now, "ddmmyy hh-mm-ss")
  10. Re: Create .csv file from a workbook sheet with new filename and timestamp

    Sorry, I re-read your post and see now that you're dealing with a Mac version of Excel. Also, we should have been checking for a valid path, not a valid path and filename. Sorry, my mistake. It...
  11. Re: Create .csv file from a workbook sheet with new filename and timestamp

    First, since your path doesn't specify a drive, it defaults to the current one, which may or may not be what you want. So, if the specified path and filename isn't located in the current drive,...
  12. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    You only need to call ReplaceRectangleImage, which will in turn call the GetReplacementImage and ReplaceImage...


    Sub RunAll()
    Call insert
    Call ReplaceRectangleImage
    End Sub
  13. Replies
    10
    Views
    185

    Re: How to click hyperlink on webpage

    Can you specify which line gives you an error, and which error it gives you?
  14. Replies
    10
    Views
    185

    Re: How to click hyperlink on webpage

    In John's code, Internet Explorer has been assigned to the object variable IE. However, you refer to objIE. Could this be the issue? If not, can you post the complete code for us to look at?
  15. Re: Replace image on sheet1 shape fill with image from sheet2 cell

    Place the following code in a regular module (Visual Basic Editor >> Insert >> Module). Note that it assumes that the workbook running the code contains the relevant sheets (Sheet1 and Sheet2).

    ...
  16. Replies
    10
    Views
    185

    Re: How to click hyperlink on webpage

    A minor amendment to John's code...


    While i < HTMLdoc.Links.Length And link Is Nothing

    However, your second error after removing the 's' from links suggests that you have not understood...
  17. Replies
    3
    Views
    70

    Re: ComboBox Property will not change value

    That's great, thanks for your feedback.

    Cheers!
  18. Replies
    6
    Views
    114

    Re: VBA URL to image (debug error)

    While A2 contains a valid URL, it's likely that one or more cells in Column A do not, hence the error.



    Yes, but isn't the intent to loop through each cell in Column A, instead of only A2 ?
  19. Replies
    6
    Views
    114

    Re: VBA URL to image (debug error)

    Your code expects Column A to contain URL addresses (ie. https://www.xyz.com/pictures/sample.jpg), and Pictures.Insert requires a valid address. Since "GK" and "CB" are not valid, you'll get an...
  20. Replies
    2
    Views
    90

    Re: Global/Public Array

    Try creating a temporary array in which to store the desired sheet names, and then transfer the contents to myArray...


    Public Function myArray() As Variant

    Dim tempArray() As Variant
    ...
  21. Replies
    3
    Views
    70

    Re: ComboBox Property will not change value

    It looks like your combobox has a list of months, and you'd like the current (adjusted) month selected upon initialization. If so, try the following instead...


    With Me.boxDate
    ...
  22. Replies
    6
    Views
    114

    Re: VBA URL to image (debug error)

    When the error occurs at that line, what is the value of URL.Value? Is it a valid path and filename? (Note: You can move your cursor over URL.Value to display the value.)
  23. Replies
    8
    Views
    95

    Re: Worksheet Loop searching for yellow

    The following macro will loop through each worksheet within the active workbook, except the worksheet called "XXX", and copy any row that has a cell highlighted in yellow to your worksheet called...
  24. Replies
    3
    Views
    91

    Re: EXCEL Send email code Error 1004

    Try running your code again, but this time when the error occurs and you click Debug and then it takes to to the line causing the error, enter the following line of code in the Immediate Window...
  25. Replies
    3
    Views
    91

    Re: EXCEL Send email code Error 1004

    You have an invalid path and filename. You've added a backslash (\) to wPath, and then you add another backslash when you define the path and filename for your argument. So try removing it from...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4