Tech Support Forum - View Single Post

**Glaswegian** · 07-19-2008, 03:22 PM

Hi Joe

It does appear that this is a problem unique to the combination of Vista and XL2007. I have found others who have reported that Vista/Excel seems to append the correct path to the dll on to the Excel file location. The indications are that this is indeed some kind of invalid registration of the dll file. Let's try re-registering the dll using the full path this time

As before, click Start > Run and copy/paste the following into the Run box

regsvr32.exe "c:\windows\system32\winhttp.dll"

Click OK - if all goes well you should receive a message something like

"DllRegisterServer in c:\windows\system32\winhttp.dll"

Then try adding the Reference again and see if the path is now correct.

07-19-2008, 03:22 PM	#10 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 21,651 OS: Win XP Pro SP3 My System Blog Entries: 10	Re: Broken VBAProject Reference Hi Joe It does appear that this is a problem unique to the combination of Vista and XL2007. I have found others who have reported that Vista/Excel seems to append the correct path to the dll on to the Excel file location. The indications are that this is indeed some kind of invalid registration of the dll file. Let's try re-registering the dll using the full path this time As before, click Start > Run and copy/paste the following into the Run box regsvr32.exe "c:\windows\system32\winhttp.dll" Click OK - if all goes well you should receive a message something like "DllRegisterServer in c:\windows\system32\winhttp.dll" Then try adding the Reference again and see if the path is now correct. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. Ad-Aware::SpywareBlaster::SpyBot::SpywareGuard::SnoopFree::AVG Free::HOSTS File::HijackThis::Donate::5 Steps For Infected PCs