open *.bak as if *.csv

asked 2021-02-18 20:22:28 +0200

MikeMcClain46 gravatar image

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 flag offensive 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)

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

The same code

Show the code.

gabix gravatar imagegabix ( 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

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