View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Childs Tim Childs is offline
external usenet poster
 
Posts: 128
Default Confirm Open After Download - Reading Registry

Bill

Thanks for the response on this which I will pursue. I don't want to change
the flag setting in fact, I simply want to be able to "read" it.

Incidentally, the findlinks.xla is a great boon

Tim

Also in Oxford, UK (on weekdays, anyway)!


"Bill Manville" wrote in message
...
Tim Childs wrote:
In Windows explorer, it is possible to set a flag under
View-Options_filetypes to determine if a CSV file (or any
other type of file) opens automatically on being
downloaded.

You mean the "Confirm open after download" flag?

Experiment suggests that

HKEY_CLASSES_ROOT\Excel.CSV\EditFlags has value 65536 if the flag is
NOT set (and 0 if it is). I suspect it might be a bit-map and so you
should probably only change the 1 bit in the key value.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup