Software

Ask something
Discussion Locked

Getting Access and Excel to talk

0 helpful
3 replies

by jvdewaard

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Forgive me. I am a REAL newbie.
1. An Access 2000 db: holds data on clients and info on quotes.
2. 4 or more Spreadsheets(in one WkBk)calculates various pricings. These "qoutes" must be controled by a unique ID, which is supposed to be provided bythe Db. Then the quote is saved as an html file, which must be stored back into the db where it is connected to that customer.
NOW the questions:
If the db has the ID#, how do i get the spreadsheet "invoice page" to get that info into , say Cell "B3"? And then when i save the file how do i get it to save into the 'copy" field in the db, this should be a direct save with little user interaction as possible. any code snippets and the proper way to use them would be a bigg help.
Have already tried macros,and i don't understand how/what a module does or is.
Thanks
John

3 replies

by jvdewaard

Thanks, not exactly what i needed but it does get the job done.
also I appreciate the response to this question and the last one,but i may not have credited your account for that one, still trying to get the hang of this forum
John

This discussion is closed to new replies.