Need to make a vbs, but dont know how....

[Duncan]

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.Greenan]

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.Greenan]

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
>
>

[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
> >
> >

[John.Greenan]

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
> > >
> > >
>
>

[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
> > > >
> > > >
> >
> >

[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
> > > > >
> > > > >
> > >
> > >