PasteSpecial from a Batch Code failed

Hi folks

This one is doing my head in now!

I had the below piece of code in a spreadsheet that just listed names of files that had been updated.

The code is ran by dragging a file (PDF, DOC, XLS) onto a BATCH file which copied the filename to the clipboard then ran a VBS script which opened this spreadsheet and used the SELECTION.PASTESPECIAL to paste the filename into the spreadsheet.

It has been working fine up until now and i have no idea why - its bring an error on the SELECTION.PASTESPECIAL line - "PasteSpecial method of range class failed"

Can anyone help, as i have made no changes to anything - its just stopped working!!

Please Login or Register  to view this content.

Thanks

Remove these two lines

Please Login or Register  to view this content.

and replace them with

Please Login or Register  to view this content.

Tried that, didnt work - got a feeling its not COPYING anything, hence the error.

Will have to revert back to my Batch code.

Thanks anyway!

Yes, of course, I assumed that you have a line above this line with copy method.