0

Hey Everyone,
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..

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by MichaelWClark
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.