0 is for form 1, 1 for form 2 & so on...
if you know form name then you can use it directly...
IE.document.forms("myform")(0).submit
Cheers!!
On Wed, Feb 11, 2015 at 12:16 PM, Mandeep Baluja
wrote:
> Absolutely correct but i was using form 1 that's why it is giving error
> could you please let
Absolutely correct but i was using form 1 that's why it is giving error
could you please let me know why 0 is used. for form.
On Wednesday, February 11, 2015 at 10:20:23 AM UTC+5:30, Mandeep Baluja
wrote:
>
> how to click this
>
>
>
> * button i tried many
> thing but unsuccesful.Regards.Mand
Hi
I have found very simple way to submit button, i assume you are using IE
automation & there is only one form on webpage:
IE.document.forms(0).submit
'here IE is your InternetExplorer.Application
Cheers!!
On Wed, Feb 11, 2015 at 10:20 AM, Mandeep Baluja
wrote:
> how to click this
>
>
>
>
Hi Guys,
Please help me find a solution to this challenge. I need a formula that
helps me fill multiple cells in a different worksheet by entering a value
in a single cell in another worksheet. For instance, I have a cell with a
value of 5000 in one worksheet and I need a formula to populate 9
how to click this
* button i tried many
thing but unsuccesful.Regards.Mandeep *
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
How's this?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
Hello Experts,
i am developing a form and i need assistance with a code, i can do it with
a formula but i dont like the final results because of the final output i
want. Basically in sheet2, when i click on setup and i choose a start year
for instance 2006 and specify the number of years for histo
Hi Friends,
My company wants to me learn SAS, so that i need some information about the
same.
Can anyone tell me about SAS software. why we use SAS, what is difference
beetween Excel and SaS.
If anyone have a Live example of SAS, i mean the dataset, summary or any
other reports which created in
Welcome Christos...
On Tuesday, February 10, 2015 at 4:52:30 PM UTC+5:30, Christos Alekopoulos
wrote:
>
> Hi Michael,
>
> That works perfect thank you!!!
>
> Cheers,
> Christos
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offi
Thanks Vabz but I don't want just a function that replaces any value. My
post explains fully what I needed!
Cheers
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexce
>
> In fact I used a slightly different code... It finds a row with a certain
> value (the risk id for my case) and replace another value in the same row
> that I set. I hope I this code helps others as well! Thank you again for
> all your help and feedback!!!
>
Sorry for the comments but I t
Christos, you could have achieved this by following simple line too:
Sub Macro1()
Prompt = "What is the original value you want to replace?"
Title = "Search Value Input"
Search = InputBox(Prompt, Title)
Prompt = "What is the replacement value?"
Title = "Search Value Input"
Replacement = InputBox(P
Hi Michael,
That works perfect thank you!!!
Cheers,
Christos
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread ti
Nice :-)
On Mon, Feb 9, 2015 at 7:43 PM, Vaibhav Joshi wrote:
> FYI choose formula:
>
>
> =CHOOSE(Month,'Attn. Sheet.xlsx'!Jan,'Attn. Sheet.xlsx'!Feb,'Attn.
> Sheet.xlsx'!Mar,'Attn. Sheet.xlsx'!Apr,'Attn. Sheet.xlsx'!May,'Attn.
> Sheet.xlsx'!Jun,'Attn. Sheet.xlsx'!Jul,'Attn. Sheet.xlsx'!Aug,'Att
14 matches
Mail list logo