200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I need to be able to copy data using VBA from another spreadsheet on a network drive into an open spreadsheet. I can use normal Excel commands to do this if the spreadsheet with the data I need is on the drive on my PC. I can obtain this even if the spreadsheet that contains the data I need is not open. However, this does not work if the spreadsheet is on a network drive unless the spreadsheet is open. Assitance would be gratefully received.
Kind Regards
Peter
Take a look at this thread. Adjust the code below to your requirements and try it.
Sub OpenWorkbook()
' replace "L" with the letter assigned to the net work drive on your PC
' replace "\Path\" with the path on the network drive
' replace "Filename.xls" with the name of the workbook you wish to open
Workbooks.Open Filename:="L:\Path\Filename.xls"
End SubRun the code by placing the cursor anywhere in the procedure and press F5 (or Run -> Sub/UserForm). The workbook should open.
Once you have found a way to open it you can use that same way to access it without opening.