VBA for excel
Closed
gunsrima
-
Feb 4, 2011 at 04:16 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 7, 2011 at 02:57 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 7, 2011 at 02:57 AM
Hello,
I need to open one after another xls files from the spec. folder, then activate another workbook and copy 4 cells from it, then paste those copied 4 cells into one of the previously opened file, then save and the same cells with new results copy and paste into 3rd excel workbook. then continue with following files in that spec. folder. I have 90 files to work with it :)
Any help would appreciate :)
I need to open one after another xls files from the spec. folder, then activate another workbook and copy 4 cells from it, then paste those copied 4 cells into one of the previously opened file, then save and the same cells with new results copy and paste into 3rd excel workbook. then continue with following files in that spec. folder. I have 90 files to work with it :)
Any help would appreciate :)
Related:
- VBA for excel
- Number to words in excel formula without vba - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Vba case like - Guide
- Kernel for excel - Download - Backup and recovery
- Excel vba hide formula bar - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 6, 2011 at 09:56 PM
Feb 6, 2011 at 09:56 PM
I suggest you record a macro following all the steps and then edit the macro.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 7, 2011 at 02:57 AM
Feb 7, 2011 at 02:57 AM
are the source files multiple files
or
are the destination files multiple with only one source.
if the source files are multiple then copy the macro with each of the source files, changing in each macro the name of the destination file. Sophisticated way is to park the file in the personal.xls that needs little more expertise.
if it is that the source fiel is one and the destination files multiple you have to loop through destination files.
are my statements intelligible? can you manage it.
otherwise post your macro explaining clearly your requirements.
or
are the destination files multiple with only one source.
if the source files are multiple then copy the macro with each of the source files, changing in each macro the name of the destination file. Sophisticated way is to park the file in the personal.xls that needs little more expertise.
if it is that the source fiel is one and the destination files multiple you have to loop through destination files.
are my statements intelligible? can you manage it.
otherwise post your macro explaining clearly your requirements.
Feb 7, 2011 at 01:23 AM