Currently I have the code as
Dim ExcelApp, ExcelWB ExcelApp = CreateObject("Excel.Application") ExcelApp.visible = True ExcelWB = ExcelApp.Workbooks.Open("C:\test.xls") ExcelWB.saveas("C:\test2.xls")
This works good but it only opens the excel outside of the webpage and not on the inside.. I have tried the iframes, but, in my opinion, it is a lot easier to control excel when you start an instance from the code, and the Iframes also opened the excel outside of the page.. In vb.net it would be done by:
' Add a panel to the form ' Form Declaration Private Declare Auto Function SetParent Lib "user32" (ByVal hwndChild As IntPtr, ByVal hwndParent As IntPtr) As IntPtr ' Button1_Click Dim p As Process = Process.Start("Excel.exe") p.WaitForInputIdle() SetParent(p.MainWindowHandle, Panel1.Handle)
(I have received that code from a previous post I have made on this site)
Is there any way to do this in excel?? I have looked all over google and I have found some programs that don't use excel but can read the excel format, but I am not really looking for that.. If you can help me that would be great..