Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel xls files open as Machine Code | New Users to Excel | |||
Macro code error; machine dependent | Excel Worksheet Functions | |||
charting code hanging up | Excel Programming | |||
code is not working on another machine | Excel Programming | |||
Excel 2000 Hanging while reading large file with Line Input | Excel Programming |