D
Desperate
I have a spreadsheet that has an "Update" command button
on it. When clicked, I want to go out,(using ADO )or ODBC
if I have to) to a database on a server, retrieve
the "Parts" table from this db, and then create a new
spreadsheet at C:\temp (or copy over/update this
spreadsheet 'PartMaster.xls' if it already exists)
I need this to all happen behind the scenes with VBA- not
manually by a user.
Can anyone PLEASE give me some help on how to do this??
Any code samples would be GREATLY appreciated!!
TIA,
Joey
on it. When clicked, I want to go out,(using ADO )or ODBC
if I have to) to a database on a server, retrieve
the "Parts" table from this db, and then create a new
spreadsheet at C:\temp (or copy over/update this
spreadsheet 'PartMaster.xls' if it already exists)
I need this to all happen behind the scenes with VBA- not
manually by a user.
Can anyone PLEASE give me some help on how to do this??
Any code samples would be GREATLY appreciated!!
TIA,
Joey