Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Outlook UserForm Add Code to Project

  1. #1
    Join Date
    3rd December 2011
    Posts
    3

    Outlook UserForm Add Code to Project

    Hi All,
    Been looking around, but haven't found anything on my specific question. So I am writing a project that scans a users subfolder and saves attachments when certain criteria is met (ie. string in the subject line, from a specific person, specific attachment name etc. or a combination of all). That's dandy; but to make this thing pop and have a substantial life without high maintenance, I wanted to make a userform so that a user can add new/delete/edit the cases themselves.

    Now the tricky part I am stuck on is....is it even possible to grab the variables defined by the user, add to the case logic and save to the current project as a new sub?

    I also don't know if it'd be easier to create snipits and use outlooks 'rules & alerts' functions to run a script to save the files.

    Really just looking for another opinion from people familiar with VBA.

    Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st September 2010
    Posts
    7,920

    Re: Outlook UserForm Add Code to Project

    Why not store the various criteria outside Outlook - for example in an Access table, Excel spreadsheet, .INI file or even in the registry...?

    Trying to modify the code programmatically is not the way to go...

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Distribute Macro Code Project
    By The Dutchman in forum EXCEL HELP
    Replies: 5
    Last Post: May 27th, 2008, 06:38
  2. Lock VBA Project With Code
    By mrfitness in forum EXCEL HELP
    Replies: 7
    Last Post: January 20th, 2008, 01:31
  3. Unprotecting VBA Project via VBA code to change code
    By HarryFrohlich in forum EXCEL HELP
    Replies: 22
    Last Post: July 27th, 2006, 20:57
  4. UnProtection Code for VBA Project properties
    By DoubleB in forum EXCEL HELP
    Replies: 7
    Last Post: October 25th, 2004, 13:24

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
  •  
porno