467,877 Members | 1,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

simple spreadsheet property

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.H orizontalAlignment = xlRight

But In VB2003 I can't use it anymore.
What do I have to change? Who could help me..

Jeroen
Jul 21 '05 #1
  • viewed: 2230
Share:
2 Replies
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
}

Jul 21 '05 #2
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
}

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
3 posts views Thread by Fabrice Cavarretta | last post: by
1 post views Thread by FrankJeroen | last post: by
1 post views Thread by Charles A. Lackman | last post: by
reply views Thread by jack112 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.