Solved COM Add-Ins for Excel Student Edition

Golden

000
VIP
SF Team
Local time
3:27 AM
Messages
19,301
Location
South Australia
Hi Everyone,

A colleague recently wrote a COM Add-In for me which reads share information from a TXT file and places it into selected cells in my worksheet. This is on a PC running:
- Win7 x64 Ultimate
- Microsoft Office 2010 Professional x64
Everything works perfectly.

I tried to share this COM add-in with a friend who runs the following system:
- Win7 x64 Home Premium
- Microsoft Office Home and Student 2010
However, I cannot, for some unknown reason, get the Add-In to display as shown in the attached image. All I get is a blank despite trying to add, and browsing to the correct file location.

I have tried this several times now, as administrator, and after closing and reopening Excel. The PC is a very recent build (2 days ago). I've exhausted all my knowledge.

Am I missing something? Is there a limitation to COM Add-Ins in Microsoft Home and Student 2010?

Thnaks,
Golden
 

Attachments

  • COM OK.PNG
    COM OK.PNG
    10.5 KB · Views: 13

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Golden Mk. I.4
OS
Windows 10 Pro x64 ; Xubuntu x64
CPU
Intel i7 860 @ 2.80 GHz O/C'ed to 4.0GHz
Motherboard
Gigabyte P55A-UD3R Rev.1. Award BIOS F13
Memory
16GB Corsair Vengance DDR3 @ 661 MHz Dual Channel (9-9-9-24)
Graphics Card(s)
EVGA NVidia GTX 560 1024MB
Sound Card
Realtek Integrated
Monitor(s) Displays
Dual Samsung SyncMaster 2494HS
Screen Resolution
1920*1080 and 1920*1080
Hard Drives
1*Samsung 840 EVO 120GB SSD;
1*OCZ Vertex 2 60GB SSD;
2*Samsung F3 SpinPoint 1TB in RAID0;
1*Samsung F1 SpinPoint 1TB;
2*Western Digital 1TB External USB 3.0
1*Western Digital 500GB External USB 3.0
1*Seagate 500GB External USB 2.0
PSU
Thermaltake ToughPower QFan 750W
Case
Thermaltake Element S VK60001W2Z
Cooling
Corsair H60 Water Cooling, 2*230mm and 2*80mm case fans
Keyboard
Logitech G110
Mouse
Logitech MX518
I eventually found the solution to the problem : UAC has to be turned OFF to get the Automation Add-In to install.
 

My Computer My Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Golden Mk. I.4
OS
Windows 10 Pro x64 ; Xubuntu x64
CPU
Intel i7 860 @ 2.80 GHz O/C'ed to 4.0GHz
Motherboard
Gigabyte P55A-UD3R Rev.1. Award BIOS F13
Memory
16GB Corsair Vengance DDR3 @ 661 MHz Dual Channel (9-9-9-24)
Graphics Card(s)
EVGA NVidia GTX 560 1024MB
Sound Card
Realtek Integrated
Monitor(s) Displays
Dual Samsung SyncMaster 2494HS
Screen Resolution
1920*1080 and 1920*1080
Hard Drives
1*Samsung 840 EVO 120GB SSD;
1*OCZ Vertex 2 60GB SSD;
2*Samsung F3 SpinPoint 1TB in RAID0;
1*Samsung F1 SpinPoint 1TB;
2*Western Digital 1TB External USB 3.0
1*Western Digital 500GB External USB 3.0
1*Seagate 500GB External USB 2.0
PSU
Thermaltake ToughPower QFan 750W
Case
Thermaltake Element S VK60001W2Z
Cooling
Corsair H60 Water Cooling, 2*230mm and 2*80mm case fans
Keyboard
Logitech G110
Mouse
Logitech MX518
Thanks for posting your solution. :)

Have a great day and regards
 

My Computer My Computer

Computer Manufacturer/Model Number
Custom
OS
Win7 HP (x64)/Win7 Ultimate (x64)
CPU
Core i7 920
Motherboard
Intel X58
Memory
6 x 2GB Corsair XMS3
Graphics Card(s)
CF HD4890
Sound Card
Asus Xonar
Monitor(s) Displays
Dell 2408WFP
Screen Resolution
1920 x 1200
Hard Drives
2 x 150GB WDC Velociraptors (Raid 0)
1 x 1TB Seagate
1 x 1.5TB Seagate
PSU
Corsair HX1000W
Case
Antec 1200
Keyboard
Razer Lycosa/N52te
Mouse
Razer Lachesis
Back
Top