Re: Need to make a vbs, but dont know how....
- From: "Duncan" <duncan.mutchblache@xxxxxxxxxxxxxx>
- Date: 13 Jul 2006 00:53:07 -0700
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
.
- Follow-Ups:
- Re: Need to make a vbs, but dont know how....
- From: Duncan
- Re: Need to make a vbs, but dont know how....
- References:
- Need to make a vbs, but dont know how....
- From: Duncan
- Re: Need to make a vbs, but dont know how....
- From: Duncan
- Re: Need to make a vbs, but dont know how....
- From: John.Greenan
- Need to make a vbs, but dont know how....
- Prev by Date: Re: vlookup type mismatch error
- Next by Date: Re: Need to make a vbs, but dont know how....
- Previous by thread: Re: Need to make a vbs, but dont know how....
- Next by thread: Re: Need to make a vbs, but dont know how....
- Index(es):
Relevant Pages
|
