Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    5
    Views
    190

    Re: Excel Header and Footers

    Excel > Alt + F11 > insert module


    Sub SameHeadersDifferentFooters()
    Sheets("Sheet1").PageSetup.CenterHeader = "Same"
    Sheets("Sheet1").PageSetup.CenterFooter = "Different11"...
  2. Replies
    19
    Views
    430

    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...
  3. 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...
  4. Replies
    4
    Views
    140

    Re: Need help to navigate website through VBA

    I am glad I could help... :cool:
  5. Replies
    19
    Views
    430

    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 =...
  6. Replies
    19
    Views
    430

    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.
  7. 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...
  8. Replies
    19
    Views
    430

    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...
  9. 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?
  10. Replies
    19
    Views
    430

    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?
  11. Replies
    2
    Views
    99

    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
  12. Replies
    4
    Views
    140

    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...
  13. Replies
    19
    Views
    430

    Re: Add New Variable to Shapes

    Hi

    Can you post the main code that calls the recursive procedure?
  14. Replies
    3
    Views
    335

    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...
  15. Thread: http elements xml

    by Worf
    Replies
    1
    Views
    300

    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
  16. 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...
  17. Replies
    3
    Views
    156

    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;...
  18. Replies
    3
    Views
    156

    Re: Return Timeline Selection

    Yes.


    Sub Marine()
    '
    Dim t As TimelineState


    Set t = ActiveWorkbook.SlicerCaches("NativeTimeline_date1").TimelineState
    MsgBox t.StartDate & vbLf & t.EndDate
  19. 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&...
  20. Replies
    1
    Views
    102

    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.
  21. Replies
    3
    Views
    335

    Re: Solver VBA - Changing variables in column

    This example works for me:


    Sub Macro1()


    Dim lr%
    lr = Range("d" & Rows.Count).End(xlUp).Row
  22. Replies
    4
    Views
    208

    Re: Maximum Size for a 2 dimensional array

    The code below works for me. You can always use worksheet cells with screen updating disabled, but it may be slower.
    Could you do it all within SQL?


    Sub Macro1()
    Dim ukey, i, j, maxx, maxy...
  23. Replies
    5
    Views
    125

    Re: Extract Query Text from multiple Excel Files

    So tell me if you are stuck. The best way to learn is doing it yourself.
  24. Replies
    1
    Views
    108

    Re: Area graphs ends on axis mid point

    Create a dummy extra point to the right and do not plot it.

    https://i.imgur.com/bPuEjlM.jpg
  25. Replies
    6
    Views
    215

    Re: Combination And Permutation with no repeat

    Here: https://www.mrexcel.com/forum/excel-questions/277924-combination-help-5.html#post1424848
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4