Excel to Excel Data transfer without opening any of the files(source or target)

[Rick Rothstein]

Thanks for the corrected code... much appreciated.

By the way, for this line of code...

strFileExt = Mid(strOutPutFileFullName, InStrRev(strOutPutFileFullName, ".", -1, vbTextCompare), Len(strOutPutFileFullName))

you can omit the last two arguments for the InStrRev function call... the next to last argument defaults to -1 when omitted and since you are searching for a "dot", you don't need to to a "text compare" (which slows down the InStrRev function). So, I would write that line like this...

strFileExt = Mid(strOutPutFileFullName, InStrRev(strOutPutFileFullName, "."), Len(strOutPutFileFullName))

[Transformer]

In case of XL2007 it will be able to transfer data between xlsx and xls files both but in case of XL2003 it can transfer between xls files only.

[Admin]

Hi Transformer,

Great work !!

[technicalupload]

Hi Transformer

Highly impressive

Thanks!

[sbglobal2012]

Expediently, I set a certain time with task scheduler. When the time is up, Macro Expert automates to transfer data from excel to the website.