General discussion

Locked

Getting Access and Excel to talk

By jvdewaard ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Getting Access and Excel to talk

by DKlippert In reply to Getting Access and Excel ...

Go to Data>Get External Data - New Database Query

Collapse -

Getting Access and Excel to talk

by jvdewaard In reply to Getting Access and Excel ...

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

Collapse -

Getting Access and Excel to talk

by jvdewaard In reply to Getting Access and Excel ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums