View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Reading registry with Excel

"Alesandro Senerchia" wrote in message
...
I have an excel macro, that reformats a xls file to a csv (given it a
name
and a saving path, -- later on will need to write to the reg to be able
to
pick up value for another app).
For the moment, the path and filename are hard coded in the code, i would
need it more flexible has diff users have diff requests for
filename/path.

What code can I use to retrieve or write to registry keys?


Hi Alex,

Look at the SaveSetting and GetSetting statements in VBA help. These
will allow you to do what you want.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm