Vasi04
asked on
Replacing old file with new file
Need help writing code.
Each user has a separate folder (user1, user2, user3, etc.)
There are two folders under each user (folder1, folder2)
I want to write a VB program (standard.exe) to replace files in folder1 (file1_user1.txt and file2_user2.txt) and in folder2 (file3_user3.txt) with new files in folder1 (newfile1_user1.txt, newfile2_user2.txt) and folder2 (newfile3_user3.txt)
Path is C:\User1\folder1 and fodler2
C:\User2\folder1 and fodler2
C:\User3\folder1 and fodler2
..
..
Which user gets which file replaced depends on "_user" in the filename
For example: John has folders "c:\John\folder1" and ...\folder2
HIs files in folder1 are file1_John.txt, file2_John.txt and file in folder2 is file3_John.txt
These files are replaced with newfile_John.txt
"_" is common to all files
Could you please help with code?
Each user has a separate folder (user1, user2, user3, etc.)
There are two folders under each user (folder1, folder2)
I want to write a VB program (standard.exe) to replace files in folder1 (file1_user1.txt and file2_user2.txt) and in folder2 (file3_user3.txt) with new files in folder1 (newfile1_user1.txt, newfile2_user2.txt) and folder2 (newfile3_user3.txt)
Path is C:\User1\folder1 and fodler2
C:\User2\folder1 and fodler2
C:\User3\folder1 and fodler2
..
..
Which user gets which file replaced depends on "_user" in the filename
For example: John has folders "c:\John\folder1" and ...\folder2
HIs files in folder1 are file1_John.txt, file2_John.txt and file in folder2 is file3_John.txt
These files are replaced with newfile_John.txt
"_" is common to all files
Could you please help with code?
What code have you got so far?
ASKER
Can anyone please help me with code.
FYI, I am NOT an IT guy.
I am a normal commerce guy trying to do things on my own.
Thanks a lot.
FYI, I am NOT an IT guy.
I am a normal commerce guy trying to do things on my own.
Thanks a lot.
Is this a one-time batch or a regular task. If it is a one time task then you may want to just do it by hand. This is a simple program but it sounds like you need full source code.
Are the three files all replaced with the same file or should one of your last lines have read:
These files are replaced with newfile1_John.txt, newfile2_John.txt, and newfile3_John.txt
?
Are the three files all replaced with the same file or should one of your last lines have read:
These files are replaced with newfile1_John.txt, newfile2_John.txt, and newfile3_John.txt
?
ASKER
Hi Prestaul,
>>These files are replaced with newfile1_John.txt, newfile2_John.txt, and newfile3_John.txt
Replaced with different file names
Batch job? You mean, program which runs according to a schedule.
.exe program can be made to run every week or so?
I would be grateful to you, if you could provide me with full code. Thanks again
>>These files are replaced with newfile1_John.txt, newfile2_John.txt, and newfile3_John.txt
Replaced with different file names
Batch job? You mean, program which runs according to a schedule.
.exe program can be made to run every week or so?
I would be grateful to you, if you could provide me with full code. Thanks again
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kill FileName 'deletes FileName