| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error trying to close down dbase IV file used for input to excel
I am getting errors trying to close down a dbase file.
In the code below: at the line Windows(filename).activate I get a Run-time error '9' subscript out of range. I think that is because windows only works on .xls files but that is only a guess on my part. at the line Filename.Delete I get a run-time error '424' subscript out of range. I beleive somehow I need to close the file before deleting it. Thanks in advance for any help. Don Workbooks.Open Filename:="C:\My Documents\export.dbf" Filename = "C:\My Documents\export.dbf" ' do stuff here Application.DisplayAlerts = False Windows(Filename).Activate ' Close down imported file before exiting ActiveWorkbook.Close Application.DisplayAlerts = True Filename.Delete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error trying to close down dbase IV file used for input to excel
Windows(Filename).Activate
Can't have the path included: Filename = "export.dbf" Windows(Filename).Activate may work ok. don wrote: I am getting errors trying to close down a dbase file. In the code below: at the line Windows(filename).activate I get a Run-time error '9' subscript out of range. I think that is because windows only works on .xls files but that is only a guess on my part. at the line Filename.Delete I get a run-time error '424' subscript out of range. I beleive somehow I need to close the file before deleting it. Thanks in advance for any help. Don Workbooks.Open Filename:="C:\My Documents\export.dbf" Filename = "C:\My Documents\export.dbf" ' do stuff here Application.DisplayAlerts = False Windows(Filename).Activate ' Close down imported file before exiting ActiveWorkbook.Close Application.DisplayAlerts = True Filename.Delete -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to save an excel file to dBase format? | Excel Discussion (Misc queries) | |||
| why excel 2007 does not support dbase file type? | Excel Discussion (Misc queries) | |||
| How to Export datas from Excel cells to another excel/dbase file | Excel Discussion (Misc queries) | |||
| Saving Excel file in DBase IV format | Excel Discussion (Misc queries) | |||
| Issues with opening DBF (dBase) file in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
