Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.75 seconds.

  1. Re: Automate the creation of graph from Pivot Table - VBA

    Here's an example, in which you'll need to change the relevant references to suit your needs...


    Option Explicit

    Sub CreatePivotChart()


    Dim destWorksheet As Worksheet
    Dim...
  2. Re: Create a loop that copies files to a new location

    That's great, glad I could help.

    Cheers!
  3. Re: Create a loop that copies files to a new location

    The following macro will start at Row 5 until the last used row in Column C...


    Private Sub File_Copy()

    Dim copyfrom As String
    Dim copyto As String
    Dim lastRow As Long
    Dim i...
  4. Re: Table Update VBA - byref argument type mismatch

    Since w2 is an object variable that has been assigned a Workbook object, and since it looks like you want to pass the assigned workbook to AddSubject, the call should be...


    Call AddSubject(w2,...
  5. Replies
    3
    Views
    81

    Re: VBA: Code for adding dynamic chart data

    Yes, as per the VBA reference found here...

    "The current region is a range bounded by any combination of blank rows and blank columns."

    So yes, it will include all columns. But, if you only...
  6. Replies
    3
    Views
    81

    Re: VBA: Code for adding dynamic chart data

    Try using the CurrentRegion property of the Range object, for example, assuming that your data starts at cell A1...


    Dim rSourceData As Range
    Set rSourceData =...
  7. Re: Insert New Checkbox into next empty cell

    While your code adds an ActiveX checkbox, it tries to set the Value property with a constant used for a Form checkbox. For an ActiveX checkbox, the Value property is set using True or False. Also,...
  8. Replies
    11
    Views
    814

    Re: Update Value on Web Page via Excel Macro

    Can you post an image of the relevant portion of the source code?
  9. Re: Unable to fetch data from a webpage through web scraping

    That's great to hear!

    Cheers!
  10. Re: VBA: Find coordinates of markers on chart and attach a textbox to them

    Have you considered using data labels? In any case, the following code will add textboxes to data points that contain markers for the specified series and for the specified chart. The textboxes...
  11. Re: Unable to fetch data from a webpage through web scraping

    It's not that the site is more secure. I've been able to get the data with all of the previous code. I'm not sure what John may have in mind, but I've amended the code so that it first searches for...
  12. Re: How to add picture as a background of comment? Excel/VBA

    Let's assume that A2 contains your comment, you can add a background image as follows...


    range("A2").Comment.Shape.Fill.UserPicture "c:\users\domenic\pictures\about.jpg"



    Change the path...
  13. Replies
    3
    Views
    112

    Re: Error on inserting picture on active cell

    It looks like you're missing the username in the path to your image...


    Path = "C:\Users\UserName\Pictures\picture.png"

    Also, to check whether a file exists, you can use the Len and Dir...
  14. Re: Unable to fetch data from a webpage through web scraping

    Maybe we can try waiting a few seconds before we actually assign the document itself to HTMLDoc. Does this help?


    Sub GetROE()

    Dim IE As Object
    Dim HTMLDoc As Object
    Dim tRows...
  15. Replies
    3
    Views
    120

    Re: Loop through all objects in a frame

    Also, you might be interested to know that the reason you're getting a type mismatch error is that you've enclosed the argument for the calling procedure within parenthesis. You'll need to remove...
  16. Re: Put text in Drawing Textbox without selecting it.

    Or, you can refer to the TextBoxes collection...


    Sheets("Instructions").TextBoxes("TextBox 1").text = "Some text"

    By the way, there's no way to close a thread on this Board, which is the way...
  17. Re: How Do I Get My Addins Ribbon Button To Display?

    Sorry, I'm not familiar those other ones. Hopefully someone else will be able to help.

    Cheers!
  18. Re: How Do I Get My Addins Ribbon Button To Display?

    If you mean the VBE HTML Maker addin, you'll find the options in the Visual Basic Editor (Alt+F11) under Tools.
  19. Re: Unable to fetch data from a webpage through web scraping

    The following macro will pop up a message box and display the ROE for the company specified in the URL...


    Option Explicit

    Sub GetROE()


    Dim IE As Object
    Dim HTMLDoc As Object
  20. Re: Vba to move emails from Inbox to personal folder

    You're very welcome!

    Cheers!
  21. Re: How to call Workbook_BeforeClose Event when commandbutton is pressed

    The reason you're getting that error is that Workbook_BeforeClose is marked Private, so it's inaccessible from outside ThisWorkbook. You can easily get around this by simply creating a new procedure...
  22. Replies
    11
    Views
    814

    Re: Update Value on Web Page via Excel Macro

    Mark, your thanks is more than enough. I'm glad I could help.

    Cheers!
  23. Replies
    11
    Views
    814

    Re: Update Value on Web Page via Excel Macro

    Try the following code...


    HTMLDoc.querySelector("button[o n c l i c k='showUpdateModal(0)']").click

    Does this help?
  24. Replies
    11
    Views
    814

    Re: Update Value on Web Page via Excel Macro

    Can you provide the URL address?
  25. Replies
    10
    Views
    280

    Re: Sumproduct for Vlookup within Vlookup?

    You're very welcome! :cool:
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4