Macros in Excel - requiring data entry

  • Thread starter Thread starter John Hoyle
  • Start date Start date
J

John Hoyle

I am trying to automate two function for multiple users of
a series of microsoft files. While running a macro to
create a new file for archiving specific data, I would
like the user to be able to assign a filename while
running the macro that creates the file. Is this possible?
If so, how?

Second, for the above mentioned file I would like to
create a macro the automatically launches the send to mail
recipient function, but allows the user to select the
recipients from a corporate mail list while running the
macro.

Any help would be greatly appreciated!
Thanks!
 
Take a look at Application.GetSaveAsFilename in help.

Option Explicit
Sub testme01()

Dim myFileName As Variant
myFileName _
= Application.GetSaveAsFilename(filefilter:="Excel Files, *.xls")

If myFileName = False Then
'user hit cancel
Exit Sub
End If

ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlNormal

End Sub

I don't know how to get to your corporate mail list, but Ron de Bruin and Dick
Kusleika have some code that might help with the other mail stuff:

http://www.rondebruin.nl/sendmail.htm
http://www.dicks-clicks.com
 
Back
Top