HELP! Error 1004 - Temporary File Path not found

Hi Everyone!

This is my first post, and when it comes to excel i'm not great (so apologies that my technical terms are extremely weak!)

Just started working on a Macro that I copied the script from an already working workbook and have made some changes, it now won't work. It'll open up the single sheet, name it book 8 not the reference number and won't take it any further i.e opening up outlook. I have copied it below and underlined where it is highlighted as a 'bug'

Any help will be greatly appreciated on what i need to change.
Thanks in Advance. Pip

Please Login or Register  to view this content.

Hello Pip,

The problem is syntax related. The code does not run because of the double quote character “ ANSI code 147.
It should be a double quote " ANSI code 34.

Here is the code you posted...

Please Login or Register  to view this content.

Here is how the line should appear...

Please Login or Register  to view this content.