ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open a read-only copy (https://www.excelbanter.com/excel-discussion-misc-queries/116025-open-read-only-copy.html)

grok

Open a read-only copy
 
Hi all,

I have a program which keeps appending to a csv file. Every now and then
I'd like to take a peek at it to see how it's doing. But if I open it with
excel then my program will be unable to write to it.

Of course I can make a copy of the file and open that and delete it later
but that is kind of a pain. I wonder if there is an easier way to open a
read-only copy of a file, maybe with a single click or two?

grok

Allllen

Open a read-only copy
 
in excel do file open

you get the dialogue box

find your file and click on it once

then instead of doing OPEN, have a try at clicking on the little drop-down
arrow next to the work open. from there you can open it as read only
--
Allllen


"grok" wrote:

Hi all,

I have a program which keeps appending to a csv file. Every now and then
I'd like to take a peek at it to see how it's doing. But if I open it with
excel then my program will be unable to write to it.

Of course I can make a copy of the file and open that and delete it later
but that is kind of a pain. I wonder if there is an easier way to open a
read-only copy of a file, maybe with a single click or two?

grok


grok

Open a read-only copy
 
Thanks, Allllen.

"Allllen" wrote:

in excel do file open

you get the dialogue box

find your file and click on it once

then instead of doing OPEN, have a try at clicking on the little drop-down
arrow next to the work open. from there you can open it as read only
--
Allllen


"grok" wrote:

Hi all,

I have a program which keeps appending to a csv file. Every now and then
I'd like to take a peek at it to see how it's doing. But if I open it with
excel then my program will be unable to write to it.

Of course I can make a copy of the file and open that and delete it later
but that is kind of a pain. I wonder if there is an easier way to open a
read-only copy of a file, maybe with a single click or two?

grok



All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com