Its been a while since coming here as I have managed to solve many Excel VBA problems I have had but can not get my head around this.
The following problem is during using Excel 2003 SP3 on a Windows 7 64 bit machine.
I find this version of Excel much easier to work with but reading around the internet believe this issue may affect all versions of Excel & VBA.
I must admit, this code is not all my own work, some had been found looking on the net and this site, the principle is still the same though.
I am trying to move one file at a time between 2 folders using VBA, the file choice is listed including the file extension down an Excel column and
produced by running another code which looks inside a folder and lists its contents.
When I right mouse click the cell with a file name in, it uses the cell contents as its string then is supposed to move the file.
I have tried this on TXT files and PDF files and this does work but only works the first time, I have tried clearing the cache, clipboard etc but still
can not get the macro to run move 2 files one after the other.
Is there a limit to the size of file VBA can move or is it something I am not doing right.
if anybody has experienced anything like this and have managed to find a solution, please can you assist.
In the Worksheet Objects I have written the following:
For the macro I have written the following:HTML Code:
I have written within the macro where the folder locations are.HTML Code:
Hopefully is something I am missing.
Bookmarks