Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
dont use .copy  in set statement

On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello Ashish,
>
> I got solution for this issue but I am getting one more error in code as
> type mismatch
>
>
> *Set rnbody1 = Sheets("Details").UsedRange.Copy
> rnbody1.Copy
>
> *
> On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi Ashsh,
>>
>> I used ur code but getting error in below lines. I think I need to enable
>> some reference. Please let me know about this.
>>
>> *Set Data = New DataObject
>> Data.GetFromClipboard
>> *
>> Thanks,
>>
>> Chandra Shekar B
>>   On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Thanks Ashish I will check it out. :-)
>>>
>>>
>>> On Fri, Aug 12, 2011 at 4:31 AM, ashish koul wrote:
>>>
 try these


 On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar <
 chandrashekarb@gmail.com> wrote:

> Hi,
>
> In below code some times I could able to send attachments but some
> times its not taking attachment at all. Please let me know whats is the
> problem in the below code.
>
> Sub sendmail()
> '
> Dim UserName As String
> Dim MailDbName As String
> Dim Recipient As Variant
> Dim ccRecipient As String
> Dim Attachment1 As String
> Dim Maildb As Object
> Dim MailDoc As Object
> Dim AttachME As Object
> Dim AttachME2 As Object
> Dim AttachME3 As Object
> Dim AttachME4 As Object
> Dim AttachME5 As Object
> Dim Session As Object
> Dim EmbedObj1 As Object
> Dim EmbedObj2 As Object
> Dim EmbedObj3 As Object
> Dim EmbedObj4 As Object
> Dim EmbedObj5 As Object
> Dim stSignature As String
> With Application
> .ScreenUpdating = False
> .DisplayAlerts = False
> ' Open and locate current LOTUS NOTES User
> Set Session = CreateObject("Notes.NotesSession")
> UserName = Session.UserName
> MailDbName = Left$(UserName, 1) & Right$(UserName, (Len(UserName) -
> InStr(1, UserName, " "))) & ".nsf"
> Set Maildb = Session.GetDatabase("", MailDbName)
> If Maildb.IsOpen = True Then
> Else
> Maildb.OPENMAIL
> End If
> ' Create New Mail and Address Title Handlers
> Set MailDoc = Maildb.CREATEDOCUMENT
> MailDoc.Form = "Memo"
> stSignature =
> Maildb.GetProfileDocument("CalendarProfile").GetItemValue("Signature")(0)
> ' Select range of e-mail addresses
> Recipient = notes_id
> MailDoc.SendTo = Recipient
> MailDoc.Subject = "Test Mail "
> MailDoc.Body = "Hi," & vbCrLf & vbCrLf & "Please find attached schedule
> for the day " & vbCrLf & vbCrLf & "Regards" & vbCrLf & vbCrLf & "Chandru"
> ' Select Workbook to Attach to E-Mail
> MailDoc.SaveMessageOnSend = True
> Attachment1 = "C:\temp.bmp" ' Required File Name"
> If Attachment1 <> "" Then
> On Error Resume Next
> Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment1")
> Set EmbedObj1 = AttachME.EmbedObject(1454, "", Attachment1,
> "Attachment1")
> MailDoc.CREATERICHTEXTITEM ("Attachment1")
> On Error Resume Next
> End If
> MailDoc.PostedDate = Now()
> On Error GoTo errorhandler1
> MailDoc.SEND 0, Recipient
> Set Maildb = Nothing
> Set MailDoc = Nothing
> Set AttachME = Nothing
> Set AttachME2 = Nothing
> Set AttachME3 = Nothing
> Set AttachME4 = Nothing
> Set AttachME5 = Nothing
> Set Session = Nothing
> Set EmbedObj1 = Nothing
> Set EmbedObj2 = Nothing
> Set EmbedObj3 = Nothing
> Set EmbedObj4 = Nothing
> Set EmbedObj5 = Nothing
> .ScreenUpdating = True
> .DisplayAlerts = True
> Exit Sub
> End With
> errorhandler1:
> MsgBox Err.Description
> Set Maildb = Nothing
> Set MailDoc = Nothing
> Set AttachME = Nothing
> Set AttachME2 = Nothing
> Set AttachME3 = Nothing
> Set AttachME4 = Nothing
> Set AttachME5 = Nothing
> Set Session = Nothing
> Set EmbedObj1 = Nothing
> Set EmbedObj2 = Nothing
> Set EmbedObj3 = Nothing
> Set EmbedObj4 = Nothing
> Set EmbedObj5 = Nothing
> End Sub
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>


Re: $$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

2011-08-15 Thread ashish koul
online ms excel certifications

http://www.microsoft.com/learning/en/us/certification/mos.aspx#certifications


excel video tutorials

http://www.youtube.com/user/ExcelIsFun

http://www.youtube.com/user/freetutorials#p/c/101B97B62F3B2586/0/FNPNS6MT1Kk

http://www.youtube.com/user/MotionTraining

http://www.youtube.com/user/IDAutomation

http://www.youtube.com/user/excelmadeasy

http://www.youtube.com/user/contextures

http://www.youtube.com/user/MsKemas

http://www.youtube.com/user/VBA4Excel

http://www.youtube.com/user/ExcelVBAHelp?blend=7&ob=5

http://www.youtube.com/user/jakeblanchard

http://www.youtube.com/user/FinneyLearning

http://www.youtube.com/user/johnsdre

http://www.youtube.com/user/bjele123

http://www.contextures.com/ExcelVideoTutorials.html





On Mon, Aug 15, 2011 at 11:56 AM, Puttu  wrote:

> Hi Experts,
>
> I want to learn excel, VBA in bangalore, I have basic knowledge in
> both. Please advise any complete training institues where I can learn
> and became master on this courses.
>
> Also let me know how do I get MIS certified?? Do we have any online
> video training for Excel and VBA & MIS which is worth full. If yes let
> me know the website details.
>
> Any help will be much appreciated.
>
> Thanks
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread Chandra Shekar
Hi Asish,
Thank u for the help again I am getting error in the below code. Please let
me know whats the problem in the below code.

Thanks in advance.
**
*MailDoc.Save True, True, False
*
On Mon, Aug 15, 2011 at 9:53 AM, ashish koul  wrote:

> dont use .copy  in set statement
>
>
> On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello Ashish,
>>
>> I got solution for this issue but I am getting one more error in code as
>> type mismatch
>>
>>
>> *Set rnbody1 = Sheets("Details").UsedRange.Copy
>> rnbody1.Copy
>>
>> *
>>   On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi Ashsh,
>>>
>>> I used ur code but getting error in below lines. I think I need to enable
>>> some reference. Please let me know about this.
>>>
>>> *Set Data = New DataObject
>>> Data.GetFromClipboard
>>> *
>>> Thanks,
>>>
>>> Chandra Shekar B
>>>   On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
 Thanks Ashish I will check it out. :-)


 On Fri, Aug 12, 2011 at 4:31 AM, ashish koul wrote:

> try these
>
>
> On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> In below code some times I could able to send attachments but some
>> times its not taking attachment at all. Please let me know whats is the
>> problem in the below code.
>>
>> Sub sendmail()
>> '
>> Dim UserName As String
>> Dim MailDbName As String
>> Dim Recipient As Variant
>> Dim ccRecipient As String
>> Dim Attachment1 As String
>> Dim Maildb As Object
>> Dim MailDoc As Object
>> Dim AttachME As Object
>> Dim AttachME2 As Object
>> Dim AttachME3 As Object
>> Dim AttachME4 As Object
>> Dim AttachME5 As Object
>> Dim Session As Object
>> Dim EmbedObj1 As Object
>> Dim EmbedObj2 As Object
>> Dim EmbedObj3 As Object
>> Dim EmbedObj4 As Object
>> Dim EmbedObj5 As Object
>> Dim stSignature As String
>> With Application
>> .ScreenUpdating = False
>> .DisplayAlerts = False
>> ' Open and locate current LOTUS NOTES User
>> Set Session = CreateObject("Notes.NotesSession")
>> UserName = Session.UserName
>> MailDbName = Left$(UserName, 1) & Right$(UserName, (Len(UserName) -
>> InStr(1, UserName, " "))) & ".nsf"
>> Set Maildb = Session.GetDatabase("", MailDbName)
>> If Maildb.IsOpen = True Then
>> Else
>> Maildb.OPENMAIL
>> End If
>> ' Create New Mail and Address Title Handlers
>> Set MailDoc = Maildb.CREATEDOCUMENT
>> MailDoc.Form = "Memo"
>> stSignature =
>> Maildb.GetProfileDocument("CalendarProfile").GetItemValue("Signature")(0)
>> ' Select range of e-mail addresses
>> Recipient = notes_id
>> MailDoc.SendTo = Recipient
>> MailDoc.Subject = "Test Mail "
>> MailDoc.Body = "Hi," & vbCrLf & vbCrLf & "Please find attached
>> schedule for the day " & vbCrLf & vbCrLf & "Regards" & vbCrLf & vbCrLf &
>> "Chandru"
>> ' Select Workbook to Attach to E-Mail
>> MailDoc.SaveMessageOnSend = True
>> Attachment1 = "C:\temp.bmp" ' Required File Name"
>> If Attachment1 <> "" Then
>> On Error Resume Next
>> Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment1")
>> Set EmbedObj1 = AttachME.EmbedObject(1454, "", Attachment1,
>> "Attachment1")
>> MailDoc.CREATERICHTEXTITEM ("Attachment1")
>> On Error Resume Next
>> End If
>> MailDoc.PostedDate = Now()
>> On Error GoTo errorhandler1
>> MailDoc.SEND 0, Recipient
>> Set Maildb = Nothing
>> Set MailDoc = Nothing
>> Set AttachME = Nothing
>> Set AttachME2 = Nothing
>> Set AttachME3 = Nothing
>> Set AttachME4 = Nothing
>> Set AttachME5 = Nothing
>> Set Session = Nothing
>> Set EmbedObj1 = Nothing
>> Set EmbedObj2 = Nothing
>> Set EmbedObj3 = Nothing
>> Set EmbedObj4 = Nothing
>> Set EmbedObj5 = Nothing
>> .ScreenUpdating = True
>> .DisplayAlerts = True
>> Exit Sub
>> End With
>> errorhandler1:
>> MsgBox Err.Description
>> Set Maildb = Nothing
>> Set MailDoc = Nothing
>> Set AttachME = Nothing
>> Set AttachME2 = Nothing
>> Set AttachME3 = Nothing
>> Set AttachME4 = Nothing
>> Set AttachME5 = Nothing
>> Set Session = Nothing
>> Set EmbedObj1 = Nothing
>> Set EmbedObj2 = Nothing
>> Set EmbedObj3 = Nothing
>> Set EmbedObj4 = Nothing
>> Set EmbedObj5 = Nothing
>> End Sub
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @
>> http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.

RE: $$Excel-Macros$$ To get a graphic item of size equal to a cell entry

2011-08-15 Thread Daniel
HI,

Paste this macro in the sheet module :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Or Target.Count <> 1 Then Exit Sub
With Sheets("Sheet1")
.Shapes(1).Width = .[B1].Offset(, .[A1].Value - 1).Left
End With
End Sub

Regards.

Daniel

-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Subodh
Envoyé : lundi 15 août 2011 00:56
À : MS EXCEL AND VBA MACROS
Objet : $$Excel-Macros$$ To get a graphic item of size equal to a cell entry

HI
I want to get the graphic item, in this case a line with the length equal to
the cell value.
Acutally I want in cell A1 a value ranging from 1 to 10 and depending on
this value, the length of the line should be in the range B1 to k1 ie. if
its 1 the line should be in cell b1, if 2 the b1 and c1 , if 3 then b1, c1
and d1 and so on Thanks for your support.

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

2011-08-15 Thread Excel VBASQL
Hi Putta,

www.ExcelVBASql.com  has over 27+ hours of FREE
videos for you to watch and learn VBA to become an EXPERT.

Start watching today!

On Mon, Aug 15, 2011 at 1:26 AM, Puttu  wrote:

> Hi Experts,
>
> I want to learn excel, VBA in bangalore, I have basic knowledge in
> both. Please advise any complete training institues where I can learn
> and became master on this courses.
>
> Also let me know how do I get MIS certified?? Do we have any online
> video training for Excel and VBA & MIS which is worth full. If yes let
> me know the website details.
>
> Any help will be much appreciated.
>
> Thanks
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Over Time

2011-08-15 Thread Excel VBASQL
We can help email us at excelvba...@gmail.com

On Aug 14, 8:34 am, sheron joseph  wrote:
> Excellent Mr.Rajan Verma..Superb
>
> 
> From: Rajan_Verma 
> To: excel-macros@googlegroups.com
> Sent: Sunday, 14 August 2011 4:14 PM
> Subject: RE: $$Excel-Macros$$ Over Time
>
> Please see the attached Sheet.
>  
> From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
> Behalf Of vasisd
> Sent: Sunday, August 14, 2011 3:18 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Over Time
>  
> Experts,
> Please help me to improvise the attached Excel file.
> My aim is to record daily working hours and calculate the overtime tobe paid
> to the workers.
> I also need a Payment Slip format to be give to each worker.
> Please send me your ideas & modifications.
> Thanks
> Vasi S. D.
> vas...@gmail.com
>
> --
> Vasi S D
> vas...@gmail.com
>  
> --
> ---­---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>  
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel
> --
> ---­---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>  
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Looking for MIS training in Bangalore (Complete Excel and VBA Courses)

2011-08-15 Thread NOORAIN ANSARI
http://chandoo.org/wp/excel-school/
http://chandoo.org/wp/vba-classes/

On Mon, Aug 15, 2011 at 11:56 AM, Puttu  wrote:

> Hi Experts,
>
> I want to learn excel, VBA in bangalore, I have basic knowledge in
> both. Please advise any complete training institues where I can learn
> and became master on this courses.
>
> Also let me know how do I get MIS certified?? Do we have any online
> video training for Excel and VBA & MIS which is worth full. If yes let
> me know the website details.
>
> Any help will be much appreciated.
>
> Thanks
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Fwd: Job opening

2011-08-15 Thread Venkat CV
Hi Praksah,

Please forward in to this ID: ma...@bhilwarainfo.com

*Best Regards,*
*Venkat *
*Chennai*


On Sun, Aug 14, 2011 at 9:18 PM, prakash prakash wrote:

> hi,
>
> please find the attached file
> regards
> gnanaprakash n
>
>
> On Wed, Aug 10, 2011 at 3:05 PM, Venkat CV  wrote:
>
>> - Original message 
>> From:""Bhilwara Infotech Limited""< ma...@bhilwarainfo.com >
>> Date: 10 Aug 11 13:15:46
>> Subject: Job opening with Wipro for MIS Executive
>> To:
>>
>> For Internal Use of Employer (Please don't delete or modify while replying
>> to this email)Monster Resume ID: 33564079  Personal Folder ID: 10186337
>> Dear Venkatesan,
>>
>> We have an urgent requirement from Wipro (CONTRACT) for Bangalore
>> Location.
>>
>> CANDIDATE SHOULD JOIN WITHIN 15 DAYS
>>
>>
>> JD
>>
>> MIS Executive
>>
>> inventory experience. Experience with information management, forecasting
>> and vendor management required
>>
>> If you are really interested please revert back to this mail with your
>> Cont. No and updated resume ASAP.
>>
>>
>>
>>
>>
>> This mail has been sent by one of the employers (Employer name: Bhilwara
>> Infotech Limited) accessing the services of monsterindia.com and not by
>> Monster. Monster is committed to protecting the privacy of our users and our
>> “Terms of Use” prohibits any misuse including spamming. If you consider the
>> contents of the mails inappropriate or as spam, please forward this mail to
>> spam@monsterindia.comDouble your chances of getting the right job by
>> keeping your resume updated.
>> Update Resume now
>>
>> *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Notes : Help

2011-08-15 Thread ashish koul
can you attach your file



On Mon, Aug 15, 2011 at 5:35 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> I am getting attached error while running the macro. Please let me know
> whats the error in the below code.
>
> *MailDoc.Save True, True, False*
>
> Regards,
>
> Chandra Shekar B
> On Mon, Aug 15, 2011 at 11:43 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi Asish,
>> Thank u for the help again I am getting error in the below code. Please
>> let me know whats the problem in the below code.
>>
>> Thanks in advance.
>> **
>> *MailDoc.Save True, True, False
>> *
>>   On Mon, Aug 15, 2011 at 9:53 AM, ashish koul wrote:
>>
>>> dont use .copy  in set statement
>>>
>>>
>>> On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
 Hello Ashish,

 I got solution for this issue but I am getting one more error in code as
 type mismatch


 *Set rnbody1 = Sheets("Details").UsedRange.Copy
 rnbody1.Copy

 *
   On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar <
 chandrashekarb@gmail.com> wrote:

> Hi Ashsh,
>
> I used ur code but getting error in below lines. I think I need to
> enable some reference. Please let me know about this.
>
> *Set Data = New DataObject
> Data.GetFromClipboard
> *
> Thanks,
>
> Chandra Shekar B
>   On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Thanks Ashish I will check it out. :-)
>>
>>
>> On Fri, Aug 12, 2011 at 4:31 AM, ashish koul 
>> wrote:
>>
>>> try these
>>>
>>>
>>> On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
 Hi,

 In below code some times I could able to send attachments but some
 times its not taking attachment at all. Please let me know whats is the
 problem in the below code.

 Sub sendmail()
 '
 Dim UserName As String
 Dim MailDbName As String
 Dim Recipient As Variant
 Dim ccRecipient As String
 Dim Attachment1 As String
 Dim Maildb As Object
 Dim MailDoc As Object
 Dim AttachME As Object
 Dim AttachME2 As Object
 Dim AttachME3 As Object
 Dim AttachME4 As Object
 Dim AttachME5 As Object
 Dim Session As Object
 Dim EmbedObj1 As Object
 Dim EmbedObj2 As Object
 Dim EmbedObj3 As Object
 Dim EmbedObj4 As Object
 Dim EmbedObj5 As Object
 Dim stSignature As String
 With Application
 .ScreenUpdating = False
 .DisplayAlerts = False
 ' Open and locate current LOTUS NOTES User
 Set Session = CreateObject("Notes.NotesSession")
 UserName = Session.UserName
 MailDbName = Left$(UserName, 1) & Right$(UserName, (Len(UserName) -
 InStr(1, UserName, " "))) & ".nsf"
 Set Maildb = Session.GetDatabase("", MailDbName)
 If Maildb.IsOpen = True Then
 Else
 Maildb.OPENMAIL
 End If
 ' Create New Mail and Address Title Handlers
 Set MailDoc = Maildb.CREATEDOCUMENT
 MailDoc.Form = "Memo"
 stSignature =
 Maildb.GetProfileDocument("CalendarProfile").GetItemValue("Signature")(0)
 ' Select range of e-mail addresses
 Recipient = notes_id
 MailDoc.SendTo = Recipient
 MailDoc.Subject = "Test Mail "
 MailDoc.Body = "Hi," & vbCrLf & vbCrLf & "Please find attached
 schedule for the day " & vbCrLf & vbCrLf & "Regards" & vbCrLf & vbCrLf 
 &
 "Chandru"
 ' Select Workbook to Attach to E-Mail
 MailDoc.SaveMessageOnSend = True
 Attachment1 = "C:\temp.bmp" ' Required File Name"
 If Attachment1 <> "" Then
 On Error Resume Next
 Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment1")
 Set EmbedObj1 = AttachME.EmbedObject(1454, "", Attachment1,
 "Attachment1")
 MailDoc.CREATERICHTEXTITEM ("Attachment1")
 On Error Resume Next
 End If
 MailDoc.PostedDate = Now()
 On Error GoTo errorhandler1
 MailDoc.SEND 0, Recipient
 Set Maildb = Nothing
 Set MailDoc = Nothing
 Set AttachME = Nothing
 Set AttachME2 = Nothing
 Set AttachME3 = Nothing
 Set AttachME4 = Nothing
 Set AttachME5 = Nothing
 Set Session = Nothing
 Set EmbedObj1 = Nothing
 Set EmbedObj2 = Nothing
 Set EmbedObj3 = Nothing
 Set EmbedObj4 = Nothing
 Set EmbedObj5 = Nothing
 .ScreenUpdating = True
 .DisplayAlerts = True
 Exit Sub
 End With
 errorhandler1:
 MsgBox Err.Description
 Set Maildb = Nothing
 Set MailDoc = Nothing
 Set AttachME = Noth

$$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Amit Desai (MERU)
Dear Masters,

I am currently using a temporary laptop & in few days will receive another one. 
I have created some Macros & saved them in personal macro workbook.

My queries are;

1)  Where to find them on my system,

2)  How to transfer them to new system.

Best Regards,
Amit Desai


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Sanjib Chatterjee
you can find it in personal.xls file in you system.  Which is stays in
\Microsoft Office\xlstart folder.  copy it and paste in you new
location

On 8/16/11, Amit Desai (MERU)  wrote:
> Dear Masters,
>
> I am currently using a temporary laptop & in few days will receive another
> one. I have created some Macros & saved them in personal macro workbook.
>
> My queries are;
>
> 1)  Where to find them on my system,
>
> 2)  How to transfer them to new system.
>
> Best Regards,
> Amit Desai
>
> 
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread NOORAIN ANSARI
Dear Amit,

Please find full fath of  Personal Macro File..

1. C:\Program Files\Microsoft Office\Office12\XLSTART
2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.



Thanks & regards,
Noorain Ansari
On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU)  wrote:

>  Dear Masters,
>
> ** **
>
> I am currently using a temporary laptop & in few days will receive another
> one. I have created some Macros & saved them in personal macro workbook.**
> **
>
> ** **
>
> My queries are;
>
> **1)  **Where to find them on my system,
>
> **2)  **How to transfer them to new system.
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Venkat CV
*Hi Amit,*
*
*
*See the below path*
*
*
*C:\Documents and Settings\vcc7328\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB*
*
*
*Login ID:vcc7328*
*
*
*For 2007 &2010...*


*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI
wrote:

> Dear Amit,
>
> Please find full fath of  Personal Macro File..
>
> 1. C:\Program Files\Microsoft Office\Office12\XLSTART
> 2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.
>
>
>
> Thanks & regards,
> Noorain Ansari
> On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) <
> amit.de...@merucabs.com> wrote:
>
>>  Dear Masters,
>>
>> ** **
>>
>> I am currently using a temporary laptop & in few days will receive another
>> one. I have created some Macros & saved them in personal macro workbook.*
>> ***
>>
>> ** **
>>
>> My queries are;
>>
>> **1)  **Where to find them on my system,
>>
>> **2)  **How to transfer them to new system.
>>
>> ** **
>>
>> Best Regards,
>>
>> Amit Desai
>>
>> --
>> Disclaimer: This message and its attachments contain confidential
>> information and may also contain legally privileged information. This
>> message is intended solely for the named addressee. If you are not the
>> addressee indicated in this message (or authorized to receive for
>> addressee), you may not copy or deliver any part of this message or its
>> attachments to anyone or use any part of this message or its attachments.
>> Rather, you should permanently delete this message and its attachments (and
>> all copies) from your system and kindly notify the sender by reply e-mail.
>> Any content of this message and its attachments that does not relate to the
>> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
>> been sent or endorsed by any of them. Email communications are not private
>> and no warranty is made that e-mail communications are timely, secure or
>> free from computer virus or other defect.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


RE: $$Excel-Macros$$ Export of Personal Macro Book

2011-08-15 Thread Amit Desai (MERU)
This one helped thanks...

Best Regards,
Amit Desai


From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Venkat CV
Sent: Tuesday, August 16, 2011 11:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Export of Personal Macro Book

Hi Amit,

See the below path

C:\Documents and Settings\vcc7328\Application 
Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB

Login ID:vcc7328

For 2007 &2010...


Best Regards,
Venkat
Chennai

On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI 
mailto:noorain.ans...@gmail.com>> wrote:
Dear Amit,

Please find full fath of  Personal Macro File..

1. C:\Program Files\Microsoft Office\Office12\XLSTART
2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.



Thanks & regards,
Noorain Ansari
On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Masters,

I am currently using a temporary laptop & in few days will receive another one. 
I have created some Macros & saved them in personal macro workbook.

My queries are;

1)  Where to find them on my system,

2)  How to transfer them to new system.

Best Regards,
Amit Desai


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel



--




--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not re