[RESOLVED] Send e-mail to file

[Resource Dragon]

I would like to be able to put a UserForm in Outlook (2003) that the user sends to an excel file so that the excel file is updated. The story behind this is that there is a file that needs to be updated frequently in hot weather: the person who is in charge updating this file currently has to find the correct file (based on the date), put the latest observation in, and then do a copy & paste of some other information. The only actual new information is the number she inputs - the rest can be automated. (The reason I am looking at "e-mailing" to l,kkkka file (rather than a person) is that I am sure the user would have her Outlook up and running the whole time and would be more comfortable with an Outlook form than an excel form.)

My question is: can this be done? If it can, could I please have one or two pointers to set me in the right direction?

(If it can't be done, I could create an excel file that consists of a UserForm & a code to update the appropriate file.)

[westconn1]

you can automate excel from outlook without problem

set xl = createobject("excel.application")
set wb = xl.workbooks.open("c:\somefolder\hotweather.xls")
wb.sheets("mysheet").range("a6").value = textbox1.text

this opens an instance of excel using late binding, you can use early binding if you feel more comfortable with it
if the workbook is being updated regularly it may be better to leave it open, using form level variables, then just save and close by button or form unload

[Resource Dragon]

Dear westconn1

Thank you for your reply, it looks like it should do the trick. I'm still working on the code to find the file & the right sheet in the file (a logic problem, rather than a vba problem - I think I've got it sorted now).