 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2005spreadsheets
I am trying to use a spreadsheet object within a form. My goal is to write scripts, activated by buttons that will allow me to read data out of queries into the spreadsheet, edit it, and write the content of the spreadsheet out to the appropriate tables. -What VBA commands are available for reading and writing to a spreadsheet found within a form? You can embed an excel object in a form but do the processing offlline. Meaning you unbound the object when it;s saved and then open in code an excel object which you will use to open the file and parse for amended values. i'm not sure whether you can directly access the embeded object on the form so that's to be tested. - Raoul > I am trying to use a spreadsheet object within a form. My goal is to write > scripts, activated by buttons that will allow me to read data out of queries [quoted text clipped - 3 lines] > -What VBA commands are available for reading and writing to a spreadsheet > found within a form? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.