C / C++ / MFC

9-Aug-04 0:10

Do somebody know where i can find a word automation example to write a .doc file?

Thanks a lot

tiziacaia

V.9-Aug-04 1:15

9-Aug-04 1:15

find your office "compiled help" file. This file has the .chm extension.
Here you can read up about the objects ...

It will not really get you started though.
Search on MSDN and google and idd hope that somebody has a sample code.

good luck.

"If I don't see you in this world, I'll see you in the next one... and don't be late." ~ Jimi Hendrix

David Crow9-Aug-04 2:42

9-Aug-04 2:42

MSDN article Q178749 has an Excel example. Step 9 is the important one as you'll use Word's type library instead of Excel's. Creating an instance of the (Word) _Application object and using its methods will be the same, though.

_Application app;
app.CreateDispatch(_T("Word.Application"));
Documents docs = app.GetDocuments();
CString strFilename(_T("A letter to home.doc"));
_Document doc = docs.Open(COleVariant(strFileName), ...);
...

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

tiziacaia9-Aug-04 5:00

9-Aug-04 5:00

Thanks a lot for the answers but now i get a new problem:

error C2065: '_Application' : undeclared identifier

I added word's type library, with classes _Application, _Document and Documents. I tryied to import the .h files but don't work.
I don't understand.
Thanks

David Crow9-Aug-04 5:12

9-Aug-04 5:12

tiziacaia wrote:
I tryied to import the .h files but don't work.

You should have included, not imported, msword9.h, preferably in the project's stdafx.h file.

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

tiziacaia9-Aug-04 5:22

9-Aug-04 5:22

I write "import" but i used correctly the "include". I don't have msword9.h but only CApplication.h, CDocuemnts.h and CDocuments0.h
I added the .h files like you say in the stdafx.h but don't work.

David Crow9-Aug-04 5:31

9-Aug-04 5:31

When you added Word's type library, it would have created a .h and a .cpp file and added those to the project. Can you confirm this?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

tiziacaia9-Aug-04 5:36

why world so cruel for sleep( ) ing..??

9-Aug-04 5:36

Yes, but the created files are only: CApplication.h,CDocuments.h and CDocument0.h

TssPrasad8-Aug-04 23:21

TssPrasad

8-Aug-04 23:21

Hi all,

Is Sleep( )ing too dangerous..??I am using to delay an execution of thread by using Sleep(50) for 50 milli seconds..But my world doesn't seem to accept it..

They call it a bad practice..is it so..??why is it like that..??

Is there anything better than Sleep( )ing in Life..Would be great if you can tell me anyone keeping Multithreaded application in view..

Now where in MSDN or in any standard doc. I could find anything so bad about it..only thing is it's suggested not to sleep when in creating Window UI's it's used..right..??

Re: why world so cruel for sleep( ) ing..??

Antti Keskinen8-Aug-04 23:29

Antti Keskinen

8-Aug-04 23:29

When a thread is suspended by using Sleep(), it no longer reacts to any Windows messages.

If the thread is running a window object (GUI, for example), then the window will stop responding to mouse clicks or other events when the thread is suspended. As such, the program appears as if it had crashed, although it is just suspended. Using Sleep() on threads that are not crucial to UI or your program is a working practise. But you should avoid Sleep() with UI threads.

-Antti Keskinen

----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.

Re: why world so cruel for sleep( ) ing..??

Anonymous9-Aug-04 5:55

Anonymous

9-Aug-04 5:55

Can hackers access our programs easily when using the sleep()? Would it be OK to use sleep() for private programs that will not be released to the public?

why world so cruel for sleep( ) ing..??

TssPrasad8-Aug-04 23:20

TssPrasad

8-Aug-04 23:20

why world so cruel for sleep( ) ing..??

Shiva Prasad8-Aug-04 23:20

Shiva Prasad

8-Aug-04 23:20

Database Records

Neelesh K J Jain8-Aug-04 23:10

Neelesh K J Jain

8-Aug-04 23:10

hello Friends,
I have got a table of following structure
Tran_ID Long Integer
Date Date
Type Text
Tran_Number Number
Amount Double
Quantity Double
Dr Text
Desc Memo

The above table is Created in Ms-Access, The main problem is when i use the Select query by using CRecordset object which is opened
CDatabase db;
db.Open("DSN=Test",0);
CRecordset rs(&db);
CString query;
query="Select * from Trans where Date = '08-06-2004'";
rs.Open(CRecordset::snapshot,_T(query));

I am getting an error, Data type mismatch in criteria when the query is to be executed, but where as When i used any other query which can easily match the text, its getting success, only problem with date,
thanking you,
Neelesh K J Jain.

Re: Database Records

Antti Keskinen8-Aug-04 23:24

Antti Keskinen

8-Aug-04 23:24

Hello Neelesh,

Take the query string, and open up Access (if you have it). Then execute the query as is and see the results. I suspect that there is a syntax error in the SQL statement.

Found here at Code Project, there is an ODBC Query Tool available for download that is extremely effective in creating working ODBC query strings that fetch data correctly. What I mean by this is that it is most probable that the query string you create contains a syntax error. The quotes and double-quotes that are required by some SQL query strings are problematic when it comes to C++.

First, using ODBC Query Tool, create a query string that fetches the data properly. Then copy this string as is into your C++ code. If you need double-quotes, place a forward-slash '/' in front of them on the string, so they are treated properly.

-Antti Keskinen

----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.

Re: Database Records

David Crow9-Aug-04 2:52

How to call different dialog box on a property sheet clicking on OK buttton?.

9-Aug-04 2:52

Neelesh K J Jain wrote:
query="Select * from Trans where Date = '08-06-2004'";

You are not taking the time into consideration, nor are you using the # symbol for date types. You'll need something like:

query = "SELECT * FROM Trans WHERE Date BETWEEN #08/06/2004 00:00:00# AND #08/06/2004 23:59:59#";

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Database Records

Neelesh K J Jain8-Aug-04 23:05

Neelesh K J Jain

8-Aug-04 23:05

hello Friends,
I have got a table of following structure

Rajesh_K_Sharma8-Aug-04 22:39

Rajesh_K_Sharma

8-Aug-04 22:39

Hi

I made three property pages on a property sheet.
Page1,Page2 and Page3.
A property sheet contains three button (OK, Cancel and Apply Buttons).
I also made three - dialog box.
Dialog1,Dialog2 and Dialog3.

Now ,I would like to do that when we select page1 and click on OK button on
a property sheet then dialog1 should be called.Similarly,when we select page2 and click
on OK button on a property sheet then dialog2 should be called. Similarly on page3.

I wrote some code:-

BOOL CPropertySheet::OnCommand(WPARAM wParam, LPARAM lParam)
{

if (LOWORD(wParam)==IDOK) {
CPage1* page1;
page1=(CPage1*)GetPage(0);
page1->UpdateData(TRUE);
CDialog1 dlg1;
dlg1.DoModal();
page1->UpdateData(TRUE);

CPage2* page2;
page2=(CPage2*)GetPage(1);
page2->UpdateData(TRUE);
CDialog2 dlg2;
dlg2.DoModal();
page2->UpdateData(TRUE);

CPage3* page3;
page3=(CPage3*)GetPage(2);
page3->UpdateData(TRUE);
CDialog3 dlg3;
dlg3.DoModal();
page3->UpdateData(TRUE);

return TRUE;
} else

return CPropertySheet::OnCommand(wParam, lParam);

}

What should I write the code ?

Any help appreciated .

rajesh

Re: How to call different dialog box on a property sheet clicking on OK buttton?.

David Crow9-Aug-04 3:00