Hi all
I have used the following code to Retreive a value from a closed WorkBook
i get it from here
http://spreadsheetpage.com/index.php..._a_closed_file
it is great and works perfectly BUT when i re-name sheet to something other than english (other languages such as chinese,japanese,...) it doesn't work and script stoped by a run-time error !!!
apparently it has problem with some unicode characters that are in Sheet name.
Could anyone help me? how can i change the script to use INDEX instead of Sheet Name? i think in this way
problem will be solved!!!
Thanks in advance.
Kind Regards.
![From From](/uploads/1/2/4/8/124806100/406049457.png)
In Microsoft Excel, getting information from a closed workbook is one of the most time-saving ways to get accurate data using VBA code. In this article, we will learn how to read information from a closed workbook using VBA in Microsoft Excel. VBA does not include a method to retrieve a value from a closed workbook file. You can, however, take advantage of Excel's ability to work with linked files. This section contains a VBA function (GetValue, which follows) that retrieves a value from a closed workbook. It does so by calling an XLM macro, which is an old-style macro used in.
Hi all
I have used the following code to Retreive a value from a closed WorkBook
i get it from here
http://spreadsheetpage.com/index.php..._a_closed_file
it is great and works perfectly BUT when i re-name sheet to something other than english (other languages such as chinese,japanese,...) it doesn't work and script stoped by a run-time error !!!
apparently it has problem with some unicode characters that are in Sheet name.
Could anyone help me? how can i change the script to use INDEX instead of Sheet Name? i think in this way
problem will be solved!!!
Thanks in advance.
Kind Regards.