VBA worked in 2007 Excel, not in 2010

[maximus0120]

Hi guys, I have this code from an excel workbook we use at work for emailing important contents of a spreadsheet directly from Excel through Outlook. The code was working great in Excel 2007 with Outlook 2007....but since the office updated to both 2010 versions, the code keeps coming up with errors. Any one have any ideas on a fix, or how to rewrite it so it will work with 2010?
The bug seems to be in the "tempfile=environ$......etc..or at least that what excel keep flagging as the error.

[Richard Buttrey]

Hi,

Can't be more specific but I've just tried your code with Excel 2010 and Outlook 2007 (I don't have OL 2010) and it works. Which perhaps suggests that the problem area is Outlook 2010

I came across the following http://gillwald.co.uk/home/archives/30 which might offer some clues, and I noticed googling around for temp environ outlook 2010 that there were other similar links.

[maximus0120]

Thanks for your reply, I figured it out, the problem was actual a missing object library refrence.

thanks again for you help