Problem, need urgent help!

  • Thread starter Thread starter alexm999
  • Start date Start date
A

alexm999

I'm stuck and need help with a function.

I have a file named 1.txt
in Cell I66 I need to subtract cells e62 and I-62 (i use =e62-i62)
I have another excel file named Daily Operations_2004.xls and I nee
the output of the cell I66 (in 1.txt) to be displayed in cell AM9 i
Daily Operations_2004.xls

How can this be done using VB code? I've tried a macro, but it doesn'
work... HELP!?!?
 
you need to create a link formula in VBA. Open the file within the sam
excel app and put "=" in a cell then select the cell in the othe
workbook you are trying to link too. Then close the other workboo
(the one you are linking too). Then take a look at the formula in th
cell, you will need to duplicate this in vba code.

Keith
www.kjtfs.co
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Help 3
Assistance Needed with Comparing 4
Need help With Code: 2
Need Quick Fix... Find macro Issue 5
Need Help With CODE!!! 10
How can macro open daily generated files? 5
method 'cells' of object '_global' failed 0
Like-for-like cell linkage returns '#N/A' 1

Back
Top