Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Dawber

  1. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    Apologies for bumping my thread but I'm still looking for a solution, can anybody help?
  2. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    Still brings up the same error message and highlights the "mItem.Save" line of code but thanks for responding.
  3. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    With the help and refinement of several posters on this forum, I created a macro, run from the Outlook vba environment, for inserting a date and time stamp on the front end of an e-mails subject, see below for code. The purpose of the macro is to time stamp the subject of each individual email...
  4. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    Thanks for responding, yes it is run in the Outlook VBA environment. The purpose of the macro is to time stamp the subject of each individual email in a folder (eg. the Inbox), so that they can be dragged and dropped into a hard drive / server / dvd folder and will then be listed in...
  5. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    The problem seems to be that Outlook 2010, unlike the 2003 version, will not accept the .save command to update a message subject, hence the error message. Is anybody aware of a method of changing a message subject in VBA that is accepted by Outlook 2010?
  6. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    The VB error message reads: Run-time error '-2147221239 (80040109)': The operation cannot be performed because the message has been changed.
  7. Dawber

    Outlook 2003 VBA Won't Run In Outlook 2010

    With the help and refinement of several posters on this forum, I created a macro in Outlook for inserting a date and time stamp on the front end of an e-mails subject, see below for code. After updating to Outlook 2010 from 2003, the code which used to operate flawlessly now falls over on the...
  8. Dawber

    Excel VBA to Populate Word Header Bookmark

    I am using data in an Excel sheet to populate bookmarks in a Word document template, see code below for details. To this point, the macro operates perfectly but I am now struggling to place data against an additional bookmark located in the header of the Word template and would appreciate some...
  9. Dawber

    Excel Date Dependant Sum Range

    Thanks combo, exactly what I was after.
  10. Dawber

    Excel Date Dependant Sum Range

    I have numerous rows of data in date headed columns (See A1:D4 below for example). [tab][tab] A[tab][tab][tab]B[tab][tab][tab]C[tab][tab][tab]D[tab][tab][tab]E[tab][tab][tab]F 1 25/01[tab] 01/02[tab] 08/02[tab] 15/02[tab]<Today >Today...
  11. Dawber

    Using Excel to create and save MS Project document

    Tony, I realise that you are here to help and that is all I'm asking for, not to do it for me, hence if you look at my first response to Skip, you will see that I had tried your MSProject.Project idea, aswell as .Projects. I appreciate both of you taking the time to respond.
  12. Dawber

    Using Excel to create and save MS Project document

    I have already set that reference Skip.
  13. Dawber

    Using Excel to create and save MS Project document

    Hi Skip, I got a compile error "User-defined type not defined" with the second line highlighted, so I changed MSProject.Document to MSProject.Project The code now terminates at the fourth line: Set aProj = appProj.Documents.Open(Filename:="C: \MS Project.mpt") with a Runtime error 438, Object...
  14. Dawber

    Using Excel to create and save MS Project document

    I am trying to create a Microsoft Project document from a template, input two pieces of data gathered from an Excel spreadsheet, name the document with the same two pieces of data, save the MS Project file and exit the application. I have no idea how to open the MS Project application but based...
  15. Dawber

    Setting the folder focus in Outlook VBA

    I use the following VBA code to incorporate the date at the beginning of each e-mail's subject in the Inbox. Is it possible to run the macro on the current folder (Inbox, Sent Items, Whatever), rather than naming a specific location? Sub AddDateToSubject() Dim mItem As Object Dim oFolder As...

Part and Inventory Search

Back
Top