Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    6
    Views
    175

    Re: Auto save to PDF and email macro

    .
    Presuming the email macro you posted functions as desired, the following edits will attach a pdf file
    and display the email prior to sending.



    Option Explicit


    Private Sub...
  2. Replies
    3
    Views
    79

    Re: save excel sheets as pdf via vba

    .
    You are welcome.
  3. Replies
    3
    Views
    79

    Re: save excel sheets as pdf via vba

    .


    Sub Reorder_Sheets()

    'PURPOSE: Order Worksheets in a custom way (works even if some of the worksheets are missing)
    'SOURCE: www.TheSpreadsheetGuru.com

    Dim x As Long
    Dim myOrder As...
  4. Replies
    6
    Views
    175

    Re: Auto save to PDF and email macro

    .
    https://www.rondebruin.nl/win/s5/pdf.htm
  5. Replies
    5
    Views
    117

    Re: Macro to add a formula in a cell

    Glad to help.
  6. Replies
    6
    Views
    179

    Re: Minimizing utility

    .
    I see a different function occurring in the pic you supplied.

    The original author has hidden all of the days of the month, leaving only the month name visible.
    By assigning a macro to each of...
  7. Replies
    5
    Views
    117

    Re: Macro to add a formula in a cell

    .
    Sheets("Sheet1").Range("F4").Value = "=IF(AD3=""N/A"",EDATE(AC3,12),EDATE(AD3,12))"

    Edit the sheet name and the cell value as needed.

    Note in the formula ... where there originally was one...
  8. Replies
    6
    Views
    175

    Re: Auto save to PDF and email macro

    .
    Everything email : https://www.rondebruin.nl/win/s1/outlook/mail.htm
  9. Replies
    1
    Views
    47

    Re: Excel code to trigger mail

    .
    Keep in mind that you know what you are looking at. We don't.

    You would need to provide the present layout of your workbook. The best method is to post a copy of your workbook to a cloud site...
  10. Re: How to Create Multiple Reports from One Sheet

    .
    Yes, this is doable.

    First you'll want a macro that searches Column J (Group Name) and copies all rows with the term ABC. Repeat the process for each of the other unique names.

    Those copied...
  11. Re: VBA run 3 different macros based on 3 different conditions

    .
    Look at If / ElseIf / Then ... or a SELECT CASE statement.
  12. Replies
    5
    Views
    94

    Re: Email VBA pull email address from cell

    .
    You are welcome. Glad to help.
  13. Replies
    5
    Views
    94

    Re: Email VBA pull email address from cell

    .
    Try :



    Option Explicit


    Sub MailTest()
    ActiveWorkbook.SendMail Sheets("Directions").Range("A10").Value, "Leader Standard Work for previous week " & Date
  14. Replies
    10
    Views
    187

    Re: Userform UPDATE record and date issue

    .
    Here is the update to your UPDATE button :





    Private Sub cmdupdate_Click()
    Dim x As Long
    Dim y As Long
  15. Replies
    10
    Views
    187

    Re: Userform UPDATE record and date issue

    .
    You could add code to your existing macros to force Cols D & F to display the date as Day / Month / Year.

    However, I simply highlighted both columns and used the FORMAT command to accomplish...
  16. Replies
    10
    Views
    187

    Re: Userform UPDATE record and date issue

    This forum doesn't provide a means of uploading files. You can post your code but it is always more efficient to
    provide your sample workbook.

    You can load the workbook to a cloud site like...
  17. Replies
    3
    Views
    101

    Re: Privacy sheet tabs

    .
    Have you made progress ?
  18. Replies
    9
    Views
    187

    Re: Hide Rows Based on Cell Value

    .
    You are welcome.
  19. Thread: Save as pdf

    by Logit
    Replies
    7
    Views
    169

    Re: Save as pdf

    .
    Glad you have a solution and that I could assist.

    Cheers.
  20. Thread: Save as pdf

    by Logit
    Replies
    7
    Views
    169

    Re: Save as pdf

    .
    Here is one method :



    Option Explicit


    Sub SaveOutput()
    Dim folderChoice
  21. Replies
    3
    Views
    101

    Re: Privacy sheet tabs

    .
    You could apply a password that appears when the workbook first opens. The user can't do anything until they enter their own password,
    then only their TAB appears.

    Or ... you could create a...
  22. Replies
    9
    Views
    171

    Re: Cash Counting sheet

    .
    I believe you will find the need to use one sheet per day of operation.
  23. Replies
    9
    Views
    191

    Re: Resume macro to next line when get Prompt

    .
    Based on your comment :




    Hopefully another volunteer can assist.
  24. Replies
    9
    Views
    171

    Re: Cash Counting sheet

    .
    You are welcome.
  25. Replies
    9
    Views
    171

    Re: Cash Counting sheet

    .
    This is a clean cut and straight forward form with all the formulas included :

    https://www.amazon.com/clouddrive/share/HWyCP2XMZrLicC2R37G9TfdqhFOVxGUIsHBMZ5pDSKy
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4