Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA Code - how to create an entry to registry & write to it and rea

  Asked By: Jaymz    Date: Oct 20    Category: MS Office    Views: 1519
  

For a particular Excel Application, I would like to write to the registry
by adding a brand new data item, and write to this data item of data.
Then, later on retrieve(read) from this data item and do a comparison on the
data.
Does anybody know how to do this VBA code to the registry ?

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Melissa King     Answered On: Oct 20

Check out the GetSetting and SaveSetting commands in the VBA help.
These refer to a specific place in the registry.
HKEY_CURRENT_USER/Software/VB and VBA Program Settings/.

 
Answer #2    Answered By: Clayton Richardson     Answered On: Oct 20

I included both the SaveSetting(VBA) and
GetSetting(VBA) in my Excel Application.

Have you or anybody tried anything w/"Virtual Machine Software" ?
I understand VMWare has several really good "virtualization" software
that will allow you do on a single computer, to test applications with
multiple operating systems; each one having a virtual machine.

I think what you can do with VMWare's Workstation 5.5
and with VMWare's Player, is to configure your computer
to not only have WINXP as the Host OS. You can also
have VMWare Sever as a virtual machine.
Which means, the application  from the WINXP
virtual machine can communicate with
2005 MS SQL Server OS via (queries) in its own
virtual machine.

---( VMWare Workstation 5.5 )---
http://www.vmware.com/products/ws/
---( VMWare Server )---
http://www.vmware.com/products/server/
---( VMWare Player )---
http://www.vmware.com/products/player/

 
Answer #3    Answered By: Adelinda Fischer     Answered On: Oct 20

I included both the SaveSetting(VBA) and
GetSetting(VBA) in my Excel Application.

Have you or anybody tried anything w/"Virtual Machine Software" ?
I understand VMWare has several really good "virtualization" software
that will allow you do on a single computer, to test applications with
multiple operating systems; each one having a virtual machine.

I think what you can do with VMWare's Workstation 5.5
and with VMWare's Player, is to configure your computer
to not only have WINXP as the Host OS. You can also
have VMWare Sever as a virtual machine.
Which means, the application  from the WINXP
virtual machine can communicate with
2005 MS SQL Server OS via (queries) in its own
virtual machine.

---( VMWare Workstation 5.5 )---
http://www.vmware.com/products/ws/
---( VMWare Server )---
http://www.vmware.com/products/server/
---( VMWare Player )---
http://www.vmware.com/products/player/

 
Answer #4    Answered By: Tamara Nguyen     Answered On: Oct 20

Why use VMWare when you can use the MS product instead?

 




Tagged: