Positioning the image in Excel 2007 [modified]

[klaydze]

Hi, I create a simple program that can open a image in excel. But there is a problem, I want it to position a little bit lower because I have some data that i want to write above that image. And also how do I re size the image that i put in the excel? Here is my code: Dim xlsApp As New Microsoft.Office.Interop.Excel.Application Dim xlsWSheet As New Microsoft.Office.Interop.Excel.Worksheet Dim excelFiles As String = "c:\Test.xlsx" Dim pic As String = "c:\MsC.bmp" xlsApp.Visible = True xlsApp.Workbooks.Open(excelFiles) xlsApp.ActiveSheet.Pictures.Insert(pic) xlsApp = Nothing GC.Collect() GC.WaitForPendingFinalizers() Anyone change help me how to do the position of image. Thanks Regards, Jessie

if(you type your code here) { Messagebox.Show("You help me a lot!"); } else { You help me = null; }

modified on Monday, July 28, 2008 4:55 AM