I'm having problems getting my spreadsheets converted to .csv. I've created a single record in the People.xls. When I run the Convert CSV Files from the DMT, the DOS window opens, begins converting the Company.xls, and hangs. Two windows in Excel open: Company.xls and the CompanyConvertCSV. The Company.xls has a Visual Basic Debugger open, with the error defined at the last line:
Workbooks.Open Filename:=def_path + "Company.xls" ' ' For i = 2 To Sheets.Count Sheets(i).Activate Rows("1:2").Delete Shift:=xlUp Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal I can walk the entire process by manually closing the Excel windows (the process runs on the next Excel file, then hangs again, etc.), but I need to fix this. Has anyone seen this before? Thanks, Rick _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"