# open *.bak as if *.csv

In calc basic, yesterday's quotes file has been moved from quotes.csv to quotes.bak.

The same code that opened the file opened it into a calc file, now that the extension has changed it is opened as a write text file.

Is there a way to force calc to open that csv file with an extension of bak as a calc file?

Thanks, Mike

edit retag close merge delete

If I do open a csv file having the extenstion .bak from Calc using File -> Open, I do get the csv import dialog. In that sense your question is unclear to me.

(Not understanding at all why a file should change its extrension for no reason)

( 2021-02-18 23:09:34 +0200 )edit

The same code

Show the code.

( 2021-02-19 05:53:53 +0200 )edit

File -> Open is not a Basic operation but using the mouse, Yes?

I import some data then change the extension because Yahoo's export function balks if there is already a file called quotes.csv.

Now if I want to go back into that file now named quotes.bak from Basic the file is opened as a write file not calc.

As you see it's not 'for no reason', just one you didn't understand.

Do you know how to do what I'm asking?

Thanks, Mike

( 2021-02-27 04:31:46 +0200 )edit