Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where to put / register a 3rd-party activeX component for use in Excel2010 | Excel Programming | |||
Point to My Docs in Win7/XP, Excel 03/07 | Excel Programming | |||
Excel 2007 + PIA + Win7 + VS2010 = yikes!?!? | Excel Programming | |||
How to open Two copies of Excel under Win7 | Excel Discussion (Misc queries) | |||
New Win7 computer problems | Excel Programming |