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