Excel and VBA
- Thread starter KenHigg
- Start date
KeithG
AWF VIP
- Local time
- Yesterday, 18:50
- Joined
- Mar 23, 2006
- Messages
- 2,592
Something like below will open up your spreadsheet and you can manupliate it form there. Make sure to set a reference to the excel object library. I guess you could also use late binding instead.
[/CODE]
Code:
First set a reference to the Excel object library. Then you can use something like below to open the spreadsheet.
[CODE]Dim xlApp as New Excel.Application
Dim xlwrkBk as Excel.Workbook
dim xlSheet as Excel.Worksheet
set xlWrkBk=xlApp.workbooks.open("Path")
KenHigg
Registered User
- Local time
- Yesterday, 21:50
- Joined
- Jun 9, 2004
- Messages
- 13,327
Thanks Paul and Keith - Just the kickstart I needed.
Here's the code I used:
Here's the code I used:
Code:
Private Sub Command0_Click()
Dim xlApp As New Excel.Application
Dim xlwrkBk As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlwrkBk = xlApp.Workbooks.Open("C:\Documents and Settings\340364\60 Project Files\140 Excel Automation\ZXOR27NovB.xls")
Set xlSheet = xlwrkBk.Worksheets("OpenExchangeOrders27Nov")
xlSheet.Rows(1).Delete
xlwrkBk.Save
xlwrkBk.Close
Set xlSheet = Nothing
Set xlwrkBk = Nothing
xlApp.Quit
Set xlApp = Nothing
MsgBox "Done"
End SubSimilar threads
