Results 1 to 2 of 2

Thread: Macro to Share Workbook Through Email

  1. #1
    Seeker tzaharia's Avatar
    Join Date
    Jan 2020
    Posts
    6
    Articles
    0
    Excel Version
    365 Office

    Macro to Share Workbook Through Email



    Register for a FREE account, and/
    or Log in to avoid these ads!

    So I am setting up a parent (Source) workbook which will have tabs dedicated to each client we have. Each client will have their own child(Destination) workbook in their respective folders. The parent workbook is the source workbook we put data into. The respective clients child workbook gets updated automatically from the parent (Source) workbook.

    When all the data is put into the clients tab and their Destination Workbook is updated, we need to share the clients Destination workbook with that specific client. I am trying to create a macro for a command button that will allow us to share the clients Destination workbook automatically. I do not have an depth knowledge of VBA and developing macros so if someone knows a script that would allow this it would be very helpful.

  2. #2
    Seeker tzaharia's Avatar
    Join Date
    Jan 2020
    Posts
    6
    Articles
    0
    Excel Version
    365 Office
    Also I cannot use OneDrive because our companies files are stored in Dropbox servers which means I cannot turn on Autosave which is how one shares excel files in the first place.


    sigh.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •