View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John.Greenan John.Greenan is offline
external usenet poster
 
Posts: 175
Default Need to make a vbs, but dont know how....

A few questions:
What setting do you want to change in Excel?
Do you want to create a VBScript? [Note - vbscript is nothing to do with
Excel and the vba language that Excel uses]

Post back with some answers and I'll try to help

--
www.alignment-systems.com


"Duncan" wrote:

Hello All,

I need to create a VBS that will change the setting in excel (ignore
other applications) to false, but I dont really know how to do this.

I have played around with a .inf file someone posted on here but cannot
get that to work either....it says installation failed..(ill put it
below, in case it can be changed to make it work but I dont know how to
do that either!)


' [Version]
Signature=$CHICAGO$


' [DefaultInstall]
BitReg=Bit.Settings


' [Bit.Settings]
HKCU,Software\Microsoft\Office\10.0\Excel\Options, Options,0x00000001,0x40,0


(the above is exactly as I have it, i put the commas in because thats
what I thought was going wrong, but apparantly not.

Any help at all would be much appreciated.

Duncan