 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2006Excel process
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? 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 > 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? 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. > 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 [quoted text clipped - 6 lines] > > creating another .csv file and then displaying the file again in Excel. > > Can't I just perform the process within Excel? 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. > 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 [quoted text clipped - 8 lines] >> creating another .csv file and then displaying the file again in Excel. >> Can't I just perform the process within Excel? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.