Line of code hanging up on one machine???

[Don G - ExcelForums.com]

Hi Folks,

Why would the line of code below hang on one machine but run smoothly
on another machine? Both machines have WinXP and both have Excel
2000.


Workbooks("EstimatedBillingForms4").Close
SaveChanges:=False


TIA,

Don G

[Ivan F Moala]

Hi Don, when you say hang do you mean the application stops responding ? Or do you get a syntax error ?
If the latter then one machine may require the file extension be added to the workbook name eg

Workbooks("EstimatedBillingForms4.xls").Close SaveChanges:=False

I believe that this maybe because MS Excel takes the workbook name from the Explorers default view i.e Show/Hide file extension.

[Dave Peterson]

Try adding .xls to the workbook name:

Workbooks("EstimatedBillingForms4.xls").Close SaveChanges:=False

There's a windows setting for each pc to hide/show extensions. Depending on
that setting, specifying the workbook name without the extension can confuse
excel.

I've never seen it fail if I always included the extension.

"Don G - ExcelForums.com" wrote:
>
> Hi Folks,
>
> Why would the line of code below hang on one machine but run smoothly
> on another machine? Both machines have WinXP and both have Excel
> 2000.
>
>
> Workbooks("EstimatedBillingForms4").Close
> SaveChanges:=False
>
> TIA,
>
> Don G

--

Dave Peterson

[Don]

Thanks Dave.....As soon as the office opens up, I'll give that a try and post
back if that's the cure.

Don

"Dave Peterson" wrote:

> Try adding .xls to the workbook name:
>
> Workbooks("EstimatedBillingForms4.xls").Close SaveChanges:=False
>
> There's a windows setting for each pc to hide/show extensions. Depending on
> that setting, specifying the workbook name without the extension can confuse
> excel.
>
> I've never seen it fail if I always included the extension.
>
> "Don G - ExcelForums.com" wrote:
> >
> > Hi Folks,
> >
> > Why would the line of code below hang on one machine but run smoothly
> > on another machine? Both machines have WinXP and both have Excel
> > 2000.
> >
> >
> > Workbooks("EstimatedBillingForms4").Close
> > SaveChanges:=False
> >
> > TIA,
> >
> > Don G
>
> --
>
> Dave Peterson
>

[Don]

Dave,

That did the trick. Program works great on both machines now just by adding
the .xls extension as you suggested.

Thanks very much for your help,

Don

"Dave Peterson" wrote:

> Try adding .xls to the workbook name:
>
> Workbooks("EstimatedBillingForms4.xls").Close SaveChanges:=False
>
> There's a windows setting for each pc to hide/show extensions. Depending on
> that setting, specifying the workbook name without the extension can confuse
> excel.
>
> I've never seen it fail if I always included the extension.
>
> "Don G - ExcelForums.com" wrote:
> >
> > Hi Folks,
> >
> > Why would the line of code below hang on one machine but run smoothly
> > on another machine? Both machines have WinXP and both have Excel
> > 2000.
> >
> >
> > Workbooks("EstimatedBillingForms4").Close
> > SaveChanges:=False
> >
> > TIA,
> >
> > Don G
>
> --
>
> Dave Peterson
>