Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Harry Hunter on Mar 06 In MS Office Category.

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

Question Answered By: Douglas Sullivan 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

View Complete Question Thread

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.

Related Topics:

Forcing Excel 2003 to open file when Excel 2007 also installed
Excel 97-03 file connecting to Excel 2007 file as data source
Data collection from Excel file through VB-6
Prevent Workbook open runing when opening another Excel Doc
Opening up 2 excel files without the 'read-write' option appearing
How to know state of opened or Closed File in Excel
problem: I've done this in ACCESS, but not in EXCEL
can excel file auto open wen pc turn on
Can't get an excel file with webpage formatting open in access
Can't open excel file after editing macro
Code Cleaning Was: Re: Can't open excel file
Opening non-Office file from Excel
Have you done the open source census yet?
Need Help In Deleting Duplicate Items in Excel a excel file
Excel VBA, is there an "IF" statement verifying toolbar exist
File formats ( Excel 2003 & Excel 97 ) ?
VB.Net, VB6, VBA[Excel] (?)
Problem with Using Micorsoft Query Tool of Excel Through VB.Net
VB code to send Mail from Excel?
VB and excel columns

Tagged:how do you open an existing excel file with vb

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us