Workbooks.Close not working?

[dvent]

Hi All,

I have a macro as follows:

Please Login or Register  to view this content.

The macro causes an error at the line "Workbooks.Close eData" but I don't know why?

Can anyone help with this or suggest another way of doing this?

Cheers
dvent

[royUK]

I think you need

Please Login or Register  to view this content.

[dvent]

i still get subscript out of range error.

[Richard Schollar]

GetOpenFileName will return the whole path, so you just need the filename element. Use:

Please Login or Register  to view this content.