LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Problem with FTP commands in Win7+Excel2010 (VBA)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where to put / register a 3rd-party activeX component for use in Excel2010 Heinz-Guenter Lamy Excel Programming 1 June 20th 11 01:05 AM
Point to My Docs in Win7/XP, Excel 03/07 MikeZz Excel Programming 1 April 8th 10 09:01 PM
Excel 2007 + PIA + Win7 + VS2010 = yikes!?!? sfun28 Excel Programming 0 February 5th 10 02:59 PM
How to open Two copies of Excel under Win7 Roger Excel Discussion (Misc queries) 6 December 26th 09 04:52 PM
New Win7 computer problems Jim Cone[_2_] Excel Programming 1 December 14th 09 11:42 PM


All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"