 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / September 2007Sheets("sheet1").Copy
Sheets("sheet1").Copy This line of code copies the sheet1 to a new workbook useing the default template. Is there a way to put into the code and tell excel which template to use. I want to avoid changing everyone default template. What do you mean by default template??? That line of code copies the sheet with tab name "sheet1" from the active workbook to a new workbook.  SignatureHTH... Jim Thomlinson > Sheets("sheet1").Copy > [quoted text clipped - 3 lines] > > I want to avoid changing everyone default template. Are you thinking of Word where there is a Normal.dot file. XL has nothing similar... SignatureHTH... Jim Thomlinson > What do you mean by default template??? That line of code copies the sheet > with tab name "sheet1" from the active workbook to a new workbook. [quoted text clipped - 6 lines] > > > > I want to avoid changing everyone default template. I don't understand. This'll copy that sheet1 to a new workbook--there's no template involved (no workbook template and no worksheet template). > Sheets("sheet1").Copy > [quoted text clipped - 3 lines] > > I want to avoid changing everyone default template. SignatureDave Peterson I ceated a excel tempalte the include serveral macro. I want to be able use Sheets("sheet1").Copy But have excel use the template to open the new workbook >I don't understand. > [quoted text clipped - 8 lines] >> >> I want to avoid changing everyone default template. Create a new workbook that uses that template. Copy the worksheet into that workbook. Dim NewWkbk As Workbook Dim WksToCopy As Worksheet Set WksToCopy = ActiveWorkbook.Worksheets("Sheet1") Set NewWkbk = Workbooks.Add(template:="C:\folder\yourtemplatename.xlt") WksToCopy.Copy _ before:=NewWkbk.Worksheets(1) > I ceated a excel tempalte the include serveral macro. > [quoted text clipped - 16 lines] > >> > >> I want to avoid changing everyone default template. SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.