Import Data into New Excel Spreadsheets??

[jennuhw]

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....

 

[Segfault7375]

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 (

http://www.tek-tips.com/gthreadminder.cfm/lev2/3/lev3/18/pid/68)

and you will most likely get a pretty detailed answer.

Hope that helps,
Segfault

 

[jennuhw]

I realized that I posted the wrong forum after I asked. I did also put it in the correct one. Just wasn't paying attention! |-I