Read and write INI files

Ok I have these ini files for a access control system. We have 40 different systems. All on different databases. that look like the following:

Please Login or Register  to view this content.

So I want to read these in to an excel sheet like I have attached. Sort them and purge them togeather. and then write the ini file back out to update the system. Thank you for your help.

yes I have seen some examples, but not sure how to loop thru them. Everthing I have seen pertains to getting a value that is known.

Hello WHWALDREP,

If you post a copy of your workbook in Excel 2003 format, I can help you with this.

Thank you.

Hello WHWALDREP,

I have written 2 macro modules. One contains the API calls for the Provate Profile functions and the second contains the "ReadINI" and "WriteINI" commands that are attached to the buttons. The code for this macros is below. For those who are interested about the Private Profile functions, download the the workbook and read the notes I have included in the module "Read_Write_INI_Files".

You should know that init files typically don't use quotes as there are only 2 data types: Strings and Integers. The test file I created based on your example did not include the quotes. The empty line between sections was also removed as this doesn't conform to the API standard. It will read the information correctly, but the API WriteProfile functions don't include blanks between sections. Here is what the file looks like:

[bInitialization File Layout[/b]

Please Login or Register  to view this content.

Macro Code to Read aand Write the Init File

Please Login or Register  to view this content.

Thank you for your help