title: VBA - Get Cell Values from other workbook without opening
body: <p>I'm working to get the cell value of other workbook without opening it. </p>
  
  <p>And here's some of my codes: </p>
  
  <p><code>Range("F3")= "='C:\inetpub\vhosts\hotdogko.com\httpdocs\private\excel\[Launch Pad.xls]Sheet1'!$B$12 "</code></p>
  
  <p>This code is working well when data type of the cell value to pull is Date, Integer or Any not String data type. But it wont work correctly to string data type, it just returning #N/A.</p>
  
  <p>Thanks for someone who can give me an answer for this problem.  </p>