Conflicting Libraries in VBA References
Hi everyone,
I have been working on a large scale Access app which extracts data from word documents.
Last night I added some functionality to export data to a formated Excel sheet. The problem is that the libraries are conflicting, and unless I move the Excel Library ahead of the Word Library in priority, I get an error. Specifically the problem I am having is when I select a cell, and then do a Selection.Value = "Some Text Here", I get a compile Error - Method or Function not found
Is there a way to implicitly call the Selection Object referecing either the Excel or the Word library?
Thanks
Mike
Mike
EchoVue.com
__________________
Mike
EchoVue.com
|