Member Avatar for Pacman21

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
  • 87 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by MichaelWClark
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.