Hi Adrian,
I must admit that I have trouble using Excel from within Delphi, (usually COM
problems - but I think thats just me being a bit 'thick' when it comes to COM
;-)).
You can still use a With Construct as follows:
With XLApp Do
begin
Range['D1'].Select;
Selection.Interior.ColorIndex := 15;
Selection.Interior.Pattern := xlSolid;
Selection.Interior.PatternColorIndex := xlAutomatic;
Cells[1,4].Value:='RFDS Link';
Cells[2,4].Value:='=HYPERLINK("C:\","Link")';
end;
hth
Paul Bennett
Experience is something you don't get until just after you need it.
--
_______________________________________________
Surf the Web in a faster, safer and easier way:
Download Opera 9 at http://www.opera.com
Powered by Outblaze
