Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.19 seconds.

  1. Replies
    10
    Views
    320

    Re: VBA_Selecting Filter on Site

    How about the first message box? What does it say?
  2. Re: Change page orientation of specific pages within same worksheet when exporting to PDF

    Welcome to the Board

    For starters, we need to determine where the charts are:


    Dim s$, pag(), ws As Worksheet


    Sub main()
    Dim i%, j%
  3. Re: Extract Query Text from multiple Excel Files

    Would you like the queries in a Word table? Note that a worksheet cell can hold 32K characters.
  4. Re: Extract Query Text from multiple Excel Files

    Does this help?


    Sub test2()
    Dim c As WorkbookConnection
    On Error Resume Next
    For Each c In ActiveWorkbook.Connections
    MsgBox c.Name & vbLf & c.ODBCConnection.CommandText
    Next
    End Sub
  5. Replies
    10
    Views
    320

    Re: VBA_Selecting Filter on Site

    I can see it now. Please test the code below and report the results:


    Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)


    Sub test()
    Dim IE As Object, htmlDoc As Object,...
  6. Replies
    3
    Views
    149

    Re: email validation msgbox YES/NO

    Hi Albert

    Are you in Virginia or East Anglia?


    Private Sub DP1_Exit(ByVal Cancel As MSForms.ReturnBoolean)


    If MsgBox("Is this email correct?", 4, DP1) = 7 Then Cancel = 1
  7. Replies
    10
    Views
    320

    Re: VBA_Selecting Filter on Site

    I cannot see it. You have to upload it to a hosting site and paste a link here, it will display as either a text link or the picture itself, as I did. I am using Imgur to share my images....
  8. Replies
    3
    Views
    149

    Re: email validation msgbox YES/NO

    Hi


    ' DP1 is a text box
    Private Sub DP1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Dim s$
    With CreateObject("vbscript.regexp")
    .Pattern = _
    ...
  9. Replies
    10
    Views
    320

    Re: VBA_Selecting Filter on Site

    Can you post the actual image of the code inspect window for the add filter control, as exemplified below?

    https://i.imgur.com/Gr21Pfq.jpg
  10. Replies
    10
    Views
    320

    Re: VBA_Selecting Filter on Site

    Hello

    Can you post the page address where the control is or is it a restricted site?
  11. Replies
    2
    Views
    136

    Re: Treeview Hyperlink problem

    This webpage has a sample workbook that does it:

    http://www.cpearson.com/excel/FolderTreeView.aspx
  12. Replies
    10
    Views
    1,337

    Re: User form in PowerPoint to feed Excel database

    See below a link to my test presentation for the registration procedure. Note that it expects to find a workbook already open and with a certain name. This can be changed if you wish.
    The button...
  13. Re: VBA to send email of sheet within the new email

    You could consider this code, which produces individual messages as shown:

    https://i.imgur.com/4WIWPVu.jpg


    Sub Macro1()
    Dim lr%, i%, olapp As Object, myitem As MailItem
    [i2] = [a2]
    [i3] =...
  14. Replies
    10
    Views
    1,337

    Re: User form in PowerPoint to feed Excel database

    The choice to either create a document or update one is yours. It can be decided beforehand or at runtime, based on some condition.
    Same thing for the file format, although I do not see why we...
  15. Replies
    10
    Views
    1,337

    Re: User form in PowerPoint to feed Excel database

    Do you mean on the user’s desktop? The code can open a file and write the data. It could be a workbook, a Word document or a plain text file.
  16. Replies
    10
    Views
    1,337

    Re: User form in PowerPoint to feed Excel database

    The following example shows how to require a registration:


    ' PowerPoint UserForm module
    Private Sub CommandButton1_Click()
    Dim xap, wb As Workbook, i%, ws As Worksheet, lr%
    If...
  17. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    I understand you are still getting the ambiguous name error, it is duplicated somewhere on the workbook.
    Try changing the routine name to something completely different. If trouble persists, please...
  18. Replies
    10
    Views
    1,337

    Re: User form in PowerPoint to feed Excel database

    Welcome to the Board



    This is Power Point example code; run the InitApp routine first to enable events.
    A user form will pop up at the last slide, and the inputted data is transferred to a...
  19. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    Justin

    You can have only one routine with that name, use the version from post 25.

    Keiran

    I will work on your request as soon as the OP‘s query is solved.
  20. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    You can get that function at post 23.
  21. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    New version:


    Sub main2() ' run me
    Dim a(1 To 2), i%, rng As Range, OutApp As Object, om As Object, r%, f$
    lr = Range("e" & Rows.Count).End(xlUp).Row
    Sort
    a(1) = CDbl(Cells(2, 5)) ...
  22. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    The following code creates a formatted email, is this your desired product?

    https://i.imgur.com/81oqKxc.jpg


    Dim lr%


    Function RangetoHTML(rng As Range)
    ' Changed by Ron de Bruin...
  23. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    The previous code is not very good, as it uses a helper column, this one is better:


    Sub main2()
    Dim a(1 To 2), i%
    lr = Range("e" & Rows.Count).End(xlUp).Row
    Sort
    a(1) = CDbl(Cells(2, 5)) ...
  24. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    The following code separates the dates; I will be back later with the email part.



    Dim lr%
    Sub main()
    Dim a(1 To 2), i%
    lr = Range("e" & Rows.Count).End(xlUp).Row
    Range("g2:g" & lr).Formula...
  25. Replies
    33
    Views
    1,099

    Re: Help Modifying Code to Send E-mail

    Questions:

    Do you want the code to insert the blank rows?
    I understand that after the dates are separated, all the range has to be transferred to a single email, is this correct?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4