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
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)
The same code
Show the code.
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