Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. oExcel = CreateObject("Excel.Application")
  2. oExcel.visible = .T.
  3. oExcel.Application.UserControl=.T.
  4. oExcel.Application.Interactive=.T.
  5. oExcel.DisplayAlerts = .F.
  6.  
  7. oWorkbook = oExcel.Application.Workbooks.Open("&xfile")
  8. oExcel.ActiveSheet.UsedRange.EntireColumn.Autofit
  9. tFormula = "=SUMA(D2:D4)"
  10. tCell = "D5"
  11.  
  12. oExcel.Range("&tCell").Value = [&tFormula]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement