Forum Home
Press F1
Thread ID: 6444	2000-11-11 04:27:00	Microsoft Excel	Guest (0)	Press F1

Post ID	Timestamp	Content	User
7069	2000-11-11 04:27:00	What Visual Basic code should I use to test if a Workbook is currently in use and amended before attempting to open that workbook. I am using the following code at present but if the Workbook is currently being amended I get a Windows dialog asking if I want to discard the current changes. Application.Workbooks.Open 'c:\My Documents\Spread\Films chart.xls' Sheets('By date').Select Range('A2').Select Selection.Sort Key1:=Range('A2'), Order1:=xlAscending, Key2:=Range('B2') _ , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom	Guest (0)
1