The aim of the project is to transfer a "text" format booklet into
Excel format as attached ([url removed, login to view]).The "text" format booklet is
exactly the same layout as the attached Excel file excepted
1. Each chapter of the "text'" format booklet will create it own
Excel File (multiple worksheets). Attached Excel File is only one of
2. The Page layout of the Excel File ( eg. Frame, Logo graphic ) is
copied from pre-defined Excel File as attached ( booklet [url removed, login to view] )
The flow of the program will be :
1. a .csv file is created with
a. The Excel file which will be created for the chapter (
with "Name" for each worksheet )
b. The worksheet no. and page layout ( file name eg.
booklet [url removed, login to view]) used for each page
c. The content of each page which need to transfer to the Excel File
2. The .csv file will be opened in Excel and the macro will be
executed to create the Excel Booklet in multiple files.
That's only the preliminary idea on how it work. Please suggest if you
have any ideal to simplify it.
50 freelancers are bidding on average $76 for this job
Hi, I'm VBA expert and have more experience, I'm interested in Your Project and wish to work on your Project as desired you. I'll wait for your response. Thanks