Edit Excel from VB 1

[InsaneProgrammer]

I am writing a program that needs to open an existing excel worksheet, create a chart, and then save the chart to HTML. I am using the Shell() function to open the existing file but how do I access the sheet once its open. I assume I need to create some kind of object. I know how to create a new excel application from VB and do everything I want but I'm not sure how to access an existing worksheet. Any help or ideas would be greatly appreciated.

 

[JohnYingling]

Shell isn't going to do it.

http://msdn.microsoft.com/library/d.../deconUsingCreateObjectGetObjectFunctions.asp

http://www.msdn.microsoft.com

Search "GetObject CreateObject" or "Office Automation". Record macros and view code in Excel to see code that will be needed. If different versions of Excel must be accessed, you may have to use late-binding for production i.e. AS OBJECT instead of AS EXCEL.APPLICATION.

#Const blnLate = false
#If blnLate then 
    Dim objXL as object
#Else
    Dim objXL as Excel.Application ' Get Intellisense while testing
#End If

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript