$$Excel-Macros$$ Re: , is to .csv as ____ is to .xls
I have sent u an xex file so that it can solve your half the problem of converting an csv to xls can be done. as i was unable to upload a .exe file i hav sent u as mail to ur mail id (yoni.hir...@gmail.com). Regards Girish K Rao --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Auto Mail Micro
Hi Harish, I have done a macro hat can send mail using outlook this may be useful for you. http://groups.google.com/group/excel-macros/web/mail.xls?hl=en Regards Girish K Rao --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Userform and xlup function
HI phillip,
This code would be useful to complete up your task.
textbox20.Value = Sheets("Sheet17").Range("B9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("K65535").End(xlUp).Row,
"K").Value
textbox21.Value = Sheets("Sheet17").Range("A9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("J65535").End(xlUp).Row,
"J").Value
textbox22.Value = Sheets("Sheet17").Range("C9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("L65535").End(xlUp).Row,
"L").Value
textbox24.Value = Sheets("Sheet17").Range("A15").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("M65535").End(xlUp).Row,
"M").Value
Sheets("Sheet17").Cells(15, "C").Value = (Date) & " " & (Time)
Sheets("Sheet17").Cells(Sheets("Sheet17").Range("I65535").End
(xlUp).Row, "I").Value = (Date) & " " & (Time)
' Check for the data
If textbox20.Value = "" Or textbox21.Value = "" Or textbox22.Value =
"" Or textbox24.Value = "" Then
MsgBox "Some data missing"
End If
Regards
Girish K Rao
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Macro in VBA which open word files and close them
Hope so this might solve your half the problem.
This function may be used for opening a list of files in a given
folder and then open each of the file and close the file.
This can be directly used in word VBA itself.
But before running this procedure add reference as "Microsoft Running
script".
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Dim FSO As Scripting.FileSystemObject
Dim SourceFolder As Scripting.Folder
Dim FileItem As Scripting.File
Dim SourceFolderName As String
Dim myDoc As Document
SourceFolderName = InputBox("Enter The Folder Where all files are
stored")
Set FSO = New Scripting.FileSystemObject
Set SourceFolder = FSO.GetFolder(SourceFolderName)
For Each FileItem In SourceFolder.Files
If FileItem.Type = "Microsoft Word Document" Then
Set myDoc = Application.Documents.Open(FileItem.path)
myDoc.Save
myDoc.Close
End If
Next FileItem
Set FileItem = Nothing
Set SourceFolder = Nothing
Set FSO = Nothing
Application.ScreenUpdating = True
End Sub
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help required
pdfedit995 this would help u basically i am using same converter to convert file and sending an email. On Dec 27, 6:38 pm, "Mahreen Ellahi" wrote: > Can u tell me anyother freeware which helps convert pdf into word, excel and > jpg files? > > On Sat, Dec 27, 2008 at 11:29 AM, Ajit Navre wrote: > > Merry X'mas, > > > If you are using Office 2003, or 2007, then MS itself provide for a PDF > > AddIn. You just need to download it from the Microsoft download center. > > Alternatively, try googling for *PDF Freeware* and you will find a lot of > > freewares, to name a few SoftExpansion PDFlite, EasyPDF, CutePDF and a lot > > more. All of these essentially create a virtual printer port (the PDF > > converter) and let you create a PDF document from any application that has > > print functionality. > > > Regards > > > Ajit. > > > *From:* excel-macros@googlegroups.com [mailto: > > excel-mac...@googlegroups.com] *On Behalf Of *Roshan Mathew > > *Sent:* Saturday, December 27, 2008 3:28 AM > > *To:* excel-macros@googlegroups.com > > *Subject:* $$Excel-Macros$$ Help required > > > Dear All, > > > Hope you all had a good time during Christmas and Wish you all an Adv New > > Year Wishes... > > > Pls help me... > > > I need to convert Excel or Word sheets into PDF formart and email the same > > to different emails as per the list. > > > -- > > Roshan --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!
This module can help u out in sending email by outlook,
I have considered data is been in "sheet1" and email id in Col"A"
subject in "col C"
add body of the email as u want in space provided.
This will send all the emails through your current profile itself,
whichever would be activated in your outlook application.
Dim oXlWkBk As Excel.Workbook ' Excel Work Book Object
Sub send_mail()
Dim i As Long
Dim olApp As Outlook.Application
Dim olMail As MailItem
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Sheets("Sheet1").Activate
For i = 2 To Range("A65535").End(xlUp).Row
With olMail
.To = Cells(i, "A").Value
.Subject = Cells(i, "C").Value
.body = "Add your body over here"
.Send
End With
Next i
MsgBox "All Mails Sent succfully"
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
On Jan 5, 10:13 am, "shay shay" wrote:
> Hello All,
>
> I have an excel sheet and it contains 800 client names in
> column A, I want to mail these 800 clients using outlook, is there any way
> where in I can create a macro which automatically mails these people as soon
> as I open the excel sheet. its similar to mail merge activity but I am new
> to it, can some one guide me, its urgent.
> --
> Shay
>
> A Thinker tends to use reason and logic
>
> A feeler tends to use values and subjective Judgement.
>
> Be a Thinker in Life.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!! URGENT!!!!!
HI Shay,
U hav to add outlook reference to do so.
In your macro screen go to Tools->References
here search for "Microsoft outlook object library " select the
checkbox corresponding to it n the click ok.
Now run the macro this has to work..
REgards
Girish K Rao
On Jan 5, 6:37 pm, "shay shay" wrote:
> Girish,
>
> I am facing an error as User- defined type not defined for all
> Dims.
>
> Regards,
> Shay
>
> On Mon, Jan 5, 2009 at 5:42 PM, girishkr...@gmail.com
>
>
> > wrote:
>
> > This module can help u out in sending email by outlook,
> > I have considered data is been in "sheet1" and email id in Col"A"
> > subject in "col C"
> > add body of the email as u want in space provided.
> > This will send all the emails through your current profile itself,
> > whichever would be activated in your outlook application.
>
> > Dim oXlWkBk As Excel.Workbook ' Excel Work Book Object
>
> > Sub send_mail()
> > Dim i As Long
> > Dim olApp As Outlook.Application
> > Dim olMail As MailItem
>
> > Set olApp = New Outlook.Application
> > Set olMail = olApp.CreateItem(olMailItem)
>
> > Application.ScreenUpdating = False
> > Application.DisplayAlerts = False
> > Sheets("Sheet1").Activate
>
> > For i = 2 To Range("A65535").End(xlUp).Row
>
> > With olMail
> > .To = Cells(i, "A").Value
> > .Subject = Cells(i, "C").Value
> > .body = "Add your body over here"
> > .Send
> > End With
> > Next i
> > MsgBox "All Mails Sent succfully"
>
> > Application.ScreenUpdating = True
> > Application.DisplayAlerts = True
>
> > End Sub
>
> > On Jan 5, 10:13 am, "shay shay" wrote:
> > > Hello All,
>
> > > I have an excel sheet and it contains 800 client names in
> > > column A, I want to mail these 800 clients using outlook, is there any
> > way
> > > where in I can create a macro which automatically mails these people as
> > soon
> > > as I open the excel sheet. its similar to mail merge activity but I am
> > new
> > > to it, can some one guide me, its urgent.
> > > --
> > > Shay
>
> > > A Thinker tends to use reason and logic
>
> > > A feeler tends to use values and subjective Judgement.
>
> > > Be a Thinker in Life.
>
> --
> Shay
>
> A Thinker tends to use reason and logic
>
> A feeler tends to use values and subjective Judgement.
>
> Be a Thinker in Life.
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~--~~~~--~~--~--~---
