LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Who clear the MS Macro sheet content?

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.
 
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
how to clear my macro tabulate content? Oligo Excel Programming 1 March 18th 09 05:31 AM
Clear Cells Content No_Spam Excel Discussion (Misc queries) 2 August 20th 06 04:01 PM
Clear an XML Map of all content DangerMouse[_3_] Excel Programming 1 June 23rd 06 02:43 PM
Macro to clear content and put back a formula miker1999[_9_] Excel Programming 1 February 9th 04 05:31 AM
Macro help - copy row, clear, and paste on different sheet miker1999[_3_] Excel Programming 3 February 1st 04 03:22 AM


All times are GMT +1. The time now is 02:09 AM.

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"