Hi,
What I am trying to do is make excel look for a file in a directory. In the said directory are other numbered files (ex 1.xls, 2.xls, 3.xls, 4.xls etc.). I want Excel to find the largest numbered file (in the ex, it would be 4.xls) and save the file as the last numbered file plus 1 (so in the ex it would save the file as 5.xls). I'm not sure if you can do that in VB or not.
Thanks
Joe
What I am trying to do is make excel look for a file in a directory. In the said directory are other numbered files (ex 1.xls, 2.xls, 3.xls, 4.xls etc.). I want Excel to find the largest numbered file (in the ex, it would be 4.xls) and save the file as the last numbered file plus 1 (so in the ex it would save the file as 5.xls). I'm not sure if you can do that in VB or not.
Thanks
Joe