Please take a look at this article:
http://msdn.microsoft.com/library/de...us/odc_vsto200
3_ta/html/ExcelObj.asp?frame=true. It is very useful.
Thanks,
--------------------
Thread-Topic: simple spreadsheet property
thread-index: AcVkbr6Cf2O6MtZpQ36AAHqkfZkbSw==
X-WBNR-Posting-Host: 82.169.22.182
From: "=?Utf-8?B?RnJhbmtKZXJvZW4=?="
<Fr*********@discussions.microsoft.com>Subject: simple spreadsheet property
Date: Sun, 29 May 2005 09:52:05 -0700
Lines: 18
Message-ID: <32**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.general:42688
X-Tomcat-NG: microsoft.public.dotnet.general
Hi there,
I have a simple problem, but I can't fix it.
I have worked with Visual Basic 6. But I recently switched to Visual Basic
.Net 2003.
I have a Form with an Spreadsheet. I want to change the properties of the
cells dynamically. (Alignment, Borders, Colors, Fontsize...)
In VB6 I could use the following code:
Form1.Spreadsheet.ActiveSheet.Columns("A").Cells. HorizontalAlignment =
xlRight
But In VB2003 I can't use it anymore.
What do I have to change? Who could help me..
Jeroen
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl {\f0\fnil\fprq2\fcharset0
MS Sans Serif;}{\f1\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.21.2500;}\viewkind4\uc1\pard\f0\fs20 Cheers,\par
\par
johnKn [MS-SDK]\par
\par
\par
\par
-Please do not send email directly to this alias. This alias is for \par
newsgroup purposes only\par
\par
-This posting is provided "AS IS" with no warranties, and confers no
rights.\par
\par
-To provide additional feedback about your community experience please send
\par
e-mail to:
sd*****@microsoft.com\par
\f1\par
}