Very easy problem : Referencing to a GetOpenFilename sheet

[Bishonen]

Hi guys,

I'm having problems with the following code:

Please Login or Register  to view this content.

Seems I'm too newb to use a reference to a workbook that was opened with the GetOpenFilename Command :/ Whats the probelm here? I want to chose which file to open and then use a reference to that file (wB) to open/copy etc.

I get the open new file window, but whatever i select i get a Run-time error '424': Object Required

Thanks!

[Bob Phillips]

It should be Workbooks, not Workbook.

But I wouldn't do it all in the one line like that. What if the user cancels, you cannot trap that as the code is.

[Bishonen]

Please Login or Register  to view this content.

This code seems to be partially working now. I get the desired file open but excel stops at Range("B:B").delete

anyone got a clue how to make it delete the row "B"? It worked until I've changed stuff further into the code ><

[Bob Phillips]

You need to qualify it with the workbook object variable, and the worksheet. I would also just use Columns("B").

I see you ignored my comment about cancelling the GetOpenFilename.

[Bishonen]

To be honest with you Bob, it was your advice that returned the error in the first place :/ I got my file working now.

Please Login or Register  to view this content.

Cheers!

[Bob Phillips]

To be honest with you Bob, it was your advice that returned the error in the first place

I don't think so. You posted because you had an error, nothing to do with me. My correction of that error just showed up more problems in your code.