Does Excel VBA =differ= in different Office editions?

down load the latest service pack from ms maybe?

Hi, mark99k,

due to the different distributions it might be possible that this feature is delivered with Access, installed and available on your PC but not with H&S.

Ciao,
Holger

OK, there is a way; figured it with help from another board. For anyone looking, the fix isn't as straightforward as it seems. (Choosing install from a right-click of the .INF file doesn't do it.) Steps:

Download mscomct2.cab from http://support.microsoft.com/kb/297381
Open the mscomct2.cab file and extract the file mscomct2.ocx.
Save it in the Excel program folder (the place where EXCEL.EXE lives).
For Office 2010 this is typically: C:\Program Files (x86)\Microsoft Office\Office14
Click Start> Programs> Accessories, and RIGHT-CLICK Command Prompt
Click Run as Administrator
In the command prompt window, type (or paste)* this line:

%systemroot%\SysWoW64\regsvr32.exe "EXCEL_FOLDER_PATH_HERE\MSCOMCT2.OCX"
(Quotes are required.)

Wait for the "Succeeded" message.

*To paste in the command prompt window, press ALT+Spacebar and choose Edit> Paste

Originally Posted by mark99k

Argh. Probably right. Thanks Holger.

Hello mark99k,

HP has their own way of doing things and when you throw Windows into the mix ... BOOM! It blows up it in your face. HP should have stuck to what they did best - making test equipment, calculators, and printers.

I too have suffered the tortures of upgrading HP machines and getting them to work normally. There are 2 options I employ. One, replace the computer with another brand. Two, if one is not an option then erase the operating system and install Windows from scratch. If the first two options fail then take out your frustrations on the machine as you see fit. Your client won't have a computer but you will still have your sanity!