| | Part of my VB program is written with : '(1) open Excel files currentDate = Format(Date, "YYYY") & " " & Format(Date, "MM") & " " & Format(Date, "DD") & " " & "0000" & " " & "(WIDE)" filePath = "C:\nbutane\rsview\DLGLOG\RSVIEW\" & currentDate & ".dbf" When the VB executes, it'll open the file called 2001 11 23 0000 (Wide) with Excel. My problem is when the file name changed to 2001 11 23 0001 (Wide) , the VB can't access it because it's reading from '0000'. Sometimes the file will change to '0002' .... and so on. Please help. Thanks. |


