Write to Lotus spreadsheet from FoxPro

[vmikeydet]

I'm trying to use Windows script hosting from a Visual FoxPro application to write data to a Lotus 123 spreadsheet. I can use the technique to write to a Notepad or MS Word file, but it is not working with either Excel or Lotus. Here is the script I am running in FoxPro:

DECLARE Sleep IN Win32API;
integer dwDelay

oShell = CREATEOBJECT("WScript.Shell&quot
oShell.run("d:\projects\emc501\admin\errorlog.123&quot
oShell.AppActivate('1-2-3')
=Sleep(100)
oShell.SendKeys("Test&quot
oShell = .null.

Instead of writing "test" to the spreadsheet, it is being written to the FoxPro window.

Thanks for any help.

Steve

 

[danceman]

Have you tried making an object of Lotus, like Wordor Excel? I use micorsoft object browser to find the methods and properties of such objects.

Attitude is Everything

 

[white605]

try posting the vfp3 and up forum...there are lots of good people in there