Access 2003 - Embedded ppt slide or Excel Spreadsheet in a form, how do I communicate?
- by Justin
So if I was to take a an access form, and embed either an excel spreadsheet into it, or a powerpoint slide/pres, how would I reference it in VBA code?
So I know I have to set the libraries, name the frame of the OLE object, and use applicable syntax to whatever I want to do, with whatever I stick in the form, however the only things I have ever done with excel and/or powerpoint is automate the opening of a seperate window/application from access, not within the access form....so I am not sure??
if I said its a new Excel.Application, then set xls = to (the ss in the file, and not some file path of another excel file somewhere)?
does that make sense?