Writing formulas in Excel from VBA

[pmonett]

Hello,

I am working in Lotus Notes to collate information from a database and write it in an Excel spreadsheet for easy reference.

I know how to open an Excel sheet and fill it in, but it would be nice if the user did not need to fill in the Total formulas himself.

I have tried to write in the formulas using the

"ActiveSheet.cells ="

reference, but even if I put an equal sign in front of the formula, the formula just shows up as text.

I've scoured the VBA help file, but I couldn't find anything there, neither in MS online help pages.

Can someone give me a hand here ?

Thanks in advance !

 

[Targol]

you should use the "formula" property of your cell. Water is not bad as soon as it stays out human body ;-)

 

[pmonett]

Indeed ! How simple.

Thank you Targol !

 

[lespaul]

pmonett,

I was amazed to find a reference to Lotus Notes in the VBA Forum. I too have used Excel and Word to link with Notes for printing and reporting! Much neater and printer friendlier than Notes printing! Good luck!

Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned