Results 1 to 7 of 7

Opening Template as new workbook and not Blank Workbook from listbox

Threaded View

  1. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Opening Template as new workbook and not Blank Workbook from listbox

    Seems to me you are creating a new worksheet, wsNew in the current workbook.

    You then add the data from the listbox to the new worksheet.

    Then you have this which creates a new workbook with just that worksheet.
    wsNew.Move
    If you want to create a new workbook from a template.
    Set wbNew = Workbooks.Add("C:\TheTemplate.xlsm")
    
        ' code to add data from listbox to sheet in new workbook
    
       ' code to save new workbook
    Last edited by Norie; 01-21-2013 at 01:41 PM.
    If posting code please use code tags, see here.

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