Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 10th, 2006, 10:36 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default 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
 
Old July 11th, 2006, 10:56 AM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 142
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You should be able to do it by using LibraryName.MethodName






Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible Conflicting Callbacks wirerider ASP.NET 2.0 Professional 0 March 15th, 2007 10:35 AM
VBA References muki Beginning VB 6 3 May 16th, 2006 03:32 AM
VBA References bobtherr Excel VBA 2 February 18th, 2005 09:33 AM
Conflicting References.... john_hearn Access VBA 0 April 21st, 2004 07:08 AM
Access VBA References LoriBee Access VBA 1 September 17th, 2003 04:54 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.