Line of code hanging up on one machine???
 

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

Line of code hanging up on one machine???
 

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

Line of code hanging up on one machine???
 

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

Line of code hanging up on one machine???
 

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