overwriting existing document w/ Excel
overwriting existing document w/ Excel
- Subject: overwriting existing document w/ Excel
- From: Yosemite <email@hidden>
- Date: Tue, 24 Jul 2001 09:52:16 -0800
i lost the original thread for this ...
tell application "Microsoft Excel"
try
set AlertBeforeOverwriting to false
set DisplayAlerts to false
Create New Workbook
set Value of Cell "A1" to "nellA hciR"
Save ActiveWorkbook In "machd0:desktop folder:temp:xcel1"
Close ActiveWorkbook
set DisplayAlerts to true
set AlertBeforeOverwriting to true
on error errMsg number errNum
display dialog errNum
end try
end tell
-- hcir
mailto:email@hidden