Previous Topic Next Topic

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
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 :)

Related:

2 responses

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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Create folder in desktop with vba, if exist, ignore
viriato74 -
praveen -

6 responses