Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Re: VBA IE Automation | clicking button inside table

    Hi



    Can you share the actual URL?
    What does the code below give you?
  2. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    The chart that goes from bottom to top does not centre the offspring relative to its parent. Would you like to use the top to bottom template, which does the centring, or shall we continue with the...
  3. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    This version uses a single worksheet, with the table starting at cell A1. As the code works by deleting rows, ranges are being moved around.


    Sub main() ' run me
    Dim arr(), i%
    arr =...
  4. Re: Urgent - download data from website that requires login id and password

    Hazel snowy:



    Another option is to hardcode the credentials into the VBA code and password protect it. Beginners will have trouble cracking it.
    As for the code itself, it has to be done...
  5. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    Do you want to work with a single worksheet?
    Would you like the source table next to the chart, as a picture?
  6. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    This is the code; I will be back later to comment your questions…

    <b>data2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  7. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    Hi

    This is what I have so far:

    https://i.imgur.com/TyGsCA2.jpg
  8. Replies
    9
    Views
    456

    Re: Navigate and getting data from website

    John

    I did not test your method because the pop up at that site does not seem to be the download notification bar.
    The code below uses send keys for the time being. The second macro copies the...
  9. Replies
    9
    Views
    456

    Re: Navigate and getting data from website

    IE automation is not completely reliable, but the code below brings up the dialog window to download the file.
    Now I will decide whether to use the send keys method or something more elegant.

    ...
  10. Replies
    10
    Views
    252

    Re: XML Import Confussion

    Sounds like you need to expand the data:

    https://www.howtoexcel.org/power-query/import-xml-files/
  11. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    You are welcome

    I will wait for your feedback. There are at least two possible tasks ahead:



    Converting your data table into mine.
    Creating a chart that goes from bottom to top.
  12. Replies
    9
    Views
    456

    Re: Navigate and getting data from website

    The page has 12 workbooks, which one do you want?


    Sub Scrape()
    Dim Browser As InternetExplorer, Document As HTMLDocument, Elements
    Dim Element As IHTMLElement, doc, i%
    Set Browser = New...
  13. Replies
    9
    Views
    456

    Re: Navigate and getting data from website

    Hi

    This is the first part; I will be back during the week to complete it.


    Sub Scrape()
    Dim Browser As InternetExplorer, Document As HTMLDocument, Elements
    Dim Element As IHTMLElement, doc,...
  14. Replies
    1
    Views
    103

    Re: Filtering a Pivot by user input value?

    Hi

    https://www.wiseowl.co.uk/blog/s2458/inputbox.htm


    Sub Macro21()
    Dim pt As PivotTable
    Set pt = ActiveSheet.PivotTables("pivot2")
    pt.PivotFields("status").PivotFilters.Add2...
  15. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    I made a minor tweak to the code; the link to my test workbook is below. It produces the chart shown at the previous post.
    An interesting way to study this code is to activate the debugger, execute...
  16. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    This is the code; next step will be converting your data table into the one this code wants.


    Sub main()
    CreateDiagram Sheets("object")
    End Sub


    Sub CreateDiagram(Source As Worksheet)
    Dim...
  17. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    Here is what I have so far:

    <b>invoice</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
  18. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    The shadows can be removed. I want to use the smart art engine because producing a well-arranged organizational chart is not trivial and it does the job.
    Likewise, my code will place the extra...
  19. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    I found code that automatically produces the smart art below, do you like it?

    https://i.imgur.com/yCMzfsj.jpg
  20. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    I did not give much explanations but I am glad you got the idea…
    Test the version below on a copy of your workbook as it deletes sheet data.
    I will be back during the week with code that actually...
  21. Re: How do you query in excel? What would be the best program to complete this in?

    Hi Dave and Michael

    A fast tool to query Excel sheets is ADO & SQL. See below thread:
    ...
  22. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    The get data procedure is a start, it collects necessary information:


    Dim colonne%, débutOrg As Range, f As Worksheet, forga As Worksheet, inth%, intv%, Tbl()
    Sub orga()
    Dim s As Shape...
  23. Replies
    54
    Views
    1,815

    Re: Add New Variable to Shapes

    It can be done; I will be back soon...
  24. Re: ADODB Insert Query - Modify to Update instead ?

    From the Internet:

    The Connection object is the top-level object in the ADO hierarchy. It represents the connection made to the data source through the OLE DB data provider, and handles all...
  25. Replies
    5
    Views
    237

    Re: Excel Header and Footers

    Excel > Alt + F11 > insert module


    Sub SameHeadersDifferentFooters()
    Sheets("Sheet1").PageSetup.CenterHeader = "Same"
    Sheets("Sheet1").PageSetup.CenterFooter = "Different11"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4