how do i check the path of an opened file?..eg excel file...
bascially...when i open an excel file...a click button on the spreadsheet would send an email with the attachment (the file itself)...but i do not know the pathname of this file....
Printable View
how do i check the path of an opened file?..eg excel file...
bascially...when i open an excel file...a click button on the spreadsheet would send an email with the attachment (the file itself)...but i do not know the pathname of this file....
There are different types of mail objects, but all of them will email the open file, or a single sheet from it.
So, you don't have to worry about where the file lives.
:( I'm late for work, but the most basic one to lookup in Excel VBA help is "SendMail"
Quote:
This example sends the active workbook to a single recipient.
ActiveWorkbook.SendMail recipients:="Jean Selva"
hi...i still dun know how to integrate lotus notes with this sendmail in excel...any examples?
ActiveWorkbook.FullName will give you the path and file name.