ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open File or Switch Between Windows if File is Open (https://www.excelbanter.com/excel-programming/333486-re-open-file-switch-between-windows-if-file-open.html)

Ricky Pang

Open File or Switch Between Windows if File is Open
 
Hi Arvi,
Thanks for coming to my aid. When the file is already opened, I got a
prompt notifying me that the file is already opened. If I choose to
open it, I would end up opening the same file twice and running into an
error. How do I switch to that opened file and start my copy and paste
without answering the prompt of opening the same file again?

I appreciate your help.

Thanks again,
Ricky

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com