Move multiple files onto Sharepoint Site

[crook_101]

Hi,

I have about 180 files that need to be moved/updated regularly from a workstation to a sharepoint site. Each of the files has to be moved to its own folder so it is a bit of a chore - does anyone have any VBA that I could adapt to complete this task??

FIle name(s) follow the naming convention "Bonus Date N0101", "Bonus Date N0102" etc
Folder names on the sharpoint site are named ".......N0101",".......N0102" etc

So "Bonus Date N0101" needs to be uploaded to ".......N0101" folder, etc

Any thoughts??

Regards,
Ian

 

[crook_101]

Hi again,

Just to bump this one so a different part of the world gets to see it!!

Any ideas much appreciated.

Cheers,
Ian