Consulting

Results 1 to 3 of 3

Thread: Altering closed workbooks.

  1. #1
    VBAX Contributor
    Joined
    Oct 2004
    Location
    Cardiff
    Posts
    120
    Location

    Altering closed workbooks.

    Hi all,

    Can I, using VBA, move or delete sheets in a workbook without opening it? It's a question from MrE, but it's one that would be very handy to know the answer to.

    Regards
    You cannot solve all the world's major problems using only potatoes. :- Adams

    http://www.vbaexpress.com

  2. #2
    VBAX Mentor CBrine's Avatar
    Joined
    Jun 2004
    Location
    Toronto, Canada
    Posts
    387
    Location
    Hey Tamer,

    I know that it is possible to modify a cells contents without opening the workbook, but I don't believe it's possible to delete or move the worksheets within a closed workbook.
    The most difficult errors to resolve are the one's you know you didn't make.


  3. #3
    VBAX Contributor
    Joined
    Oct 2004
    Location
    Cardiff
    Posts
    120
    Location
    Damn!
    You cannot solve all the world's major problems using only potatoes. :- Adams

    http://www.vbaexpress.com

Posting Permissions

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