CalvinGraham
Board Regular
- Joined
- Jan 27, 2010
- Messages
- 67
Hi,
I can't seem to spot an existing thread on this, if I'm wrong then do refer me.
Anyway, I've got an Excel file that I've documented my Excel/SQL work in and I wanted to pull through Access linkages into it. Essentially, I want to have an Excel sub that looks at an access database, scans the text in the modules/forms and pulls out the SQL references in them. I could pull this from the Access Module text using basic search techniques, looking for indicators like "sqlproc_foobar" or "FROM dbo.foobar" etc - that part's simple enough. What I can't seem to do is import the Access modules to an excel string variable.
I did some work with Word ages back and I'm aware of the refernces thing you have to tick and the VBE concept (including the dangers of it!). However, can't get my head around the various object types and was hoping someone had an off the shelf example?
I can't seem to spot an existing thread on this, if I'm wrong then do refer me.
Anyway, I've got an Excel file that I've documented my Excel/SQL work in and I wanted to pull through Access linkages into it. Essentially, I want to have an Excel sub that looks at an access database, scans the text in the modules/forms and pulls out the SQL references in them. I could pull this from the Access Module text using basic search techniques, looking for indicators like "sqlproc_foobar" or "FROM dbo.foobar" etc - that part's simple enough. What I can't seem to do is import the Access modules to an excel string variable.
I did some work with Word ages back and I'm aware of the refernces thing you have to tick and the VBE concept (including the dangers of it!). However, can't get my head around the various object types and was hoping someone had an off the shelf example?
