Results 1 to 2 of 2

Thread: Solved: Copy a Sheet,delete a range Then save the org Template

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-15-2011, 10:36 AM #1
    Rob342
    Rob342 is offline
    VBAX Mentor
    Joined
    Apr 2009
    Location
    Kingsbury
    Posts
    421
    Location

    Solved: Copy a Sheet,delete a range Then save the org Template

    Hi All

    I have a excel template from which we download info from our DMS system.
    I have managed to copy the template from the original and put it in C folder ok.
    The next step i wanted to create, was to close the copy sheet, then go back to the original template, delete range A2:P500 save the sheet then quit excel.
    Password for the sheet = "AMN"
    Have attached a copy with the code if anybody could help with the missing bits.

    Thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules