ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Confirm Open After Download - Reading Registry (https://www.excelbanter.com/excel-programming/283848-confirm-open-after-download-reading-registry.html)

Tim Childs[_6_]

Confirm Open After Download - Reading Registry
 
Hi

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.

Is this stored in the registry and can its value be "read"
in VB?

THANKS

Tim

Tim Childs

Confirm Open After Download - Reading Registry
 
Hi



Can anyone get me started on this?



Or tell me where I should look for help?



Or maybe the question needs clarification?



Thanks



Tim





"Tim Childs" wrote in message
...
Hi

In Windows explorer, it is possible to set a parameter under
View-Options_filetypes to determine if a CSV file (or any
other type of file) opens automatically on being
downloaded.

Is this stored in the registry and can its value be "read"
in VB?

THANKS

Tim




Bill Manville

Confirm Open After Download - Reading Registry
 
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


Tim Childs

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





All times are GMT +1. The time now is 10:35 AM.

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