Search:

Type: Posts; User: HowardC; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    22
    Views
    942

    The calendar feature is great and makes it easy...

    The calendar feature is great and makes it easy to select the date

    As can be seen on this forum, I am posting a lot less as I am able to write code for a number of my projects now
  2. Replies
    22
    Views
    942

    Hi Zeddy This is perfect. Its a fantastic tool

    Hi Zeddy

    This is perfect. Its a fantastic tool
  3. Replies
    22
    Views
    942

    Hi Zeddy Thanks for getting back to me. I...

    Hi Zeddy

    Thanks for getting back to me. I found what was causing "problem!" to occur under status. The files to be moved were already in the destination folder. If the file name already exists in...
  4. Replies
    22
    Views
    942

    Hi Zeddy Thanks very much. Hope you had a good...

    Hi Zeddy

    Thanks very much. Hope you had a good weekend

    Most of the zipped files moved to the folder selected. I have 5 .zip files that after selectinmg start that come up with status problem!...
  5. Replies
    22
    Views
    942

    Hi Zeddy Thanks for the reply. Thanks for your...

    Hi Zeddy

    Thanks for the reply. Thanks for your willingness to amend the code to include subfolders within the source folder

    Enjoy your weekend getaway

    Howard
  6. Replies
    22
    Views
    942

    Hi Zeddy Thanks for your reply. I have 16...

    Hi Zeddy


    Thanks for your reply. I have 16 subfolders, but none of the files have duplicate names so no need for destination folder to have subfolders. It is used for archiving purposes only
  7. Replies
    22
    Views
    942

    Hi Zeddy Thanks very much, for all your...

    Hi Zeddy

    Thanks very much, for all your effort. The code moves all zip files earlier than the period selected in the source folder, but not the zipped files in the sub-folders for eg I have sub-...
  8. Replies
    15
    Views
    1,249

    Hi Maud Thanks for the positive feedback and...

    Hi Maud


    Thanks for the positive feedback and for your input

    I have modified the code to


    If InStr(1, oFile, "Backup", 1) > 0 Then
  9. Replies
    15
    Views
    1,249

    Hi Maud You recently helped me to email zip...

    Hi Maud

    You recently helped me to email zip files. It would be appreciated if you would kindly amend the code to exclude zip files containing "backup" in the name of the zip file



    Sub...
  10. Replies
    19
    Views
    1,133

    I have amended my code to move files from C:\tax...

    I have amended my code to move files from C:\tax files to C:\old tax files less than a certain period for eg less than or = to 30/09/2014, old the files in C:\tax files moves to C:\old tax


    It...
  11. Replies
    22
    Views
    942

    Thanks Maud I will attempt to get this sorted...

    Thanks Maud

    I will attempt to get this sorted out, otherwise will ask Zeddy for some help
  12. Replies
    22
    Views
    942

    Hi Maud I commented the line code On error...

    Hi Maud

    I commented the line code On error resume next



    My dates are dd/mm/yyyy Regional UK. Has this not got anything to do with it as American dates are mm/dd/yyyy?

    When running the...
  13. Replies
    22
    Views
    942

    Hi Maud No files have moved to C:\old tax...

    Hi Maud

    No files have moved to C:\old tax files folder. When Running the macro , all I get is a pop up menu showing the date and time
  14. Replies
    22
    Views
    942

    Hi Maud It is the date the file was...

    Hi Maud

    It is the date the file was created/modified
  15. Hi Maud Thanks very much for all your effort

    Hi Maud

    Thanks very much for all your effort
  16. Replies
    22
    Views
    942

    Macro to moves files based on a period

    I have tried to modify code as to move files less that a certain period from C:\Tax Files to C:\old tax files

    For eg moving all files in the folder C:\Tax Files < 01/10/2014 to C:\old tax files....
  17. Hi Paul Thanks for the reply. I went into...

    Hi Paul

    Thanks for the reply. I went into outlook > View settings > Columns and then experimented for a few minutes and managed to organize my inbox to have the following columns: ...
  18. Inbox Names appear as my email address not senders email address

    When I receive emails, these either appear as my email address in the inbox or as my name

    I would like to know how I go about amending this so that the sender email address or senders name appears...
  19. Hi Maud Thanks for the reply What I am...

    Hi Maud


    Thanks for the reply

    What I am trying to achieve it to extract each type and category to the applicable sheet

    For Eg Type Sales Cat Retail must be extracted to sheet names Retail...
  20. Macro to use advanced filter to extract data to respective sheets

    I have created a macro to the category (Col P) and Type (Col Q) based on the data on sheet1

    See my macro below as well as my sample workbook


    It would be appreciated if someone could kindly...
  21. Replies
    19
    Views
    1,133

    Hi Thanks for the reply. I am sorry that I...

    Hi

    Thanks for the reply. I am sorry that I cannot help further as I not sure how accomodate your requirements. If you send Zeddy a private message, I am certain he will be able to amend the code...
  22. Replies
    19
    Views
    1,133

    Hi Stotter33 Attached please find a...

    Hi Stotter33


    Attached please find a workbook, where the code was kindly supplied by Zeddy, which I amended slightly

    You will need to change the change the source folder as well as the...
  23. Replies
    0
    Views
    80

    Save Outlook files/Templates

    I would like to know if possible whether one can set the default for all outlook templates & emails to be saved to C:\Emails

    It would be appreciated if someone could kindly advise me how to do this
  24. Replies
    7
    Views
    665

    Thanks for getting back to me. Anyway I have been...

    Thanks for getting back to me. Anyway I have been using Martin's method and it is working perfectly
  25. Replies
    2
    Views
    199

    Thanks Paul

    Thanks Paul
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4