Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can not open *WKS: blocked by your registry policy setting | Setting up and Configuration of Excel | |||
unable to open excel attachment, download won't open | New Users to Excel | |||
How to confirm the open dialogue box by using macro coding? | Excel Worksheet Functions | |||
where is confirm conversion at open in Excel 2007? ('03 tools opt | Excel Discussion (Misc queries) | |||
Error 1402. Setup cannot open the registry key. | Excel Discussion (Misc queries) |