4
I’m having a problem related to external data in excel this is an example of what I have done:
Index (Book) Painel (sheet) - I enter data in the panel that will be sent to another book (count) sheet (sum) and receive the data coming from it.
Contagem(book) Soma (sheet) - calculate and send the result to Book (index) leaf (painel).
The question I have is that whenever I want to update this data I have to have both books excel open and wondered if there is any way to do it with just the book (index) open and the book (contagem) closed?
I believe not, because excel only updates data in open spreadsheets, unfortunately... You can put a macro in the index sheet that when updated, opens the other sheet, updates it and then closes it, it is possible, with VBA, do a search there.
– Paulo Roberto
Thanks for the info, I did a search and I found this forum "http://www.scriptbrasil.com.br/forum/topic/137036-resolvido-abrirarquivo-excel-e-save/" However I did what was there and it did not result only I can do what before opening the file. My goal would be to do this transparently without the user understanding.
– Mário Passos
this is kind of "impossible", because excel will open the spreadsheet and the user will see that the same is being updated, even because the spreadsheet will give a basic latch (same excel things).
– Paulo Roberto
Your question is not so clear. You have a VBA code that updates something in a spreadsheet and you want to do this in a closed spreadsheet (file)? Is that it? Edit and make it clearer, if possible even by displaying the code snippet where you do the data update.
– Luiz Vieira