[Solved] Can I Write into a Closed Spreadsheet?

[sokolowitzky]

I have daily/weekly raw data that should be processed with an already set spreadsheet.
All I have to do is a simple copy and paste special, since ressource file is generated with formulas.
There are around 6000 of em. So I don't want to wait the files to open and then to copy.
Can I Import their values into the processor sheet, like paste special? With help of soıme macro?

[Zizi64]

Can I Write into a Closed Spreadsheet?

Absolutely not.

But you can open a document by a macro without appearing the user interface and the data.
You must write the macro because the capability of the macro recorder will not be enough for this task.
viewtopic.php?f=20&t=11096
viewtopic.php?f=44&t=41379
viewtopic.php?f=20&t=93573

You need study and use the API functions for the efective macro programming. API: Application Programming Interface. Start with Andrew Pitonyak's free macro books.
http://www.pitonyak.org/oo.php

[Villeroy]

A spreadsheet is not a database.
A spreadsheet needs to load all of its data into memorý.

[sokolowitzky]

@Tibor Kovacs, thank you sir. You've always been helpful. But unfortunately I feel hard to understand pitonyak's examples.
For example sometimes he writes how to write a macro but he does not show which variable to declare. Or he just writes Dim but he does not show if it is as object or as string.
What I'm trying to do is a very simple task. Learning how to write a macro requires a lot of time to focus. But thanks anyhow.

@Villeroy. Thanks for showing what a spreadsheet is and what is not. You've enlightened me.

[Zizi64]

What I'm trying to do is a very simple task.

Really? I do not think that...

[RoryOF]

You can write a macro to open each spreadsheet, insert data, and close the sheet. That process can then happen with no intervention from you.

An alternate method, which needs major redesign of the work processes, is to keep all the data in a database, and generate custom reports on demand, each replacing a former spreadsheet. In that way, each report is generated from the latest (i.e, updated) data.

[Villeroy]

This macro has been written. Here is my version of it: viewtopic.php?f=21&t=77069
Good luck with your database on a sheet.

[sokolowitzky]

@Villeroy Thank you. This seems very useful.