Link to home
Start Free TrialLog in
Avatar of happylife1234
happylife1234

asked on

Excel needs to open a fixed length format file

I have a fixed length format file that needs to be modified. I would like to open the file using excel and then edit it and then save it back in the same format.

Can anyone tell me what is the easiest way to do this.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of inthedark
inthedark
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You should be able to open the file with a fixed field format.  Can you open the file correctly?
Revision to method 3:

The following should be corrected:

Dim AllRecords(lRecordCount) As MyRecordDef

As follows:

Dim AllRecords() As MyRecordDef

Redim AllRecords(lRecordCount-1)
I think the inthedark comment http:#34914521 is complete and answers the question
Avatar of Mike McCracken
Mike McCracken

Thanks Mark.  I thought so also but want a second opinion and was hoping it would be the asker.

mlmcc
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.