Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    30
    Views
    766

    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...
  2. 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:
    ...
  3. Replies
    30
    Views
    766

    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...
  4. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    It can be done; I will be back soon...
  5. 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...
  6. Replies
    5
    Views
    204

    Re: Excel Header and Footers

    Excel > Alt + F11 > insert module


    Sub SameHeadersDifferentFooters()
    Sheets("Sheet1").PageSetup.CenterHeader = "Same"
    Sheets("Sheet1").PageSetup.CenterFooter = "Different11"...
  7. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    Hi


    Sub AutoSpace_Shapes_Horizontal()
    'Automatically space and align shapes horizontally.
    Dim shp As Shape, lCnt%, dTop#, dLeft As Double, dWidth#, ws As Worksheet
    Const dSPACE As Double = 8...
  8. Re: ADODB Insert Query - Modify to Update instead ?

    For starters we need to determine if the record exists; SQL has an EXISTS statement but it is not supported on all situations. See example below for an alternative method.
    Next step will be the...
  9. Replies
    4
    Views
    152

    Re: Need help to navigate website through VBA

    I am glad I could help... :cool:
  10. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    New version:


    Dim colonne%, débutOrg As Range, f As Worksheet, forga As Worksheet, inth%, intv%, Tbl()
    Sub orga()
    Dim s As Shape
    '-------------------------------------niveau 0
    Set f =...
  11. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    I am using Imgur to upload pictures, when you choose direct link there it will display itself here.

    I will be back later with code updates.
  12. Re: I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    Outlook has a new mail event, which can be used to automatically execute a macro. Can you try to reproduce the example in the page below?
    If we choose not to use it, Excel has an On Time method that...
  13. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    I increased the length of the vertical connectors:

    https://i.imgur.com/94svJiI.jpg


    Dim colonne%, débutOrg As Range, f As Worksheet, forga As Worksheet, inth%, intv%, Tbl()
    Sub orga()
    Dim s...
  14. Re: I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    Would you like to run it at a particular time of the day? How many times per day?
  15. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    Placing the new information below the shapes will compete with the connectors. Would you prefer to put it on top of each shape?
  16. Replies
    2
    Views
    109

    Re: PDF to Excel conversion through VBA

    Do you really need the PDF document in Excel format?


    Sub Ind()
    ActiveWorkbook.FollowHyperlink "C:\tmp\cvjul.pdf"
    End Sub
  17. Replies
    4
    Views
    152

    Re: Need help to navigate website through VBA

    Hi


    Sub xyz()
    Dim usern, objcoll As Object, appIE As Object, pswd, i%
    Set appIE = CreateObject("internetexplorer.application")
    With appIE
    .navigate...
  18. Replies
    30
    Views
    766

    Re: Add New Variable to Shapes

    Hi

    Can you post the main code that calls the recursive procedure?
  19. Replies
    3
    Views
    336

    Re: Solver VBA - Changing variables in column

    What do you mean by does not work? Do you get an error?
    The code below works for me.
    Obviously, my test model is different from yours. Can you email me your problem?
    If you want cell D3, use...
  20. Thread: http elements xml

    by Worf
    Replies
    1
    Views
    303

    Re: http elements xml

    I like this site: https://www.w3schools.com/tags/tag_div.asp

    Regarding the “$0”, can you explain in detail what are you trying to do?

    https://i.imgur.com/aK0ScdI.jpg
  21. Re: Pivot Table Data Field Format Macro Modification

    Hi


    Sub SumAllValueFields()
    Dim pt As PivotTable, pf As PivotField, WS As Worksheet
    Set WS = ActiveSheet
    Set pt = WS.PivotTables(1)
    Application.ScreenUpdating = 0
    pt.ManualUpdate = True
    For...
  22. Replies
    3
    Views
    160

    Re: Return Timeline Selection

    You could use a UDF. If no VBA is allowed, I can try a different approach.

    <b>Plan16</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial;...
  23. Replies
    3
    Views
    160

    Re: Return Timeline Selection

    Yes.


    Sub Marine()
    '
    Dim t As TimelineState


    Set t = ActiveWorkbook.SlicerCaches("NativeTimeline_date1").TimelineState
    MsgBox t.StartDate & vbLf & t.EndDate
  24. Re: I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    Hi


    Sub ExtractEmailContent()
    Dim olApp As Outlook.Application, olNs As Namespace, olFolder As MAPIFolder, _
    olMail As MailItem, eFolder As folder, i As Long, x As Date, ws As Worksheet, lRow&...
  25. Replies
    1
    Views
    107

    Re: Have trouble transposing XML Data

    You can upload a XML or XLS file to a site like Drop Box and paste a link here.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4