/ Forside / Teknologi / Udvikling / VB/Basic / Nyhedsindlæg
Login
Glemt dit kodeord?
Brugernavn

Kodeord


Reklame
Top 10 brugere
VB/Basic
#NavnPoint
berpox 2425
pete 1435
CADmageren 1251
gibson 1230
Phylock 887
gandalf 836
AntonV 790
strarup 750
Benjamin... 700
10  tom.kise 610
Excel Open close
Fra : Michael Thomson


Dato : 31-08-01 09:49

Please help if posible.

I have a VB program there opens and closes Excel a couple of times.
This is without any problem.
But if i use Cells.find command in one of the excels it want close Excel
proberly
it stayes open in my task manager.
The Cells.find works fine my problem is just that EXCEL can't close
proberly.
Please help a man with almost no hair left.

Dim appExcel As excel.Application
Dim Sti As String


Sti = App.Path & "\tabeller\FES_A_Final"
Set appExcel = New excel.Application

With appExcel.Application
.Visible = False 'sætter excel til at være synlig
.Workbooks.Open Sti, 0, True 'open
.Sheets("1Draw.initials").Select
End With

appExcel.Cells.Find(What:=RownameB, After:=ActiveCell, LookIn:=xlFormulas,
LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False).Activate

appExcel.Application.ActiveWorkbook.Close savechanges:=False
appExcel.Application.Quit
Set appExcel = Nothing



 
 
Søg
Reklame
Statistik
Spørgsmål : 177501
Tips : 31968
Nyheder : 719565
Indlæg : 6408527
Brugere : 218887

Månedens bedste
Årets bedste
Sidste års bedste