Lars Thomsen laid this down on his screen :
In Excel2010 and Win7 I get error in my macro when I try to upload. The same
Excel file works fine on PC with Excel2010 and WinXP. The problem comes when
I type the following command:
Set FTP = New Inet
Then I get the error "Run-time error '429 'ActiveX component can not create
object ".
I have both machines set reference "Microsoft Internet Transfer Control 6.0
"in VBE editor
I don't see this listed on my XP SP3 machine. I use this machine for
development as it has MS Office 9 through 12 installed, plus Visual
Studio 6.0 and Visual Studio 2008. How did this come to be on your
machine?
There should be a work-around described by MS
(http://support.microsoft.com/kb/281848), but when trying to create the
reference to "comdlg32.ocx". Through the Toolbox on a UserForm I right click
on the "toolbox" and adds "MS Common Dialog Controls ", but when I want the
new control in UserForm I get this error, which I also can not solve:
"The Controller Could not be created because it is not properly licensed"
I have tried the following script:
regsvr32% Systemroot% \ System32 \ comdlg32.ocx
I am told that it was registered, but I still get the license error :-(
Can anyone help me or do you alternatively, know other code that can be used
for uploading files to the server via VBA?
Best regards
Lars
Now, since you read the part about the design time license.., what that
means is if you do not have any of the listed products installed that
give you that license then you can't use the comdlg32.ocx control. If
it happens to be installed on the Win7 machine and properly registered,
you can reference it in the VBE but you can't use it without the design
time license that ships with those listed products. Note, however, that
there is a MS support statement issued
(
http://msdn.microsoft.com/en-us/vstudio/ms788708) that says many of
the controls that were shipped with those listed products would NOT be
included in Vista/Win7/Win8. (However, contrary to the support
statement, I see in my Win7 machine that the controls are there in both
System32 and SysWOW64)
Fortunately, I happen to have all of the listed products and so I have
developer licenses up the wazu! The only way you can get use of this
ocx is to buy and install one of the listed products. Fortunately
they're available cheap on ebay for early versions. I paid through the
nose ($1400) for Microsoft Office 2000 Developer Edition but I was able
to buy Visual Studio 6.0 and Visual Studio 2008 really cheap (each
under $200) on ebay.
HTH
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc