Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remedy for an Office 13 deprovement

    I'm not yet a fan of Office 13 and they're making that easy. I relied heavily on the automatic Journal entry folder to track the tons of Excel workbooks I use over the course of months. No way I could track them personally. Some didn't come up as a topic for months after the workbook was first created and used. The Big Thinkers at Microsoft elected to eliminate automatic entries without asking me.
    At least for Excel, can anyone suggest an event macro for On Save that would create a Journal entry in the folder? One that I could put in my personal macro workbook to populate the JE folder with an entry every time I save a workbook, with the full path, as there are lots of places on the network. Any assistance would be really appreciated! TYIA

  2. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,594
    Thanks
    5
    Thanked 1,059 Times in 928 Posts

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That's helpful, thanks. I will try to make it a Closing event, and one where the Journal "item" is fully handled by the macro. I don't want to have to do anything except find the entry in the journal folder. If the macro can answer any save questions, it should.

Posting Permissions

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