Hopefully someone can help me with this. I am a scripting idiot, but I think
a script is what I need for this task. I have 2 computers at home and about
12 hard drives that I need to hook up and search for files. I would guess
over the years, it could be in excess of 10000 and more of them. I would
like to have something that would search for the files by wildcard such as
*.doc or *.xls and *.ppt or whatever and when it finds them, move them to a
specific folder. A lot of them will be duplicates, so I would like it to
overwrite duplicate file names without a prompt so I could run this thing
and forget it. So, I would give it a file type and a drive letter to search
and then a folder name to move them to. Is a script the best way to do this,
or is another program available to do this. I have done a lot of searching
but don't much understand the code when I find something similar to what I
need, so I need a lot of help if possible.

Thanks,
Jerry

"Jerry" <jerry@xxxxxx> wrote in message
news:PWn2l.3037$jZ1.652@xxxxxx

> Hopefully someone can help me with this. I am a scripting idiot, but I
> think a script is what I need for this task. I have 2 computers at home
> and about 12 hard drives that I need to hook up and search for files. I
> would guess over the years, it could be in excess of 10000 and more of
> them. I would like to have something that would search for the files by
> wildcard such as *.doc or *.xls and *.ppt or whatever and when it finds
> them, move them to a specific folder. A lot of them will be duplicates, so
> I would like it to overwrite duplicate file names without a prompt so I
> could run this thing and forget it. So, I would give it a file type and a
> drive letter to search and then a folder name to move them to. Is a script
> the best way to do this, or is another program available to do this. I
> have done a lot of searching but don't much understand the code when I
> find something similar to what I need, so I need a lot of help if
> possible.
>
> Thanks,
> Jerry

If I understand you correctly then you wish to move all .doc files (for
example) to a "Documents" folder, regardless of their current location and
name. You can certainly do this with scripts but I have serious doubts about
such a move. Here are the two main reasons:
- Your action will destroy any folder structure that you might have
previously maintained on your disk. All .doc files will be tossed into one
big bucket.
- It is highly likely that you have duplicate names but that the files
contain completely different information. Your action will destroy all but
one of these files.

Do you still wish to go ahead?

"Jerry" <jerry@xxxxxx> wrote in message
news:hjc3l.3198$jZ1.627@xxxxxx

>

<snip>

>
> Overwriting if fine and what I would like to do. I just don't want to
> delete the source files until I am pretty sure I have one good copy. Then
> I would run the original script to copy and delete.

I assume that your requirements have firmed up in the meantime. Have you
been able to modify the script yourself during the past four days or do you
still require a modified script? If it is the latter, are there any other
changes you've been thinking of?

"Pegasus (MVP)" <I.can@xxxxxx> wrote in message
news:OScWixeZJHA.4520@xxxxxx

>
> "Jerry" <jerry@xxxxxx> wrote in message
> news:hjc3l.3198$jZ1.627@xxxxxx

>>

> <snip>

>>
>> Overwriting if fine and what I would like to do. I just don't want to
>> delete the source files until I am pretty sure I have one good copy. Then
>> I would run the original script to copy and delete.

>
> I assume that your requirements have firmed up in the meantime. Have you
> been able to modify the script yourself during the past four days or do
> you still require a modified script? If it is the latter, are there any
> other changes you've been thinking of?
>

I have run the script, and it errors out sometimes with the following:

line 21
Char 3
Permission denied
800A0046

This is line 21
For Each oFile In oFSO.GetFolder(sFolder).Files

I have changed the folder that receives the files and it will get more moved
before it errors again. In other words, the error is on different
files/folders and not always on the same ones. Can you help me understand
how to fix this? Is there a way for it to ignore the errors and keep finding
and moving files?
The file is run under an Admin account.

Thanks..

Hi can anybody help me as I am not a scripting guy.
I urgently need a script which can perform following tasks

1. Input Box for Source path(dropdown list of folders) and filename need to
be copied.

2. Input Box or Dropdown list for destination path.

3. Rename the existing file with filename_current system date.

4. Prompt if file in use

5. Input Box or dropdownlist to move the renamed file.

6. Copy and paste the new file.

7. Finish


Thanks in Advance

Virendra Sharma

"Virendra Sharma" <VirendraSharma@xxxxxx> wrote in
message news:CC72C139-ECE6-41A0-80E5-64749C1DD62B@xxxxxx

> Hi can anybody help me as I am not a scripting guy.
> I urgently need a script which can perform following tasks
>
> 1. Input Box for Source path(dropdown list of folders) and filename need
> to
> be copied.
>
> 2. Input Box or Dropdown list for destination path.
>
> 3. Rename the existing file with filename_current system date.
>
> 4. Prompt if file in use
>
> 5. Input Box or dropdownlist to move the renamed file.
>
> 6. Copy and paste the new file.
>
> 7. Finish
>
>
> Thanks in Advance
>
> Virendra Sharma

Newsgroups are intended to assist people with various issues, not a means to
get a free script that would take someone a couple of hours to write, debug,
test and implement. If I was in your position then I would either start
learning VB Scripts (and probably ask for a few hints here) or else pay
someone to do the job for me. Just my own personal opinion . . .

"Pegasus (MVP)" <I.can@xxxxxx> wrote in message
news:%232UL%23s%23eJHA.552@xxxxxx

>
> "Virendra Sharma" <VirendraSharma@xxxxxx> wrote in
> message news:CC72C139-ECE6-41A0-80E5-64749C1DD62B@xxxxxx

>> Hi can anybody help me as I am not a scripting guy.
>> I urgently need a script which can perform following tasks
>>
>> 1. Input Box for Source path(dropdown list of folders) and filename need
>> to
>> be copied.
>>
>> 2. Input Box or Dropdown list for destination path.
>>
>> 3. Rename the existing file with filename_current system date.
>>
>> 4. Prompt if file in use
>>
>> 5. Input Box or dropdownlist to move the renamed file.
>>
>> 6. Copy and paste the new file.
>>
>> 7. Finish
>>
>>
>> Thanks in Advance
>>
>> Virendra Sharma

>
> Newsgroups are intended to assist people with various issues, not a means
> to get a free script that would take someone a couple of hours to write,
> debug, test and implement. If I was in your position then I would either
> start learning VB Scripts (and probably ask for a few hints here) or else
> pay someone to do the job for me. Just my own personal opinion . . .

That's more than just your personal opinion.

On top of that, someone could easily write a script that does everything
asked by the OP, but fails to work in the OP's actual environment.

/Al