Conflict with GetOpenFilename and Workbooks(x).Close - expected filename and not path

[knutfh]

Hi everyone,

I have some issues when opening a file with the GetOpenFilename method, and then trying to close it later, with Application.Workbooks(x).Close.

Basically, this is what I'm trying to accomplish:

Please Login or Register  to view this content.

The issue here is that the GetOpenFilename method gets the whole path of the file, while the Application.Workbooks(x).Close method expects only the file name, and not the whole path.
Therefore I get run-time error '9', Subscript out of range.

What would be the best way to get around this?
Should I use another method to open the file, or should i create a variable that extracts the filename from the whole path, and puts it into a new variable?

Your suggestions are really appreciated!

Best regards,
Knut

[JosephP]

use a workbook variable

Please Login or Register  to view this content.

[knutfh]

use a workbook variable

Please Login or Register  to view this content.

I'm now able to close the file, but now the semicolon separation of the csv file does not work anymore.
Can't seem to get it working with the original version i posted either - but I'm really sure it worked before...

[JosephP]

I reckon you had the argument in the wrong place-easier to name them

Please Login or Register  to view this content.

[knutfh]

I figured it out. Had to set Local to True, like this:

Please Login or Register  to view this content.

[JosephP]

the delimiter argument is ignored unless format:=6
did you try setting format:=4 which specifies the semicolon separator?