frx to word 2

[keepingbusy]

Hi All
Just been reading the thread at

http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/184

and having downloaded frx2word etc I'm trying to find out what I do next!
I've tried some of the examples in the thread but they all come up with error messages. Dont know if I'm missing something here, but do I add the class to the form (and how do you do it) or add it to an APP? I'm using VFP6 and would be grateful for any guidance
Many thanks as always
KB

When everything else is said and done, there will be nothing else to say or do

 

[keepingbusy]

Thanks also to stewartUK
KB

When everything else is said and done, there will be nothing else to say or do

 

[Mike Gagnon]

keepingbusy

Another thing to point out is if you put :

CREATE CURSOR myCursor (name c(10),address c(10))
INSERT INTO myCursor (name,address) VALUES ("MIke","123&quot
INSERT INTO myCursor (name,address) VALUES ("John","321&quot
GO top
CREATE REPORT c:\myreport2 from myCursor
SET CLASSLIB TO d:\frx2word\msoexp.vcx
oRep = CREATEOBJECT("frx2word&quot
orep.html_filename="myDoc.htm"
oRep.doc_filename="myDoc.doc"
orep.reportform("c:\myReport2.frx&quot

You will end up with both documents HTML and Word.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[keepingbusy]

Thanks a million Mike
KB

When everything else is said and done, there will be nothing else to say or do

 

[rickesilaw]

Hi Everyone

Thanks Mike and Fabiov and StewartUK - we tested this (with set relations etc.) and output worked fine. I especially like the html. The word output leaves a little to be desired as it is output in textbox format so not really useful. However if you release the class when done, everything is released from memory and no memory leaks. Now all we need is a nice preview (like FRX2ANY has), output to excel, rtf, etc. and life if beautiful!

 

[keepingbusy]

Hi Mike

Tried your code and in particular the latter of the two with the HTML conversion and have to say it works a treat (at last!!)
I'm just going to manipulate it now so it works with a table but just wanted to say thanks again for all your time and I suppose it's easy when you know how!

Take care and kindest regards to you
KB

PS: What a great forum this is

When everything else is said and done, there will be nothing else to say or do

 

[keepingbusy]

Hi Mike
Having trouble with my last posting....

Sometime ago you posted the below which works perfectly

CREATE CURSOR myCursor (name c(10),address c(10))
INSERT INTO myCursor (name,address) VALUES ("MIke","123&quot
INSERT INTO myCursor (name,address) VALUES ("John","321&quot
GO top
CREATE REPORT c:\myreport2 from myCursor
SET CLASSLIB TO d:\frx2word\msoexp.vcx
oRep = CREATEOBJECT("frx2word&quot
orep.html_filename="myDoc.htm"
oRep.doc_filename="myDoc.doc"
orep.reportform("c:\myReport2.frx&quot

How can I use the field names and data from my DBF instead of CREATE CURSOR myCursor (name c(10),address c(10))?
INSERT INTO myCursor (name,address) VALUES ("MIke","123&quot
INSERT INTO myCursor (name,address) VALUES ("John","321&quot

What I'm doing is this:

tempfile=SYS(3)
USE MYFILE
copy stru to tempfile+'.dbf' with CDX
USE tempfile+'.dbf' EXCL && Etc etc

Then the records not required are sifted out such as:
IF recno()>200
DELE
ENDI

So then I'm left with the only the records we need. Obviously from this point I want to be able to send this info from this DBF to a word document

Any suggestions please?

Many thanks
KB

When everything else is said and done, there will be nothing else to say or do

 

[ramani]

HI

Instead of
tempfile=SYS(3)
USE MYFILE
copy stru to tempfile+'.dbf' with CDX
USE tempfile+'.dbf' EXCL && Etc etc

Then the records not required are sifted out such as:
IF recno()>200
DELE
ENDI


SELECT * FROM myFile INTO CURSOR SYS(3) ;
WHERE myConditions
LOCAL lcAlias
lcAlias = ALIAS()

LOCATE
CREATE REPORT c:\myreport2 from (lcAlias)
SET CLASSLIB TO d:\frx2word\msoexp.vcx
oRep = CREATEOBJECT("frx2word&quot
orep.html_filename="myDoc.htm"
oRep.doc_filename="myDoc.doc"
orep.reportform("c:\myReport2.frx&quot




ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rickesilaw]

Posts like this are why I love this site. Keepingbusy - I hope you contributed!

 

[keepingbusy]

Hi Ramani
Thanks for the info, I'm grateful to you

Hi Rickesilaw
I have made several contributions but have to say I'm not as good as some of the experts in this forum!

Thanks again
KB

When everything else is said and done, there will be nothing else to say or do

 

[rickesilaw]

Hey keepingbusy - I meant $$$!