Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Handle: File is already open.
I have the following script for adding a workbook. What error handling can I
add so that it tells the user the file name they try to create already exists and is open. Then exits the program. I would liek to use a more specific method than "On error goto ErrHandle" Set ReportBook = Workbooks.Add() Set ReportPage = Worksheets.Add ReportPage.Name = "Report" Do fName = Application.GetSaveAsFilename(Title:="Specify Report Name") Loop Until fName < False If UCase(Right(fName, 4)) < ".XLS" Then fName = fName + "xls" ReportBook.SaveAs Filename:=fName |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
EXCEL:Can't open any file without error saying it's ALREADY open??? | Excel Worksheet Functions | |||
How to handle error 8007000e Memory Error | Excel Programming | |||
Handle password for open workbook? | Excel Programming | |||
open file file then error message | Excel Discussion (Misc queries) |