Excel process

[Dave]

I have a spreadsheet process that reorganizes a spreadsheet by irst saving
the contents to a .csv file, processing the file in a Visual Basic program,
creating another .csv file and then displaying the file again in Excel.
Can't I just perform the process within Excel?

[Pete_UK]

Yes, of course you could - it depends what you mean by "re-organising"
the file. Can you give us some further details of what this process
entails?

Pete

Dave wrote:
> I have a spreadsheet process that reorganizes a spreadsheet by irst saving
> the contents to a .csv file, processing the file in a Visual Basic program,
> creating another .csv file and then displaying the file again in Excel.
> Can't I just perform the process within Excel?

[Dave]

The process is similar to matrix transformation being applied to a
classification table where the top row contains the names of the
characteristics, the left most column contains the names of the elements and
the body of the spreadsheet the states of the characteristics as they relate
each characteristic to each element. The process reorganizes the spreadsheet
(primarily the columns) so that the order of characteristics is such that
the elements can be identified by responding to the least number of required
queries (answering which state each characteristic has in the order of the
reorganised characteristics) going from left to right.

"Pete_UK" <[email protected]> wrote in message
news:[email protected]...
> Yes, of course you could - it depends what you mean by "re-organising"
> the file. Can you give us some further details of what this process
> entails?
>
> Pete
>
> Dave wrote:
> > I have a spreadsheet process that reorganizes a spreadsheet by irst
saving
> > the contents to a .csv file, processing the file in a Visual Basic
program,
> > creating another .csv file and then displaying the file again in Excel.
> > Can't I just perform the process within Excel?
>

[Bill]

Having studied the Excel help file on using VBA it is now clear that my
project can be transferred to Excel as an Excel macro. Thanks.


"Pete_UK" <[email protected]> wrote in message
news:[email protected]...
> Yes, of course you could - it depends what you mean by "re-organising"
> the file. Can you give us some further details of what this process
> entails?
>
> Pete
>
> Dave wrote:
>> I have a spreadsheet process that reorganizes a spreadsheet by irst
>> saving
>> the contents to a .csv file, processing the file in a Visual Basic
>> program,
>> creating another .csv file and then displaying the file again in Excel.
>> Can't I just perform the process within Excel?
>