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
Related:
- VBA for excel
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Vba case like - Guide
- Excel date format dd.mm.yyyy - Guide
- Kernel for excel - Download - Backup and recovery
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