No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
i have a problem with my code... i use this code to open an excel and manipulate the data [code] Dim xl3 As Excel.Application Dim xl3sheet As Excel.Worksheet Dim xl3wbook As Excel.Workbook Dim FilNam As String Me.CommonDialog1.ShowOpen FilNam = Me.CommonDialog1.Filename If Me.CommonDialog1.Filename <> "" Or Me.CommonDialog1.Filename <> ".xls" Then Set … |
|
im new in macro programming and vb im doing a project office automation how do i open (without showing) existing excel? so i can manipulate the data most of the snipet i see in the net is like this Set oExcel = CreateObject("Excel.Application") Set ExcelDoc = oExcel.Workbooks.Open(m_strPath & "project.xls") i … |