3 replies to this topic

[Stevuk]

Hi all,

I would really appreciate some assistance by pointing me in the right direction to solve my file management requirement as follows:

I wish to carry out the following file management, what programme or software will facilitate this ?
I have a many excel files in a folder:

First, I want to open each file in turn, then using an excel macro modify the file and save it to a second folder. This process is to be repeated until all files from the original folder have been opened, modified and saved in the second folder.

For the new folder holding the modified files :
I wish to open each in turn, then using another excel macro extract data into a second single master spreadsheet, then close and delete the file. This process is to be repeated until all files from the original folder have been opened, data extracted then deleted.

Thanks for reading (the rather long winded post) and any assistance will be greatly appreciated.

[analysis_junky]

Why not import the files into a database??? Having many Excel files (or multiple data sources) to store important data can be a disaster if the data is critical.

[dargueta]

Use VBA (Visual Basic for Applications). It's embedded code in Office documents (Excel, Word, etc.) and can be used to do a ton of stuff with them, even work cross-application. That means you can pull Excel data into a Word doc, etc. I don't remember offhand the code for this, but it's one of the last chapters of VBA for Dummies.

[Stevuk]

Thanks for the input, the purpose of the database is only to compare new spreadsheet data with existing benchmarks and update, the compared spreadsheet is then deleted, as such only minimal data is actually retained.