By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,081 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

Problem Copying / Pasting excel Worksheet via VB.net

P: n/a
I have VB.net and created a small executable to consolidate excel
worksheets into a "Master file" I have it working great, except the
only way it seems to let me do it is to first delete the worksheet and
then re-create it. When I do that I lose all the formatting. Is there
some trick here?

It is very easy to do via VBA in excel, but i need to provide an
interface, thus the .net

In VBA, I just copy the range, open the Master sheet and paste the range
in. But in .net it seems to be trickier than that.

Any suggestions?
--
Jerry

~~~ plz remove "nospam." when replying via e-mail ~~~
Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.