Application.GetOpenFilename

I am using one Master Workbook to create an Open File dialogue box in which the user selects a specific type of Log File to open; at this point the Master scans and copies rows to paste into another sheet which resides in the Master. My problem is that I cannot activate the newly opened file so that the Macro selects the data.

Please Login or Register  to view this content.

As you can see, if the code attempts to select the Range, it is doing so on the Master book, giving me errors. The range selection is supposed to be on the newly opened sheet. I am not sure what to use to activate the window of the new file, and I cannot use a static name since it depends on what file the user selects to open.

I found that the code below helped me. if u set this at the start of the macro:

Please Login or Register  to view this content.

then once the new workbook has been opened:

Please Login or Register  to view this content.

once you have set a defined name you should then be able to reference them..

hope this helps!!

Stubarso, please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

Screamtruth, if the workbook opens, it becomes the active workbook. Your code should be modified to exit if the user cancels:

Please Login or Register  to view this content.

Open returns the workbook in question.
This avoids selecting

Please Login or Register  to view this content.

Thanks shg,

I had edit the code to exit the sub if the user cancels,.

The only issue I still have is an error returned when the sub attempts to select the range; it tells me the range selection fails. I am not sure what is causing this, which is why I suspected that the window was not activated since the code is running from a button click on the Master workbook.

Try this. Confirm the selection when the code reaches the Stop, or set a breakpoint and single-step through the code.

Please Login or Register  to view this content.

Very nice, and very effective.

How would I close the newly opened file upon completion of the paste?

Please Login or Register  to view this content.

Please don't quote whole posts; it's just clutter.

Sorry for the multi-quote posts.

Thank you for your time.