Home > Forum Home > Developing Business Administration Solutions > Run Time Error 438 in Excel 2007 > Object methods changed in Excel 2007 Share

Object methods changed in Excel 2007

Excel Help for Object Methods Changed In Excel 2007 in Developing Business Administration Solutions


Forum TopicLogin

Object Methods Changed In Excel 2007

Rate this:
(3/5 from 1 vote)
SadThe object methods are different in Excel 2007.  In this case .LookIn should be changed to:

VBA Code:
.InitialFileName = PTH2

Nevertheless, you will likely encounter other invalid object methods further in the code.

The object members for the FileDialog object in Excel 2007 are:
Methods: Execute, Show
Properties: AllowMultiSelect, AllowMultiSelect, Application, ButtonName, Creator, DialogType, FilterIndex, Filters, InitialFileName, InitialView, Item, Parent, SelectedItems, Title
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Object methods changed in Excel 2007 in the