assistance on vba file remains opened getting runtime error 9

The code below opens a special format sheet "c:\\sample\INTERMARTFORMAT.xlsx" copy to my actual workings sheets
The code works but INTERMARTFORMAT.xlsx file remains opened so I tried to add(close without saving)

Workbooks("intermartformat.xlsx").Close False

but getting runtime error 9

script out range

however the opened workbook remains opened as intermartformat1.xlsx while the actual file is named INTERMARTFORMAT.xlsx on c:\sample

Please Login or Register  to view this content.

You have a couple of problems. Try this:

Please Login or Register  to view this content.

It needs to be all in caps:

Please Login or Register  to view this content.

You're welcome and thanks for the rep!

@xladept:

It needs to be all in caps

Can I ask why? As far as I am aware, file names are case insensitive.

Hi Trevor,


There was a subscript out if range error Maybe its a case preserving thing But it worked!

I only have my iPad at the moment so I can't test it ... but I wouldn't have thought so. And yes, the op has a working solution