VBA for excel

Closed
gunsrima - Feb 4, 2011 at 04:16 AM
venkat1926
Posts
1864
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 :)

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Feb 6, 2011 at 09:56 PM
I suggest you record a macro following all the steps and then edit the macro.
0
Thank you for your reply. I did that, but then - I have no idea how to edit the macro for multiple files :/
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
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.
0