Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default my latest C++ excel OLE automation code

On 12/28/2010 4:35 PM, Lynn McGuire wrote:
// fm2n_old.cpp


// The OLE Automation interface to Excel is mostly written using:
// "How to automate Excel from C++ without using MFC or #import"
// http://support.microsoft.com/kb/216686


// to call this code :
// if (ConnectToNotebook (notebook, RunInTestMode, true))
// {
// // do your excel data transfer here
// DisconnectFromNotebook (RunInTestMode);
// }

// see getCellInfo or putCellInfo for single cell data transfer examples

// see PutRowInTable for bulk transfer example, note that the more data can
// be transferred at one time, the faster the data transfer is

//void PutRowInTable (std::string title, std::string number, std::string units, int offset)
//{
// InitTable (1, 3);
// PutStringInTable (title);
// if (units.size () 0)
// PutStringInTable (SetUnitsCase (units));
// else
// PutBlankInTable (1);
// double temp = AsDouble (number);
// PutDoubleInTable (temp);
// SendTableToServer (offset, 1, offset, 3);

Lynn
Reply
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
my latest C++ excel OLE automation code Lynn McGuire[_2_] Excel Programming 0 December 28th 10 10:40 PM
my latest C++ excel OLE automation code Lynn McGuire[_2_] Excel Programming 0 December 28th 10 10:39 PM
my latest C++ excel OLE automation code Lynn McGuire[_2_] Excel Programming 0 December 28th 10 10:38 PM
Latest Office Automation Techniques ma1achai Excel Programming 0 April 30th 08 06:41 PM
Excel automation: Why my code is hijacked? Jack Excel Programming 12 March 29th 08 11:24 PM


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