Posted this somewhere else, but trying to get this solved today, so
hoping I'll get some guidance here:

-----------------
I tried doing a search for this error message, but couldn't find one
related to my problem, so here goes.

Running Excel 2000 here and this macro (snippet below) has been running
fine on several machines. Suddenly, this one machine in particular has
been getting a 1004 Run-time error (in the With statement).

I have an idea what the problem is, but the thing that gets me is this
code still successfully works on several other machines at my work
place.

I know the code is sloppy, as you'll see below. I'm simply trying to
fix something that was already in place before I got here. I'll
definitely clean it up once I get it working.

Any ideas? Thanks in advance for the help.

--------------------------------------------

Sub maketable()


Application.DisplayAlerts = False
Application.ScreenUpdating = False

DirPathVars '< Defines variables

Workbooks.Add
With Application
.DefaultFilePath = DPTH1 & DPTH11 '<<
.SheetsInNewWorkbook = 1
Cells.Select
.StandardFont = "Century Schoolbook"
.StandardFontSize = 8
Selection.ColumnWidth = 2
Selection.RowHeight = 13 '13

End With

.....

--------------------------------------------


Error description:
Run-time error '1004':

Method 'DefaultFilePath' of object '_Application' failed