forgot to mention,
im using Excel 2000


"Alesandro Senerchia" wrote in message news:...
Hello to all,

hope that somebody can help me with this.

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?

Thank you in advance for your help.

Alex

"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