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

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

Setting: application.ignoreremoterequests = false

vbscript: yes, because if i do it simply via a macro then users wouldnt
be able to perform this by clicking on a shortcut, cos it wouldnt load
the shortcut up with the setting set to true so catch 22 situation!

Q: I didnt know vbscript was different to vba, just thought it was a
differant version of the same thing because the commands appeared
similar to me....shows my ignorance really doesnt it!

Any help would be much appreciated.

Duncan




John.Greenan wrote:

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

Ok, so create a script like this (I am not using an editor, so you'll have to
verify the syntax yourself)

--------------------------------------------------------------------------------
Dim myExcelApplication

set myExcelApplication = GetObject("Excel.Application")

myExcelApplication.ignoreremoterequests = false

myExcelApplication.quit
set myExcelApplication = nothing
--------------------------------------------------------------------------------

Have a go with that...

If this helps then please mark the reply as helpful




--
www.alignment-systems.com


"Duncan" wrote:

Setting: application.ignoreremoterequests = false

vbscript: yes, because if i do it simply via a macro then users wouldnt
be able to perform this by clicking on a shortcut, cos it wouldnt load
the shortcut up with the setting set to true so catch 22 situation!

Q: I didnt know vbscript was different to vba, just thought it was a
differant version of the same thing because the commands appeared
similar to me....shows my ignorance really doesnt it!

Any help would be much appreciated.

Duncan




John.Greenan wrote:

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

John / Anyone,

Im not really sure that I can verify the syntax and im getting a syntax
error on line 2.

I dont think I have a vbscript editor, I usually use notepad, but I
pasted it into Excel vba and it didnt show up red.

Confused........

Can you advise any further?

Duncan


John.Greenan wrote:

Ok, so create a script like this (I am not using an editor, so you'll have to
verify the syntax yourself)

--------------------------------------------------------------------------------
Dim myExcelApplication

set myExcelApplication = GetObject("Excel.Application")

myExcelApplication.ignoreremoterequests = false

myExcelApplication.quit
set myExcelApplication = nothing
--------------------------------------------------------------------------------

Have a go with that...

If this helps then please mark the reply as helpful




--
www.alignment-systems.com


"Duncan" wrote:

Setting: application.ignoreremoterequests = false

vbscript: yes, because if i do it simply via a macro then users wouldnt
be able to perform this by clicking on a shortcut, cos it wouldnt load
the shortcut up with the setting set to true so catch 22 situation!

Q: I didnt know vbscript was different to vba, just thought it was a
differant version of the same thing because the commands appeared
similar to me....shows my ignorance really doesnt it!

Any help would be much appreciated.

Duncan




John.Greenan wrote:

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

I have just changed line 2, it now looks like:

Dim myExcelApplication
Set XLSA = GetObject(, "Excel.Application")
XLSA.IgnoreRemoteRequests = False
XLSA.Quit
Set XLSA = Nothing

And now it gives the answer, "activex component cannot create object"

.....I have very limited knowledge of vbs files, it worked when I ran it
through a macro....

Duncan



Duncan wrote:

John / Anyone,

Im not really sure that I can verify the syntax and im getting a syntax
error on line 2.

I dont think I have a vbscript editor, I usually use notepad, but I
pasted it into Excel vba and it didnt show up red.

Confused........

Can you advise any further?

Duncan


John.Greenan wrote:

Ok, so create a script like this (I am not using an editor, so you'll have to
verify the syntax yourself)

--------------------------------------------------------------------------------
Dim myExcelApplication

set myExcelApplication = GetObject("Excel.Application")

myExcelApplication.ignoreremoterequests = false

myExcelApplication.quit
set myExcelApplication = nothing
--------------------------------------------------------------------------------

Have a go with that...

If this helps then please mark the reply as helpful




--
www.alignment-systems.com


"Duncan" wrote:

Setting: application.ignoreremoterequests = false

vbscript: yes, because if i do it simply via a macro then users wouldnt
be able to perform this by clicking on a shortcut, cos it wouldnt load
the shortcut up with the setting set to true so catch 22 situation!

Q: I didnt know vbscript was different to vba, just thought it was a
differant version of the same thing because the commands appeared
similar to me....shows my ignorance really doesnt it!

Any help would be much appreciated.

Duncan




John.Greenan wrote:

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