LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #20   Report Post  
Posted to microsoft.public.excel.programming
mp mp is offline
external usenet poster
 
Posts: 70
Default Export Sheet Values to new workbook


"GS" wrote in message
...
Actually, I never tried that this Copy method would return a wkb object.
Apparently it doesn't, which means I once again fell victim to ass-u-me!
Sorry, -my bad!

Here's a revision for both approaches, which have been tested:

[...]
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


thanks again, Garry
Will try those out
mark




 
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
Export specific cell values to an external workbook Razorboy Excel Programming 1 October 28th 08 02:08 AM
How to export a linked cell sheet to get only values. CAPTGNVR[_2_] Excel Programming 3 April 30th 08 11:42 AM
Export Specific Sheet in Listbox to New Workbook Carlee Excel Programming 1 April 13th 07 07:56 PM
Export selected Sheet in a new workbook with old workbook name! gr8guy Excel Programming 5 September 11th 04 01:53 AM
Export just one sheet from a workbook Grek[_3_] Excel Programming 2 May 9th 04 01:52 PM


All times are GMT +1. The time now is 07: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"