Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

importting excel 97 to access 97

Status
Not open for further replies.

thewishla

MIS
Jan 17, 2002
12
GB
I am new to Vb and would like to know the code that will let me transfer a whole load of spreadsheets all of which are stored in the same directory C:\Temp\backup\ and all of which start their filename with backup and end with xlk. I also need to be able to turn off ay warning messages that access comes up with since during the transfer I will be deleting some unused cells.

I need to have this cracked by Sunday at 2 so if you don't have time to answer maybe you could point me to a useful source of info.

cheers and heres hoping.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top