PDA

View Full Version : VBA Question



joky
02-09-2018, 04:15 PM
Hello everyone
This is embarrassing to ask, but I can not get a solution to this issue
I suppose if there are several specific codes from within a text file And You have a folder containing this file with the main workbook and Many of the closed files
The question
How can I copy the codes from a text file And paste them in the text editor (Code Editor) into all closed files
Thanks advanced for help

Leith Ross
02-11-2018, 05:19 PM
Hello joky,

For security reasons, you cannot write code to a closed workbook. The workbook must be opened before any code can be pasted into it.