Access/Excel/ole - Automation with a twist!

M

Mark Stephenson

Hi,

Firstly, im not entirely sure what I want to do is possible - but we will
give it a bash anyway!

I want a form to open which loads an excel file into an area (ole unbound) -
this bit ive been able to do with variying degrees of sucess...

I then want to be able to click cells within the excel document, within the
ole window and capture the values of those cells within the access form.

Is this possible? Im basically wanting to be able to create a set of
templates so that I can later iterate through specific cells and normalise
into a table...

Please let me know if you need anything clarifying.

Many thanks,



Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Need Help with a VBA subroutine 0
How to Link Outlook items to Access OLE field 9
Dynamic form 3
Pasting a cell into bookmarked table from excel vba 1
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Excel hart has OLE onject errors in Access 2007 0

Top