We have a standard document that needs to be filled out for a customer for every quote made to them. Is there a way to automate inputing the new data and saving from another spreadsheet or Access database? The original document always keeps the same cell placement, but the data changes constantly. I hope I explained this right....
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!
Import Data into New Excel Spreadsheets??
- Thread starter jennuhw
- Start date
Segfault7375
Programmer
Yes, you can use VBA to pull information from an Access datbase to an Excel spreadsheet. As this is the Windows 2000 forum, you will probably want to ask this in the Microsoft Office forum ( and you will most likely get a pretty detailed answer.
Hope that helps,
Segfault
Hope that helps,
Segfault
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
