Hidden Application

  • Thread starter Thread starter Brian McCavour
  • Start date Start date
B

Brian McCavour

Im not sure if this is the right group to ask in but using VBA in autocad I
was to open an excel worksheet, enter some data, copy data to the clipboard,
then close excel withought the user being able to see excel open. Is this
possible ?
 
I used this code in MSWord and it worked ok.

Option Explicit
Sub testme()

Dim xlObj As Object
Dim xlWB As Object

Set xlObj = CreateObject("excel.application")
xlObj.Visible = True

Set xlWB = xlObj.workbooks.Open("C:\my documents\excel\book1.xls")

xlWB.worksheets("sheet1").Range("a1:b99").Copy

xlObj.DisplayAlerts = False
xlWB.Close False 'save changes
xlObj.DisplayAlerts = True
xlObj.Quit

Set xlWB = Nothing
Set xlObj = Nothing

End Sub

I'd leave the .visible True until you debugged your code. After that, it's
false.
 
Back
Top