Search results for query: *

Hi all, I had spreadsheet contain chart. I want user to be able to paste new data, run the macro, and the new data will be appended into existing chart as new series I used this code (from macro recorder) and it works. <code> ActiveChart.SeriesCollection.NewSeries...

Some of use are using Outlook XP, and the others Outlook 97. And it gave the same error message. Yes, I am interested in late binding that you mentioned. I suppose that will make life easier for usser, right? And do you have an URL that discuss this methode? Thks, a lot..

Thanks RobBroekhuis, I tried the code, and the final code is this: ------ Sub emailme() Dim objOL As Outlook.Application Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) With objMail .To = &quot;me@yahoo.com&quot; .Subject =...

Thanks Nikita6003, I am using Outlook, and after surfing around, I found this code -------------- Sub Button1_Click() Dim objOL As Outlook.Application Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) With objMail .To =...

Hi All, I tried to send excel workbook automatically using Macro, and here is the syntax: Sub email() ActiveWorkbook.SendMail &quot;someone@yahoo.com&quot;, Range(&quot;subject&quot;).Value End Sub what I want is that user click the button, and the workbook automatically sent to...