Hi,
I wanna make a script that refreshs a document but i don’t know how to pass parameters.How can i do that?
Thankx in advance,
Marco Lopes
Marco A. de M. Lopes
FID - Tel : (21) 559 - 7716
Listserv Archives (BOB member since 2002-06-25)
Hi,
I wanna make a script that refreshs a document but i don’t know how to pass parameters.How can i do that?
Thankx in advance,
Marco Lopes
Marco A. de M. Lopes
FID - Tel : (21) 559 - 7716
Listserv Archives (BOB member since 2002-06-25)
I assume that the parameters you want to ‘pass’ are the prompts?
Using script, create an Application or Document Variable with exactly the same name as the prompt. And set the value to the valaue you want to enter for the prompt.
Ie. if you have a prompt like “1. Today’s date:”
Then in the script:
Dim bovar1 AS BOVariable
Set bovar1 = Application.ActiveDocument.Variables.Add(“1. Today’s date:”)
bovar1.Value = “2000-03-29”
Application.ActiveDocument.Refresh
From: Lopes, Marco BRAZIL-FID [SMTP:Marco.M.Lopes@SHELL.COM.BR] Sent: 29 March 2000 16:18
Sensitivity: Private
Hi,
I wanna make a script that refreshs a document but i don’t know how to pass
parameters.How can i do that?
Thankx in advance,
Marco Lopes
Marco A. de M. Lopes
FID - Tel : (21) 559 - 7716
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)
Create a report that uses a prompt in the condition and call it something like “Variable”.
Put this in your script:
sub main()
Application.variables.Item(“Variable”).value = “XXX” Application.Documents.Item(1).Refresh
end sub()
Listserv Archives (BOB member since 2002-06-25)
Its works :))))
But i couldn’t bypass the prompt’s confirmation (when you choose the correct value for the variable)
Thanks
Marco A. de M. Lopes
FID - Tel : (21) 559 - 7716
From: Kevin Charleston[SMTP:KCharles@SACD.CO.ZA]
Sent: Quarta-feira, 29 de MarÁo de 2000 11:47Sensitivity: Private
I assume that the parameters you want to ‘pass’ are the prompts?
Using script, create an Application or Document Variable with exactly the same name as the prompt. And set the value to the valaue you want to enter
for the prompt.
Ie. if you have a prompt like “1. Today’s date:”
Then in the script:
Dim bovar1 AS BOVariable
Set bovar1 = Application.ActiveDocument.Variables.Add(“1. Today’s date:”)
bovar1.Value = “2000-03-29”
Application.ActiveDocument.Refresh
Listserv Archives (BOB member since 2002-06-25)
Add this as your first line.
Application.Interactive = False
Vasan
Marco.M.Lopes@SHELL.COM.BR on 03/30/2000 12:47:22 PM
cc:
Its works :))))
But i couldn’t bypass the prompt’s confirmation (when you choose the correct value for the variable)
Thanks
Using script, create an Application or Document Variable with exactly the same name as the prompt. And set the value to the valaue you want to enter
for the prompt.
Ie. if you have a prompt like “1. Today’s date:”
Then in the script:
Dim bovar1 AS BOVariable
Set bovar1 = Application.ActiveDocument.Variables.Add(“1. Today’s date:”)
bovar1.Value = “2000-03-29”
Application.ActiveDocument.Refresh
******************************************************************************* Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Ernst & Young LLP
Listserv Archives (BOB member since 2002-06-25)