Re: Line of code hanging up on one machine???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
>
.

Relevant Pages

  • Re: virus extensions
    ... I'm checking tar, tgz, gz, zip, exe, and vbs. ... >association with any nonexistant "file extension." ... But DOS/Windows machines will not execute an executable which ... Windows machines are set by default not to show the extension, ...
    (comp.os.linux.security)
  • CS file extension not registered with aspnet_isapi.dll
    ... I looked first into the machine.config file, and there the .cs extension was ... Then I looked into Internet Service Manager, into the Application Mappings ... doesn't correctly register ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ADSL Filters why are they neccessary?
    ... > at every extension? ... including fax machines (which uses the voice side of the line) and Sky Digibox ...
    (uk.telecom)
  • Re: free-weights vs Life-Fitness machines
    ... >>> is it true that machines are dangerous? ... > full extension. ... in most of the less expensive leg ... the weight to get the weight to the top. ...
    (misc.fitness.weights)
  • Re: Auto Recovery wont work
    ... You're undoubtedly right with the extension, I was only noticing quite often ... Microsoft MVP - Excel ... If it is there simply add an .xls extension ... When I restarted my computer and opened Excel, the recovery panel won't ...
    (microsoft.public.excel)