Consulting

Results 1 to 2 of 2

Thread: VBA Question

  1. #1

    VBA Question

    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

  2. #2
    VBAX Expert Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    552
    Location
    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.
    Sincerely,
    Leith Ross

    "1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •