Hello all,
This website explains what I am trying to do.
http://www.ashishmathur.com/generate...out-using-vba/
I have excel 2007. So I am using the second solution for all versions of MS Excel.
Step 2 does not work however, I am wondering if it's because the folder name is in Chinese for me.
Example:
=FILES("C:\Documents and Settings\Administrator\桌面\Mich\*.xls")&T(NOW())
Thank you!!
Bookmarks