worksheetfunction not working when controlling excel from word.

		Microsoft Office Forums > Microsoft Word > Word VBA
worksheetfunction not working when controlling excel from word.

05-22-2016, 11:05 PM

macropod

Windows 7 64bit worksheetfunction not working when controlling excel from word.

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,523

Instead of:
Application.worksheetfunction
you should be using:
xlApp.WorksheetFunction

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word to Excel Links Stop Working	DAC8190	Word	1	10-08-2015 05:56 PM
Controlling Widows (single-word lines at the end of a paragraph)	downtownbooks	Word	2	12-09-2014 03:57 PM
Word and Excel stopped working	judyn	Office	9	04-23-2013 05:10 AM
Controlling search option in word	suvvi	Word	0	08-05-2011 06:10 AM
working with excel tables in MS word	radman154	Word Tables	1	03-25-2011 12:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:54 PM.