PC Review


Reply
Thread Tools Rate Thread

Who clear the MS Macro sheet content?

 
 
King
Guest
Posts: n/a
 
      30th Oct 2009
Dear All,

I have an excel file, which includes a MS Macro sheet. some parameters are
entered the Macro sheet.

In order to export data to that excel file,

I use OleDbConnection to connect with a MS excel file, then use
OleDbCommand::ExecuteNonQuery to write that excel file. my data can be write
to excel file, correctly.
The problem is that, the content of original Macro sheet has been cleared,
my parameter data are disappeared. I need to enter the parameter data to that
excel again.
Could i use program to copy that parameter data?
why OleDbcommand affects the macro?
Any suggestions from you are appreciated. Thank you very much.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to clear my macro tabulate content? Oligo Microsoft Excel Programming 1 18th Mar 2009 05:31 AM
inactive sheet clear content =?Utf-8?B?Y2F0cnJtZw==?= Microsoft Excel Programming 4 24th Jul 2007 12:10 PM
Macro to clear content and put back a formula miker1999 Microsoft Excel Programming 1 9th Feb 2004 05:31 AM
Macro help - copy row, clear, and paste on different sheet miker1999 Microsoft Excel Programming 3 1st Feb 2004 03:22 AM
Macro: movo to sheet ( content of a cell)? is it possible? SpeeD Microsoft Excel Misc 1 1st Aug 2003 10:57 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:35 PM.