View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LukeCarvey LukeCarvey is offline
external usenet poster
 
Posts: 2
Default Error using Word object library in Excel (VBA)

I need to use the PrivateProfileString() function contained within the
'System' object to read/write an .ini file. I have referenced the relevant
Word object library to Excel but the function only works whilst Word is open.
I get the following (common) error:

Run-time Error 429; ActiveX component can't create object.

Can I actually read/write an .ini file using VBA in Excel? Would be greatful
for any help.