For a better experience, please enable JavaScript in your browser before proceeding.

Is there anyway to write to a workbook that the current user already has open from a VB Script.

Different Methods to Import Data From External Excel File OfficeTricks Technical Bloggers Space.

I was wonder if because the user who has the workbook open is the same one running the script if there was anyway to write data to the workbook without closing it first.

But the limitation is that you should exactly mention the workbook name inside the code.

Either you can search in this forum for Workbooks Collection or refer point 2 in the link that I provided for a sample code.

We have a great community of people providing Excel help here, but the hosting costs are enormous.

Allow Ads at MrExcel Which adblocker are you using Disable AdBlock Follow these easy steps to disable AdBlock 1)Click on the icon in the browsers toolbar.

Click on the icon in the browsers toolbar.

Go back Disable AdBlock Plus Follow these easy steps to disable AdBlock Plus 1)Click on the icon in the browsers toolbar.

Click on the toggle to disable it for mrexcel.com.

Go back Disable uBlock Origin Follow these easy steps to disable uBlock Origin 1)Click on the icon in the browsers toolbar.

Click on the Power button.

Click on the Refresh button.

Go back Disable uBlock Follow these easy steps to disable uBlock 1)Click on the icon in the browsers toolbar.

Open Excel File With Vbscript