Can I convert a Macro to a Function?

I have the below Macro that works beautifully (Thank you Leith), It finds updated data by current user and current date, then creates a new sheet with the new data. I have an RangetoHTML Function that is used for an automated email from a userform, which does not do what I am needing it to do. I am wondering if I can convert the following Macro to the RangetoHTML function, and if so, how difficult will it be? I have tried a few things, but all I did was mess everything up.

Please Login or Register  to view this content.

http://www.excel-easy.com/vba/exampl...-function.html

Jasper,
Thank you for the response, but, I have tried to create the function myself. While it creates the sheet with the updated data as the above code does, which is what I want, when it sends the automated email that calls the RangetoHTML function to be placed in the body of the email, it doesn't work. It sends a blank email with a blank attachment. This is the reason I posted this thread, I am either doing something wrong (which is hopefully the case) or, what I want to do is not possible.
*EDIT: I get a Type Mismatch error at the

Please Login or Register  to view this content.

Line
Here is the Function code I tried, not much different from the above code...

Please Login or Register  to view this content.

Tom

What do you want the function to do?

I want it to email the newly created sheet with the updated information when the user clicks the send button on the userform. It creates the sheet and sends the email just fine, but when the email is sent, it is sent blank. On the Set ts = fso.Getfile line, I need it to pull the newly created sheet, not the workbook.

OK, I figured out the type mismatch error and how to get the correct file (I think).

Now I get a "Run-time error '62': Input past end of file" error at the following line...

Please Login or Register  to view this content.

Not sure what to do here.

Solved per this thread
http://www.excelforum.com/excel-prog...-with-vba.html
Thank you Gregor Y