I have an application that I am using to convert excel files to HTML for use on the web. The user has the choice via a button to select which file they want to save. Each time Excel sheet 2 needs to be saved. I am having a problem in my code that doesn't
allow sheet 2 to be saved each time. Has anyone any tips.
Here is the part of code that seems to be wrong/not complete.
objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Open((path + TreeView1.SelectedNode.Tag))
objSheet = objExcel.Sheets.Item("Sheet2")
I'd be grateful for the help.
View Complete Post