Error while opening macro written excel file attachement in outlook2010

[amolryeolekar]

While opening macro written excel file (xlsm) attachment in outlook 2010, following error is showing during opening the attachemnt, but when the same file is saved in HDD then the excel file is working fine, what is the reason and how to correct it
my excel and outlook ver is 2010

error-
err:91
Object variable or with block variable not set


pl. help.

[Norie]

Sounds like the code in the workbook open event doesn't like the workbook not being saved.

[amolryeolekar]

Hi .Norie
I don't understand, you mean to say that the workbook is saving while opening in my code and outlook10 is not allow to save in attachment. pl. clarify

[Norie]

I mean the code in the workbook won't work if you try to open it straight from Outlook.

[amolryeolekar]

Any remedy for this .any alternative

[Norie]

Is saving the file a problem?

[amolryeolekar]

No attachment opening itself an error, it should open in outlook

[Norie]

If you can't open the file straight from Outlook but it will open when you save it, why not just save it?

[amolryeolekar]

saving is a second choise . Generally people opens attachement directly ...

[Norie]

Well you need to look at the code causing the error and change it.