b***p 发帖数: 1398 | 1 我有999个文件,每个文件的格式都一样,我要把每个文件中的固定位置的一个数据读
出来,然后放在一
个新的文件中
I tried the following:
=‘C:\DOE Nov 18 2009\[Trial 001_Mechanical Test Data
Sheet.xlsx]Sheet1’!$C$12
=‘C:\DOE Nov 18 2009\[Trial 002_Mechanical Test Data
Sheet.xlsx]Sheet1’!$C$12
=‘C:\DOE Nov 18 2009\[Trial 003_Mechanical Test Data
Sheet.xlsx]Sheet1’!$C$12
....
....
....
=‘C:\DOE Nov 18 2009\[Trial 999_Mechanical Test Data
Sheet.xlsx]Sheet1’!$C$12
可是不行
However, 如果我先输入等号, 再输入‘C:\DOE Nov 18 2009\[Trial 001_Mechanical
Test Data Sheet.xlsx]Shee | G*****u 发帖数: 1222 | | b***p 发帖数: 1398 | 3 vba is a part of Excel or an additional package that I need to download and
install on my PC?
thanks | b***p 发帖数: 1398 | 4 vba is a part of Excel or an additional package that I need to download and
install on my PC?
thanks | G*****u 发帖数: 1222 | |
|