Dear Tim and Bob,
Thanks for your prompt replies. I do have the Option worksheet stated
the Dbase file and Dbase Sheets.
The error occured on "
Sheets("Payment").Activate.Range("A4:A" & TB_Rec&, "C4:C" & TB_Rec). _
Copy Destination:=Workbooks(DBase_File).Sheets(Dbase_Sh t).Range("A1")
That is when I want to write the data to the Database file.
May I know can the VBA program write the data to the Database file
(with Extension .dbf) ? The error seems that it does not find the
database even I have already opened it.
Please advise.
Thanks & Regards
Friend8899
--
friend8899
------------------------------------------------------------------------
friend8899's Profile:
http://www.excelforum.com/member.php...o&userid=24233
View this thread:
http://www.excelforum.com/showthread...hreadid=378465