Export Sheet Values to new workbook

M

mp

GS said:
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
Click to expand...

thanks again, Garry
Will try those out
mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Continue Excel to New Uear 9
Export specific cell values to an external workbook 1
how to copy worksheet to new workbook with values only 3
Copying a sheet fails 2
Copying cells and formula from closed workbook to all sheets in open workbook 0
How do I copy Chart shee to other workbook without external refere 2
Remove VB code when copying sheet to new workbook 2

Top