simple spreadsheet property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Please take a look at this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-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=?="
Click to expand...
Subject: simple spreadsheet property
Date: Sun, 29 May 2005 09:52:05 -0700
Lines: 18
Message-ID: <[email protected]>
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!TK2MSFTNGXA03.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
Click to expand...

{\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: (e-mail address removed)\par
\f1\par
}
 
Back
Top