Results 1 to 5 of 5

give a different name when adding a new workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2003
    Posts
    173

    give a different name when adding a new workbook

    Hi

    I have a macro which copies cells, adds a new workbook, and pastes into it.

    But when it adds a workbook, it is named iex "Book1". If I have been working in excel it may happen that the book added is called "Book 2, 3, 4 and so on. Which makes it difficult to referr to the book. Is it possible to set the name given as prefix? for example Temporary. Without having the whole save as scenario etc..
    Last edited by Hjahren; 09-29-2010 at 08:40 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1