+ Reply to Thread
Results 1 to 2 of 2

auto save from outlook to excel workbook and multiple work sheets depending on date

  1. #1
    Forum Contributor
    Join Date
    08-11-2013
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    270

    auto save from outlook to excel workbook and multiple work sheets depending on date

    Hi,

    Im not sure if this can be done..

    Every morning i get excel spread sheets send to outlook as an attachment.

    What i would like to achieve is for it to automatically save in a certain workbook but on to a different worksheet.

    So a work book has 365 work sheets, 1 for every day of the year, i would like to file to save to the work sheet on the day it is saved from outlook.

    Can anything like this be done?

    Many Thanks

    Luke

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: auto save from outlook to excel workbook and multiple work sheets depending on date

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Save Multiple Excel Sheets from a Workbook into Multiple Text Macintosh Format VBA
    By ashokpatidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2013, 10:04 PM
  2. VBA Code to work on multiple sheets in a workbook
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2012, 06:35 PM
  3. VBA Code that creates new workbook that has 2 sheets and auto save
    By jasmin1279 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2011, 10:38 AM
  4. Can this code work with multiple sheets in one workbook
    By clbutler2008 in forum Excel General
    Replies: 1
    Last Post: 07-11-2008, 07:50 PM
  5. [SOLVED] Auto Excel workbook close: save= false during an auto subroutine
    By tomwashere2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-16-2005, 02:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1