Saving Excel file after use by attachmate
Saving Excel file after use by attachmate
(OP)
Ive got an attachmate macro that reads an excel file, gets the bit of info i need and then writes to the file "Done". But when alls said and done and the macro tries to close the file I get the 'Save' prompt. Is there anyway to get the macro to save the file before closing it therefore eliminating human intervention?
Ive already searched this forum but cant seem to get the '.save' to work.
Ive already searched this forum but cant seem to get the '.save' to work.
"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks
RE: Saving Excel file after use by attachmate
Hi,
In excel, using the appliction object that you have set...
CODE
xl.workbookobject.save
....
Skip,
When a diminutive clarvoyant had disappeared from detention, headlines read...![[tongue] tongue](https://www.tipmaster.com/images/tongue.gif)
Small Medium at Large