Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping Excel after running visual basic in Access
After running the following sub the excel spreadsheet comes up. When
exiting out of excel the program appears to close but doesn't, it's still running in the background. What's the problem? Sub xls2() Dim ex As New Excel.Application Dim wrkbk As Excel.Workbook Dim wks As Excel.Worksheet Dim rng As Excel.Range Set wrkbk = Workbooks.Open("c:\TRPWKBookA.xls") Set wks = wrkbk.Worksheets("41 ECS") wks.Range("b13").Value = 12 Set wks = wrkbk.Worksheets("755") wks.Range("b13").Value = 13 'Set rng = wks.Cells(2, 13) ' With rng ' .Value = 'Set rng = wks.UsedRange.columns ex.Visible = True End Sub Thanks if anyone can tell me what's wrong. bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access Visual Basic in Excel 2007 Trial? | Setting up and Configuration of Excel | |||
visual basic within Access If...Then | Excel Discussion (Misc queries) | |||
visual basic within Access If...Then | Excel Discussion (Misc queries) | |||
Activate check "Trust access to Visual Basic " in Excel | New Users to Excel | |||
using visual basic to access a protected DB | Excel Programming |