Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Imports Microsoft.Office.Interop.Excel
Public Class TransferTool Private Sub btn_PrevData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_PrevData.Click Dim wkbk As New Microsoft.Office.Interop.Excel.Workbook wkbk.Open(Me.txt_ImportFile.Text) strWrkBkNm = wkbk.Item(1).Name wkbk.Close() wkbk = Nothing Gives an unspecified error, does anyone know why this will not run? Do I need to install something? Thanks, Paula |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
run code on opening workbook and apply code to certain sheets | Excel Programming | |||
Code in one workbook to call code in another XL file | Excel Programming | |||
Place code from current workbook to new workbook | Excel Programming | |||
Reference code in another workbook from a calling workbook | Excel Programming |