| View previous topic :: View next topic |
| Author |
Message |
bordia
General User
Joined: 24 Jul 2006
Posts: 19
Location: Ratlam MP India
|
 Posted: Mon Aug 07, 2006 8:30 pm Post subject: |
 |
|
Received complete macro by Mail and it's working.
Thanks for giving your valuable time.
Now I think it was good idea to shift from MS to OO since I never received any such quick and prompt help from any one regards to MS problems. Even when I have purchased Licensed Copy of MS, MS itself does not provided this much quick help or support. So its very nice to see you pepoles here at OO.
Thanks once again |
|
| Back to top |
|
 |
pitonyak
Administrator
Joined: 09 Mar 2004
Posts: 3618
Location: Columbus, Ohio, USA
|
|
| Back to top |
|
|
impimp
Newbie
Joined: 15 Dec 2009
Posts: 1
|
| Posted: Tue Dec 15, 2009 3:32 am Post subject: Problems with this macro |
|
|
I used this macro on a WinXP Pro machine and it worked flawlessly, however on trying it out on a Win7 64 bit machine, the moment I go over 20999, I get a message "Did not expect to get here with an err 12".
Lakhs have the same problem (suppose I leave the thousands at <21, and increase the laksh to >20, same problem occurs.
Also, if I run the macro - getThousandspart, I get a "BASIC runtime error Argument is not optional" at line: "If Val(strThousand) <10 Then "
Please let me know where I'm going wrong....
Thank you
Impimp |
|
| Back to top |
|
|
phani000
Newbie
Joined: 23 Jun 2012
Posts: 4
|
| Posted: Sat Jun 23, 2012 8:10 am Post subject: how to use that script from spreadsheet cells |
|
|
Hello ,
I don't have much knowledge in coding these excel macros. by your guidance i added your macro code in my new excel sheet but i am not getting how to make it dynamic means it should take the inputs from spread sheet cells and it should out put in the beside cell |
|
| Back to top |
|
|
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
|
| Back to top |
|
|
phani000
Newbie
Joined: 23 Jun 2012
Posts: 4
|
| Posted: Thu Jun 28, 2012 2:20 am Post subject: |
|
|
| pitonyak wrote: | | Your welcome! |
Hello,
How to make that work for multiple inputs. |
|
| Back to top |
|
|
|
