Hi folks

I have a BATCH code which should copy the filename of a file when dropped onto it and paste it into a specific Excel sheet.

The coding is as follows...

BATCH CODE:
Please Login or Register  to view this content.
THE VBS SCRIPT:
Please Login or Register  to view this content.
Then Finally the Macro in Excel:

Please Login or Register  to view this content.
Now, this worked a few weeks ago, and now for some reason I get a PASTESPECIAL METHOD OF RANGE CLASS FAILED error message and i dont know why!!!

The batch code seems to be copying the filename to the clipboard, but i can only assume it then loses it somewhere along the line.

I dont get why its suddenly not working!

Please help with this - or suggest a different way of doing it??

Thanks very much