Excel file is already open-Do you want to reopen error

[laxminarayana]

Hello,

I have put up some vba code where in user selects an excel file and data from the selected file is imported to current excel file. But the problem is when the file selected is already opened with user, my code fails. Can you please help how to handle this.

Please Login or Register  to view this content.

Thanks,
Stay Safe

[Greg M]

Hi there,

But the problem is when the file selected is already opened with user, my code fails

Sorry, but your code as posted will always fail - it contains several errors (e.g. what's a "workook"?)


See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Greg M]

Hi again,

If you want to copy and paste even though the source workbook is already open you can use:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[laxminarayana]

Thank You very much Greg. This noob has long way to go