Can someone tell me what I am am doing wrong.
(as u will guess vb is not my strong point but it does work..up till now)
My script worked perfectly until I inserted:
DoCmd.Run Macro "imtempclwrtm"
Into the statement.
The script appears to ignore the Run macro command.
Heres the bit that doesnt work:
'move the file we have just imported out of the way(so we don't import it again)
Name "d:\price\" & filename As "d:\price\done\" & filename
DoEvents
'calculate the classfig and ratings
DoCMD.RunMacro "imtempclwrtm"
'make sure that operation is finished before continuing:
'loop back if there is another file:
Wend
(as u will guess vb is not my strong point but it does work..up till now)
My script worked perfectly until I inserted:
DoCmd.Run Macro "imtempclwrtm"
Into the statement.
The script appears to ignore the Run macro command.
Heres the bit that doesnt work:
'move the file we have just imported out of the way(so we don't import it again)
Name "d:\price\" & filename As "d:\price\done\" & filename
DoEvents
'calculate the classfig and ratings
DoCMD.RunMacro "imtempclwrtm"
'make sure that operation is finished before continuing:
'loop back if there is another file:
Wend