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

Luke,
VBA does not have a "System" object. If you are something .Net, that's
another thing.
Anyway, try:
http://www.exceltip.com/st/Private_P...iles_using_VBA
_in_Microsoft_Excel/490.html

NickHK

"LukeCarvey" wrote in message
...
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.