Hi

I am trying to read the flag for determining if the
machine will prompt for confirmation when doing a CSV
download.

The code I am using is:

Sub RegRead_new()
Dim wsh As Object
Set wsh = CreateObject("WScript.Shell")
'errors with Type 13 mismatch
MsgBox wsh.RegRead
("HKEY_CLASSES_ROOT\Excel.CSV\EditFlags")
Set wsh = Nothing
End Sub



but it errors

the response from Bill M. on the key location is copied at
the end for info

Any help most welcome

thanks

Tim


"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"