OSABBAGH
08-07-2018, 06:44 AM
Hello all,
I'm new to VBA and coding.
Recently this summer i developed a very in depth, workbook project.
The workbook is a book for each day, I have an issue if i upgrade the project with certain macros or modules, all the sheets prior to me updating it do not receive update, and i would have to copy the data from each workbook to the newer version and save it, manually.
Sheet "A" on each woorkbook contains the RAW data of my concern,
Would someone help me develop a code to loop through all the woorkbooks within a file, copy the first sheet "A" to the "new updated workbook", save the workbook as the same file name that the worksheet "a" was copied from.
To simplifiy:
I have workbooks saved under file named C:\Users\osabbagh\Desktop\old
I want to open each workbook in this file, copy only the first sheet called "A" to my new workbook,
Save the "NEW" workbook as the same file name from
C:\Users\osabbagh\Desktop\old
into
C:\Users\osabbagh\Desktop\new
for each workbook found in
C:\Users\osabbagh\Desktop\old
I'm new to VBA and coding.
Recently this summer i developed a very in depth, workbook project.
The workbook is a book for each day, I have an issue if i upgrade the project with certain macros or modules, all the sheets prior to me updating it do not receive update, and i would have to copy the data from each workbook to the newer version and save it, manually.
Sheet "A" on each woorkbook contains the RAW data of my concern,
Would someone help me develop a code to loop through all the woorkbooks within a file, copy the first sheet "A" to the "new updated workbook", save the workbook as the same file name that the worksheet "a" was copied from.
To simplifiy:
I have workbooks saved under file named C:\Users\osabbagh\Desktop\old
I want to open each workbook in this file, copy only the first sheet called "A" to my new workbook,
Save the "NEW" workbook as the same file name from
C:\Users\osabbagh\Desktop\old
into
C:\Users\osabbagh\Desktop\new
for each workbook found in
C:\Users\osabbagh\Desktop\old