Still need help....

[msawaya]

I don't have autosave, and I can't install it because I no longer have the disk. Anyway, so is there a way to save the excel document using the vb editor? And how do I know that whenever the excel document opens that the vb code will even be activated. Do I have to program that into the code as well?

[Iouri]

Using Vb code you can save Ecell as

xlapp.activeworksheet.SaveAs "C:\Whatever"

of course you have to set xlapp object and the other juzz

Iouri Boutchkine
iouri@hotsheet.com