How to do it in macro?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Does anyone have any suggestions on how to retrieve a specific cell value
within specific workbook without opening it on macro?

I would like to set if-statement as shown below

WkbkName = "D:\Documents\TS\file.xls"
If wkbk.Sheets("Check").Range("N18").Value = 1 Then
....
Does anyone have any suggestions on how to code the workbook part? in order
to make it work.
Thanks in advance for any suggestions
Eric
 
Hi,
you can use a formula like

=IF('[File.xls]check'!N18=1,"Yes","NO")

if N18 =1 will enter yes otherwise no

hope this helps
 
Could you please tell me how to code it in macro VBA?
including the directory
Thanks in advance for any suggestions
Eric

Eduardo said:
Hi,
you can use a formula like

=IF('[File.xls]check'!N18=1,"Yes","NO")

if N18 =1 will enter yes otherwise no

hope this helps

Eric said:
Does anyone have any suggestions on how to retrieve a specific cell value
within specific workbook without opening it on macro?

I would like to set if-statement as shown below

WkbkName = "D:\Documents\TS\file.xls"
If wkbk.Sheets("Check").Range("N18").Value = 1 Then
...
Does anyone have any suggestions on how to code the workbook part? in order
to make it work.
Thanks in advance for any suggestions
Eric
Click to expand...
Click to expand...
 
Back
Top