Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

2016-08-31 Thread Dhartikumar Sahu
Please add me my no. 7738363450 On Aug 8, 2016 21:43, "Rajeev Ranjan" <06raj...@gmail.com> wrote: > please add the my number 9811503853 > > On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote: >> >> Creating WhatsApp group for VBA macro... Pls msg me your contact, if you >> wants to jo

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-11-29 Thread Dhartikumar Sahu
Hi I am Dhartikumar Sahu, working in IDBI CAPITAL as a Sr.Database Manager. On 29-Nov-2015 7:52 pm, "GENIUS" wrote: > > Hi everyone > I'm izhar, from Karachi-Pakistan, working as an accountant,47 years old. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Crack Password on MS Excel Template

2014-10-11 Thread Dhartikumar Sahu
Please share the template. On 11-Oct-2014 7:51 am, "Theresita Kirriwom" wrote: > Hi All, > > I have an Excel template file with macros that was created on earlier > version of Excel, the current version cannot work now on Excel 2010 and > user has asked to upgrade the macros to work on Excel 2010

Re: $$Excel-Macros$$ Password Assistance

2013-12-17 Thread Dhartikumar Sahu
esponsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. >

Re: $$Excel-Macros$$ Small doubt in customize ribbon of user define function.

2013-09-26 Thread Dhartikumar Sahu
Write macro in addin file. On 26 Sep 2013 12:29, "अनिल नारायण गवली" wrote: > Dear Friends, > > > I had made a macro, then created a new customized ribbon and assigned > it with this macro. Problem is whenever i click on the ribbon to run > the task then the original file where the macro is create

RE: $$Excel-Macros$$ Date conversion to other format

2013-06-16 Thread Dhartikumar Sahu
Please find attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 14 June 2013 12:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date conversion to other format Hi, I want to convert the date =Today() to

$$Excel-Macros$$ Excel VBA Code for Zip Password

2012-10-07 Thread Dhartikumar Sahu
Hi Experts Kindly provide me a code for Zip file with password Protection. Q. How to Zip the folders with password in excel vba. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point

$$Excel-Macros$$ Urgently multiple if condition required in excel

2012-10-03 Thread Dhartikumar Sahu
3 >75 – 80% 0.8 50.71 >80 – 85% 0.85 59.97 >85 – 90% 0.9 75 >90 – 95% 0.95 37.45 >95 – 100% 1 -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board:

$$Excel-Macros$$ need help to send excel userform data to send email body...

2012-08-06 Thread Dhartikumar Sahu
hi expert guru's I want to send mail my userform data to my group mail id. how to write ma code to send my userform data. awaiting for your prompt reply. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Maf

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

2012-07-16 Thread Dhartikumar Sahu
wrote: >>> >>>> Dear DS, >>>> >>>> Please try it.. >>>> >>>> *Private Sub CommandButton1_Click() >>>> Dim i As Integer >>>> Dim dt As Date >>>> i = Cells(Rows.Count, "A").End(xlUp).

Re: $$Excel-Macros$$ Fwd: urgent required vba code:: 2 list boxes in userform scroll same time.

2012-07-06 Thread Dhartikumar Sahu
; Noorain Ansari > > www.noorainansari.com > > www.excelmacroworld.blogspot.com > > > > -- Forwarded message -- > > From: Dhartikumar Sahu > > Date: Wed, Jul 4, 2012 at 10:22 AM > > Subject:urgent required vba code:: 2 list boxes in userform sc

Re: $$Excel-Macros$$ urgent required vba code:: 2 list boxes in userform scroll same time.

2012-07-06 Thread Dhartikumar Sahu
Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Dhartikumar Sahu > *Sent:* Tuesday, July 03, 2012 11:52 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ urgent required vba code:: 2 list boxes in > userfo

Re: $$Excel-Macros$$ VBA code for Updating External links in excel

2012-07-06 Thread Dhartikumar Sahu
Dear Amit Please write a code in your workbook open event on error resume next ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks Dhartikumar Sahu On Fri, Jul 6, 2012 at 2:21 PM, Amit Gandhi wrote: > Hi Noorain > > I think you haven't understood wh

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-12 Thread Dhartikumar Sahu
$Excel-Macros$$ call addin fuction before activeworkbook > close .. Urgent > > ** ** > > Urgently required code please. > > Sent from BlackBerry® on Airtel > -- > > *From: *Dhartikumar Sahu > > *Sender: *excel-macros@googlegroups.co

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-12 Thread dhartikumar
$$ call addin fuction before activeworkbook close .. Urgent try this one Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Run "'" + "idbiuploader.xlam" + "'!uploadingmodel" End Sub On Tue, Jun 12, 2012 at 4:22 PM, Dhartikumar Sahu

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-12 Thread Dhartikumar Sahu
hi divakar i have a addin whenever i close any workbook , it should be run from addins addinfile name: idbiuploader.xlam macro name : uploadingmodel please help.. Dhartikumar On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey wrote: > > Hi Dharti, > > If i could understand

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-12 Thread dhartikumar
. Sent from BlackBerry® on Airtel -Original Message- From: Dhartikumar Sahu Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 10:46:34 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ call addin fuction before activeworkbook close .. Urgent hi group i

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-12 Thread dhartikumar
Urgently required code please. Sent from BlackBerry® on Airtel -Original Message- From: Dhartikumar Sahu Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 10:46:34 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ call addin fuction before activeworkbook

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-12 Thread dhartikumar
Urgently required code please. Sent from BlackBerry® on Airtel -Original Message- From: Dhartikumar Sahu Sender: excel-macros@googlegroups.com Date: Tue, 12 Jun 2012 10:46:34 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ call addin fuction before activeworkbook

$$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

2012-06-11 Thread Dhartikumar Sahu
hi group i want a vba code for call addin fuction before any workbook close. please provide me code please.. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Re: $$Excel-Macros$$ Introduce Yourself !!

2012-06-10 Thread dhartikumar
Hi everyone My name is Dhartikumar Sahu Lives in Mumbai (Kalyan) Working in IDBI Capital as a Sr. Manager - database equity research I work on (Excel ,Excess and sql) Thans & regards Dhartikumar Sahu Sent from BlackBerry® on Airtel -Original Message- From: Anil Gawli Sender: e

Re: $$Excel-Macros$$ Form tracker and new base

2012-05-18 Thread Dhartikumar Sahu
hi Anil when select the combobox2 (mobile no), it giving error of *Object doesn't support this property or method* . Please look at this. Dhartikumar On Fri, May 18, 2012 at 6:12 PM, Anil Gawli wrote: > first of all extention should be .xlsm > after that right click on that

$$Excel-Macros$$ urgently help required "how to get access field value into word table"

2012-05-14 Thread Dhartikumar Sahu
hi group need urgently help required, to get ACCESS field value into word table. if any sample data that will also very helpful to me. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre

Re: $$Excel-Macros$$ Target.cell issues

2012-02-07 Thread dhartikumar
Copy this code.. Private Sub Worksheet_Change(ByVal Target As Range)   If Target.Column = 8 And Target.Cells = "Billed" Or Target.Cells = "BILLED" Then Target.Offset(0, -2).Value = "Booked"   If Target.Column = 6 And Target.Cells = "Open" Or Target.Cells = "OPEN" Then Target.Offset(0, 2)

Re: $$Excel-Macros$$ unable to open file of 2007 in 2003

2012-02-07 Thread dhartikumar
Send the file. Sent from BlackBerry® on Airtel -Original Message- From: Sanjib Chatterjee Sender: excel-macros@googlegroups.com Date: Wed, 8 Feb 2012 11:37:09 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ unable to open file of 2007 in 2003 Dear Sir,

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread dhartikumar
Congrets noorain Sent from BlackBerry® on Airtel -Original Message- From: Dilip Pandey Sender: excel-macros@googlegroups.com Date: Thu, 2 Feb 2012 09:28:46 To: Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain

Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-24 Thread Dhartikumar Sahu
no 1 was there in group to solve my query On Tue, Jan 24, 2012 at 2:06 PM, Dhartikumar Sahu wrote: > > any solution of my query.. > > > On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu > wrote: > >> thanks priyanka >> >> b

Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-24 Thread Dhartikumar Sahu
any solution of my query.. On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu wrote: > thanks priyanka > > but i need another way > > when i type manually on particular cell , auto pickup related that value. > (e.g. if i type *choc *and click on drop down arrow i

Re: $$Excel-Macros$$ Valiation Query - urgent

2012-01-23 Thread Dhartikumar Sahu
thanks priyanka but i need another way when i type manually on particular cell , auto pickup related that value. (e.g. if i type *choc *and click on drop down arrow it will display the related name of* choc.* On Tue, Jan 24, 2012 at 12:40 PM, PrIyAnKa wrote: > Dear Dhartikumar > > K

$$Excel-Macros$$ Valiation Query - urgent

2012-01-23 Thread Dhartikumar Sahu
Hi Experts I have a data of 1000 names in Sheet2, required dropdown validation in sheet1, cell A1 query: if i type some name on cell A1 then it display only the related on that name. it's an urgent -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * *

$$Excel-Macros$$ Need Animated Text in Userform

2011-12-28 Thread Dhartikumar Sahu
Hi Group Can u please fwd code for Animated Text in userform. urgently. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212

Re: $$Excel-Macros$$ Indirect Function

2011-11-30 Thread Dhartikumar Sahu
hi chethan can u explain how u use "getphoto" in Indirect example 3. Thanks & regards Dhartikumar Sahu On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar wrote: > Hope these help. > > > On Wed, Nov 30, 2011 at 11:47 PM, Aamir Shahzad > wrote: > >>

Re: $$Excel-Macros$$ macros

2011-09-13 Thread Dhartikumar Sahu
send the file On Mon, Sep 12, 2011 at 5:49 PM, channa srinivas wrote: > hello everyone > > > I have created a macro long back and i have protected it > and now forgot the passwork, > is it possible to veiw the code?? > > > > -- > > ---

$$Excel-Macros$$ Bold & set color some text in msgbox

2011-04-27 Thread Dhartikumar Sahu
hi experts Is there any way to set some (not all) of the text to bold when using the MsgBox in VBA. Thanks & Regards Dhartikumar Sahu -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ 20 days Left : Here is first Look of discussexcel.com

2011-02-28 Thread Dhartikumar Sahu
it's good product & well designedkeep it up Ayush Dhartikumar Sahu Sr.Database Manager - Equity Research 9920342276 On Tue, Mar 1, 2011 at 1:01 AM, Indrajit $nai wrote: > *Great going Ayush* > > > On Mon, Feb 28, 2011 at 5:53 PM, sudhir kumar wrote: > >&

Re: $$Excel-Macros$$ Re: set my vba password through vba code

2010-12-13 Thread Dhartikumar Sahu
Hi Ayush thanx for reply. but can i protect my vba password. ( no one can break the password). Thanks & Regards Dhartikumar On Sat, Dec 11, 2010 at 2:39 PM, Ayush wrote: > Hi Dharti, > > Good Question! > > I just did a quick check of the VBproject object model and don

$$Excel-Macros$$ hi

2010-12-09 Thread Dhartikumar Sahu
how to set my vba password through vba code. please help urgenly... Thanks & Regards Dhartikumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter

RE: $$Excel-Macros$$ Fwd: Help needed - Count Unique Values based on matching criteria

2010-08-06 Thread Dhartikumar Sahu
Hi pravin Use countif Regards Dhartikumar -Original Message- From: praveen kumar Sent: 06 August 2010 14:38 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Help needed - Count Unique Values based on matching criteria -- Forwarded message -- From

Re: $$Excel-Macros$$ Password Cracker file

2010-01-05 Thread Dhartikumar Sahu
please send the file. On Tue, Jan 5, 2010 at 5:07 PM, Prathap . wrote: > Hi There.. > > > > I have excel file which is protected. > > > > Can anyone please help crack the password. If possible, then pls tell > me. Keeping the confidentiality in to consideration i can mail the excel > file to the

Re: $$Excel-Macros$$ text and date in one cell

2009-11-13 Thread Dhartikumar Sahu
hi Prashanth Please find attached file as per your requirement. Dhartikumar On Thu, Nov 12, 2009 at 6:36 PM, Prashanth Banneni wrote: > Hi All, > > Can you help me how to get the desired output from the attached sheet. > > Many thanks in advance >

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dhartikumar Sahu
Hi Dhananjay Please find herewith excel file as per your requirement. U just set the currency 0="-" Dhartikumar On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > ex

$$Excel-Macros$$ Re: Fwd: about to remove "#VALUE!" error

2009-08-17 Thread Dhartikumar Sahu
Hi Dhananjay Please find herewith excel file as per your requirement. U just set the currency 0="-" Dhartikumar On Sat, Aug 15, 2009 at 5:21 PM, Dhananjay Pinjan wrote: > > Dear All, > > Please ignore the previous mail sent by me because i forgot to attach the > ex

$$Excel-Macros$$ hi

2009-05-27 Thread Dhartikumar Sahu
hi all can anybody help me for saving the file with current date. (e.g. dhartikumar - 27 May 2009) in macro code. Thanks & Regards Dhartikumar --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Comma Concatenator Macro

2009-05-27 Thread Dhartikumar Sahu
hi bala can u suggest me for saving the file i want to save as file name with current date. can u give me a VBA Code please On Wed, May 27, 2009 at 2:13 PM, bala wrote: > > Hi, > Try this code > > > Range("A1").select > > while Activecell.value <> "" > if len(Activecell.value) >3

$$Excel-Macros$$ Re: want to remove Open password in excel

2009-05-25 Thread Dhartikumar Sahu
hi Rahul but for remove the password i should open the file. if can not open without password then what to do... Regards Dhartikumar On Sat, May 23, 2009 at 6:55 PM, RAHUL GARG wrote: > Hi Dear freiend, > Go to the tool menu in the toolbar, click on >

$$Excel-Macros$$ want to remove Open password in excel

2009-05-19 Thread Dhartikumar Sahu
hi group can u suggest me how to remove open password in excel Thanks Dhartikumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video

$$Excel-Macros$$ how to set default userform when open workbook

2009-05-17 Thread Dhartikumar Sahu
hi grroup can somebody help me how to set default userform when open file. whithout click. Thanks Dhartikumar --~--~-~--~~~---~--~~ - Some important links for excel users: 1