View Single Post
 
Old 07-25-2018, 02:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Guessed View Post
I wouldn't normally create the xlApp in the same line as the declaration of the variable. Could that be the issue?
Unlikely.
Quote:
Originally Posted by Guessed View Post
This thread http://www.vbforums.com/showthread.p...ice-pack-error seems to encounter a similar error and potentially relates to an upgraded version of Excel causing confusion with the one line declaration and creation of the application object.
On my reading of that thread, the issue there actually concerned late binding with VB6/NET vs early binding with VBA.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]