Recent content by ASAFP

I tried the code and it works. Thanks a lot Asspin and Edit! Asaf

Fumei, Thanks for your answer. The problem is that I used SendMail method, and it seems like only workbook can activate that method. But what can I do if I don't want to send a workbook but a text file instead? Thanks, Asaf

Skip, Thanks for your answer. I use outlook. Offcoarse I dont actually send it from excel. I just need to transfer my parameters to outlook- the attached filename and the reciept. I need to send the mail at the end of one of my subs in excel. Thanks, Asaf

Is there a way to send a text file by mail from vba code? I found a way to send an activeworkbook, but I need to send a none-excel file.

Thanks, It works!

This function is a public function and is used by varios excel sheets. Will this action (of changing its project name) affect these workbooks? (under the user defined functions it has the name WorkBook.xls!FunctionName)

I tried to. When I select the his workbook I get the message "Name conflicts with existing module, project or object library".

The workbook is opened.

How can I use a function from another workbook. It is a public function, I tried to call it by it's name, but it wasn't recognized. Is there other solution except from copy it? Thanks

Thanks a lot! It seems like this was the problem

Hi, I'm trying to activate a worksheet function in vba I used the following code: x=application.worksheetfunction.vlookup(cells(i,7).value,range(Products"),3,true). (I have a range with the name products) I'm getting the error massege: 1004 Unable to get the vlookup property of the...