help on Excel question 批处理文件请教# JobHunting - 待字闺中
b*p
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
出来，然后放在一
个新的文件中
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