Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Vaibhav Joshi
Delete these 3 lines.. On Tue, Aug 19, 2014 at 11:25 AM, Ujjwal Desai wrote: > Hi Vaibhav , > > on the below line : > > If Dir(rngEntry.Offset(0, 3).Value) = "" Then > MsgBox "File " & rngEntry.Offset(0, 3).Value & " doesnot exists, > exiting macro." > End If > > > On Tue, Aug 19, 2014

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
Hi Vaibhav , on the below line : If Dir(rngEntry.Offset(0, 3).Value) = "" Then MsgBox "File " & rngEntry.Offset(0, 3).Value & " doesnot exists, exiting macro." End If On Tue, Aug 19, 2014 at 11:12 AM, Vaibhav Joshi wrote: > On which line you are getting error? > > > On Tue, Aug 19, 2

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

2014-08-18 Thread Vaibhav Joshi
hi check this, i have modified Ashish ji's code. Select cell for which you want comment to appear & run macro by clicking blue button. Cheers!! On Mon, Aug 18, 2014 at 9:16 PM, Pankaj Kumar wrote: > Thanks vaibav for your prompt response. It looks good but the problem with > this code is that

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Vaibhav Joshi
On which line you are getting error? On Tue, Aug 19, 2014 at 12:40 AM, Ujjwal Desai wrote: > Hi Vaibhav , > > > Finally now working ! > > But once the macro is executed it does generates the auto email with > attachment too. > > But it prompts an error " Type Mismatch " > > How can we fix t

$$Excel-Macros$$ Select particular folder and copy some ranges one bye in my current sheet.

2014-08-18 Thread Shivani Sachdeva
Dear Excel Guru, I am trying to write a code for, Select particular folder and copy some ranges one bye in my current sheet. Here are some limitation. Selected folder contain sub folder. Multi select, and dependent folder should also be read. I am providing the code, Sub NEWMASTER() '"

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
Hi Vaibhav , Finally now working ! But once the macro is executed it does generates the auto email with attachment too. But it prompts an error " Type Mismatch " How can we fix this problem ??? Thanks, Ujjwal On Mon, Aug 18, 2014 at 6:48 PM, Vaibhav Joshi wrote: > Try this code, if fi

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

2014-08-18 Thread Pankaj Kumar
Thanks vaibav for your prompt response. It looks good but the problem with this code is that whenever you double click on any cell in the sheet, it'll pop - up the message box. But my requirement is restricted with couple of cells only. Can we modify the code where input box will ask for cell numbe

Re: $$Excel-Macros$$ Values from INDIRECT not staying after file closes

2014-08-18 Thread Chris
Hey Paul, first of all, thank you for getting back to me and sorry that it took me so long to respond. Since I couldn't access this group from work, I tried re-creating the same scenario at home - with success, except for the one issue that things were fine when in debug mode. I figured out wh

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Vaibhav Joshi
Try this code, if file doent exist it will pop up & exit macro. Try changing file location manually to chek working of code. Sub CreateMail() Dim objOutlook As Object Dim objMail As Object Dim rngEntry As Range Dim rngEntries As Range Set objOutlook = CreateObject("Outlook.Ap

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
Hi Vaibhav, The file path given contains the attachment but still it gives me with the automation error. If you can give me another code or solution I would appreciate. Thanks, Ujjwal On Aug 18, 2014 5:19 PM, "Vaibhav Joshi" wrote: > chek if attachment is there in place? > > > > > On Mon, Aug

Re: $$Excel-Macros$$ Calculating working hours between 2 days with break time

2014-08-18 Thread Vaibhav Joshi
Hi Check this.. Cheers!! On Mon, Aug 18, 2014 at 11:22 AM, son nguyen wrote: > Dear Mr Joshi > > Thank for your help ,but it isn't to meet my requirement because I only > exclude sunday not weekend.You could give me a other solution. > > Thanks a lot. > Son > > > 2014-08-16 23:28 GMT+07:00 Va

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ashish Kumar
Hi, Your code is working fine. check onces, as said by vaibhav ji. On 18 August 2014 16:32, Ujjwal Desai wrote: > Hello , > > I am trying to send multiple email with attachment with the help of Vba. > > Unfortunately I am getting an error "Automation error 440" > > Need your help in regards t

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Vaibhav Joshi
chek if attachment is there in place? On Mon, Aug 18, 2014 at 4:32 PM, Ujjwal Desai wrote: > Hello , > > I am trying to send multiple email with attachment with the help of Vba. > > Unfortunately I am getting an error “Automation error 440” > > Need your help in regards to the attached file.

$$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
Hello , I am trying to send multiple email with attachment with the help of Vba. Unfortunately I am getting an error “Automation error 440” Need your help in regards to the attached file. Awaiting for the reply ! Thanks, Ujjwal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

2014-08-18 Thread Ashish Kumar
Hi Pankaj, PFA .!!! Regards Ashish On 18 August 2014 10:24, Pankaj Kumar wrote: > I need VBA code to copy the cell value and paste in comment box for the > same cell. > > Example: If I select any cell or merged cells which has some text in it > then code should copy the text and crea