Re: Excel 2000 & NAV 2003

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

From: Gerry Cornell (gcjc_at_btinternet.com)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 16:15:46 +0100

Jim

Are you saying the "extra save" is an inbuilt "bug"?

I have rechecked through Event Viewer but I cannot see anything suggesting what might have happened. I did look through settings yesterday but I am fairly sure didn't check it. I guess I will never know the cause unless it happens again. 

-- 
~~~~~~
Regards.
Gerry
~~~~~~~~~~~~~~~~~~~~~~~~
FCA
Stourport, Worcs, England
Enquire, plan and execute.
~~~~~~~~~~~~~~~~~~~~~~~~
"Jim Rech" <jrrech@hotmail.com> wrote in message news:%232Xfu4VTEHA.3476@tk2msftngp13.phx.gbl...
> This extra "save?" message you get after saving in CSV format is quite 
> annoying but, as far as I know, it doesn't have anything to do with the 
> "Ignore" option.
> 
> The Ignore option is a user-level setting that gets saved in the registry 
> when Excel exits and restored when Excel opens.  Something set it on 
> obviously. I've seen Excel applications that do this when they are active 
> (my own for example) but these apps should always set it back when they 
> exit.  Some don't, either because the developer overlooked it or because 
> there was a macro error that prevented the normal close code from resetting 
> it.
> 
> -- 
> Jim Rech
> Excel MVP
> "Gerry Cornell" <gcjc@btinternet.com> wrote in message 
> news:eF6qbDVTEHA.1544@TK2MSFTNGP09.phx.gbl...
> Jim
> 
> Spot on. It was selected. Now it works as before. However, I do not 
> recollect checking that option! There was no problem yesterday.
> 
> Recently I have been saving xls files as csv files. Not knowing anything 
> about the option is there any connection? A curiousity I have encountered is 
> that when I am saving as a csv file I seem to be getting an extra invitation 
> to save the file, when I immediately close the CSV file. After I said yes to 
> the extra invitation to save I found it was changing a date format to an 
> unwanted date format ( one I would normally use ) so I have been selecting 
> No. I then close Excel and open the CSV file with Notepad to check that the 
> data is correct for importing into an accounting package.
> 
> Could there be any connection with the procedures described and this latest 
> problem opening XLS files?
> 
> Thank for your help.
> 
> 
> 
> ~~~~~~
> 
> TIA.
> 
> Gerry
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~
> FCA
> 
> Stourport, Worcs, England
> Enquire, plan and execute.
> ~~~~~~~~~~~~~~~~~~~~~~~~
> 
> 
> 
> "Jim Rech" <jrrech@hotmail.com> wrote in message 
> news:eUQGlVUTEHA.332@TK2MSFTNGP11.phx.gbl...
> > Make sure "Ignore other applications" is not selected under Tools, 
> > Options,
> > General.
> >
> > -- 
> > Jim Rech
> > Excel MVP
> > "Gerry Cornell" <gcjc@btinternet.com> wrote in message
> > news:e3mPeuTTEHA.2128@TK2MSFTNGP11.phx.gbl...
> > This morning when I tried to open an Excel file in Windows Explorer (
> > Windows XP / Internet Explorer ) the file did not open. It stalled on 
> > "Virus
> > scan requested". I am using Norton Anti Virus 2003. I still cannot get the
> > files to open that way. The file does open if you load Excel and then 
> > select
> > File, Open and browse to the required file.
> >
> > In the normal way the virus scan can take a moment but I have never
> > encountered this problem before. Earlier I remember that NAV updated
> > definitions to 7 June 2004, which makes me wonder whether the latest 
> > update
> > contains a bug.
> >
> > I am interested in knowing whether any one has encountered a similar 
> > problem
> > today?
> >
> >
> >
> > ~~~~~~
> >
> > TIA.
> >
> > Gerry
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~
> > FCA
> >
> > Stourport, Worcs, England
> > Enquire, plan and execute.
> > ~~~~~~~~~~~~~~~~~~~~~~~~
> >
> > 
> 
>

Relevant Pages

  • RE: WorkbookOpen in COMAddin for CSV-files
    ... I 'm starting to think that the CSV path name may be too long. ... Maybe try putting the CSV file on a short path or Map ... Another possibility is the command line that opens the CSV file is modified. ... Because you are dealing with a CSV file something is opening excel using the ...
    (microsoft.public.excel.programming)
  • Re: CSV Downloads
    ... Open/Save As prompt when you click your bank statement (.CSV file). ... > am presented with a file download box. ... On the XP machine I select CSV and Excel is opened ... >> opens in IE, just do File/Save As and save it as .xls or whatever. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: in which folder can you save a .CSV file?
    ... For sure you saved as an Excel *.xls workbook but get the "cannot access the ... Excel opens and the info gets copied to an Excel worksheet. ... open it and re-save as a *.csv to that folder. ... To save your email address book as a *.CSV file you must do that though Oulook, ...
    (microsoft.public.excel.misc)
  • Re: in which folder can you save a .CSV file?
    ... For sure you saved as an Excel *.xls workbook but get the "cannot access the ... Excel opens and the info gets copied to an Excel worksheet. ... open it and re-save as a *.csv to that folder. ... To save your email address book as a *.CSV file you must do that though Oulook, ...
    (microsoft.public.excel.misc)
  • Re: Excel 2000 & NAV 2003
    ... "Jim Rech" wrote in message ... > when Excel exits and restored when Excel opens. ... > "Gerry Cornell" wrote in message ...
    (microsoft.public.excel.misc)