Hiiiii,
I am opening an Excell file using Excell object Library.

Dim xlTmp As Excel.Application
Dim sparth As String
Dim formwidth As Double

Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open File1.Path & "\" & sparth,
xlTmp.Left = 20000
Set xlTmp.Width = 774
xlTmp.Height = 561 'Screen.Height - 5000
xlTmp.Width = 553
xlTmp.Visible = True

But when I am trying to set the Height and the Width of the Excel file it give the following error...

Runtime Error
"Method Height of object Application failed"

I need to change the Height and width of the opend excell file at run time......

Can anyone help me on this....


Thanks
Sam