Hi,
When I used statement like "Application.Dialogs.Item(xlDialogOpen).Show , False, True", it works fine and able to call up "open file" dialog box.
But when I used statement
"Application.Dialogs.Item(xlDialogOpenText).Show"
OR even with parameter as
"Application.Dialogs.Item(xlDialogOpenText).Show "C:\T.txt", 437, 2, xlDelimited, xlDoubleQuote, False, True, True, Flase, False, False, , Array(Array(1, 1), Array(2, 1)")
it don't work. It pop up error message saying "Run Time Error 1004. Application-defined or object defined error". Please let me know what going wrong and how to solve it?
Thanks.
Bookmarks