Excel to .ini export or creation.

**mo.insane** · 05-26-2013, 04:37 AM

Hello Excel Users.

I have a requirement to create an .ini file from the data entered in the excel workbook.
I'm attaching both .ini & excel files to get an idea about what i'm trying to achieve.

On click of a button, an .ini file will be generated at C:\data\012345.ini with the information populated in excel file.

Following should be contained in an .ini file generated through excel file:
-------------------------------------------------------------------------------------------

[EWB]
JobInfoLine1=L1
JobInfoLine2=L2
JobInfoLine3=L3
JobNumber=USB-012345
OfficeAddress=XYZ.
Architect=A.
Drafter=A.
Engineer=A.
Contractor=A.
SysEngineer=E.
InstSupervisor=I.
Language=English
-------------------------------------------------------------------------------------------

Thank you in advance.

Best Regards,

Mo

**Ed_Collins** · 05-26-2013, 03:19 PM

Hi Mo,

Question... You attached an ini.xls file. Normally an ini file, as I've always understood them, is just an ascii text file.

http://en.wikipedia.org/wiki/INI_file

Also, in your example, shouldn't Drafter = D, Engineer = A, Contractor = C, and SysEngineer = S? To clarify, shouldn't they equal the data that exists in the corresponding Excel rows? Why are these guys all "As?"

Anyway, this code creates an ascii text file that matches your example, in your c:\data folder. (Note that there is no error checking... it assumes you do HAVE a C:\data folder.)

Also, as you can see, the code is not in a loop - it's only going to create the one file - and I'm assuming you probably want it to be in a loop to create multiple files. But you only supplied one record and I don't know or where or how the next record might begin.

You can assign the code to the click of a button.

Please Login or Register  to view this content.

**Leith Ross** · 05-26-2013, 03:45 PM

Hello mo.insane,

Welcome to the Forum!

I follow you on the creating/updating the init file from the workbook "USB-012345.xls". What I don't understand is the "ini.xls" workbook. Will this workbook be used with or add to the other workbook? Will this be used on systems later than Windows XP?

**mo.insane** · 05-26-2013, 05:50 PM

Hello Leith.

Thank you for the reply.
I missed to mention that i attached .ini file in excel file for the reason that excelforum didn't allow me attaching .ini file directly.

Best Regards,

Mo

**mo.insane** · 05-26-2013, 05:59 PM

Hello Ed_Collins.
You are right about .ini files. I missed to mention that i've attached .ini in excel file for the reason excelforum doesn't allow me attaching .ini files.
You are also right about Drafter = D, Engineer = A, Contractor = C, and SysEngineer = S?.
In current situation, i'm fine without looping. The code is working inline with the requirement.
I'm really happy and thankful.

Best Regards,

Mo

**arlu1201** · 05-27-2013, 03:51 PM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.