Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Copying "ThisWorkbook" objects


Confused newbie question...

I have several tabs in a workbook. I want to copy only the "template
tab to a new workbook and have the new workbook reflect the sam
workbook attributes (code) as the old. Can I do this?

I really appreciate any help you could provide.

Thanks,
Bo

--
rpgu
-----------------------------------------------------------------------
rpgun's Profile: http://www.excelforum.com/member.php...fo&userid=1542
View this thread: http://www.excelforum.com/showthread.php?threadid=27222

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Copying "ThisWorkbook" objects

This will take the worksheet code across, but not code in a standard code
module

Sheets("Sheet1").Copy


--

HTH

RP

"rpgun" wrote in message
...

Confused newbie question...

I have several tabs in a workbook. I want to copy only the "template"
tab to a new workbook and have the new workbook reflect the same
workbook attributes (code) as the old. Can I do this?

I really appreciate any help you could provide.

Thanks,
Bob


--
rpgun
------------------------------------------------------------------------
rpgun's Profile:

http://www.excelforum.com/member.php...o&userid=15426
View this thread: http://www.excelforum.com/showthread...hreadid=272227



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Macro update "ThisWorkbook" sheet? Don Excel Discussion (Misc queries) 1 February 18th 09 07:58 PM
Programatically adding macro to Excel - "ThisWorkbook" Aerojade Excel Discussion (Misc queries) 3 October 1st 08 12:53 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
ThisWorkbook.Path & "\" & .... not WAVFile, but AVI file... ste mac Excel Programming 0 May 31st 04 10:22 AM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"