Hi
I have a code below
When I put dot inside with, It did not show methodsCode:Dim xlApp As Object 'Create an instance of Excel and add a workbook Set xlApp = CreateObject("Excel.Application") Set xlWb = xlApp.Workbooks.Add Set xlWs = xlWb.Worksheets("Sheet1") with xlApp etc end with
I look References and reference of the excel is right
tia





Reply With Quote