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