Hello everyone..
I'm hoping you can help me out. There was an old applixware 4.4.2
spreadsheet that I was able to (with some work) import into a Microsoft
excel 2003 workbook(with only 1 worksheet). I've gotten the formulas
correct (they're supposed to bring in real time information from an external
service through an addin). What I need to do, though is save the worksheet
in the workbook continuously in csv format and ftp the file every 5 minutes.
I've done some coding by using the ontime vba function, and I've also tried
using the windows scheduler to do this but here's the problem with using
both methods: I get an error message from the operating system saying that
I'm basically running out of virtual memory and that it will adjust the
virtual memory automatically. When we used applixware it was on a sun
system, and we got it automated from that end by saving the spreadsheet
every five minutes, then closing the application and reopening at a specific
time to prevent a virtual memory problem then it will restart the saving,
ftping etc. Is there any way to avoid this virtual memory problem? Should I
ignore this? I don't want to have the local machine having to continuously
adjust virtual memory higher and higher and we get into more problems.
Just also wanted to point out that I'd have to also install this on a user
workstation(excel addin communicates with part of a user application) so I'd
like to have it such that there is little performance degregation and little
interaction with the user's desktop. I managed this latter aspect by
setting the application.visible object and property to false and calling a
dos ftp batch file and using the vba shell option vbhide. However, any
other tips to accomplish the above would be greatly appreciated
George
|
Similar Threads
