Linking Files - copy a worksheet to a new workbook

  • Thread starter Thread starter Kiba
  • Start date Start date
K

Kiba

Is there a way to open several files one a time, copy data, run an update,
print and save over the file originally opened so that the vb code is updated
and the data remains the same. I have hundreds of files that need updated
that are all set up exactly the same and its a pain to update the code in
each file. Thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with file links changing 3
Import multiple workbooks to current workbook in specified row number 0
Copy VBA code into a workbook created by a macro 11
copy and paste data only to a new file 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
Copying and pasting a worksheet to a different excel workbook 3
Copy Sheet Into New Workbook 1
Exporting Worksheets from a workbook and saving them as a .prn file 1

Back
Top