Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How do you open an existing Excel file with VB...

  Asked By: Harry    Date: Mar 06    Category: MS Office    Views: 1946
  

write new material to it and then save the updated file?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Douglas Sullivan     Answered On: Mar 06

Sub blah()
Workbooks.Open Filename:= _
"C:\Documents and Settings\anyone\My Documents\Sample.xls"
Range("A1").FormulaR1C1 = "42"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub

 
Didn't find what you were looking for? Find more on How do you open an existing Excel file with VB... Or get search suggestion and latest updates.




Tagged: