$$Excel-Macros$$ Type Mismatch error.

2012-11-18 Thread Prince
Hi Group, i am getting type mismatch error while transposing the array of 8 rows and 155206 columns. although same code running fine when no of columns got decreased around 1 below is my line of code in which i m getting error.Please suggest ThisWorkbook.Worksheets("TempContact").Range(

Re: $$Excel-Macros$$ VBA : Class does not support automation error.

2012-11-18 Thread Amol Jadhav
Thanks a lot Asa. Regards, Amol Jadhav On Sat, Nov 10, 2012 at 4:51 AM, Asa Rossoff wrote: > Hi Amol, > > I haven't use the Office Web Components, and we don't know much about your > code or file, but the error is usually caused by a references/library > problem, such as: > > **ยท

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

2012-11-18 Thread Anoop K Sharma
Possibly, I am getting errors in applying the above criteria. What if I can provide you the same applying VBA? Regards, Anoop Sr. Developer On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee wrote: > Dear Anoop, > I need the values from a pivot table use the formula > '=PERCENTILE(C2:C6,0.5)' > > Bes

$$Excel-Macros$$ Re: Need Sheets sum

2012-11-18 Thread Prince
Hi Shaikh, Can you please explain about your problem. Regards Prince On Saturday, November 17, 2012 6:03:06 PM UTC+5:30, Shaikh Iqbal wrote: > > Dear Exports, > > Need help. PFAfile. > > > > > > > > > > > Regards, > > Iqbal > -- Join official Facebook page of this forum @ https://www.fa

$$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.

2012-11-18 Thread Ayush Jain
Dear members, Let's get set for the new year 2013 Here is inviting you to participate in a quiz to make calendar for the new year in excel. There are some rules to be followed : 1) No macros to be used and should be formula based, only xlsx file to be submitted. 2) The calendar should be dyna

Re: $$Excel-Macros$$ sending email in outlook with background image.

2012-11-18 Thread ashish koul
Sub sample_macro() Dim olApp As Outlook.Application Dim olMail As MailItem Dim imgnm As String imgnm = "C:UsersPublicPicturesSample Picturesdock.jpg" Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = "koul.ash...@gmail.com" .Subject = "hello" .Att

$$Excel-Macros$$ sending email in outlook with background image.

2012-11-18 Thread yogananda muthaiah
Hi, Is it possible sending embeded image ( body of the mail) in outlook ? -- Regards Yogananda Muthaiah Ph : 973 123 7267 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Ple