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

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