473,233 Members | 1,477 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 software developers and data experts.

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
2 2528
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
3
by: Fabrice Cavarretta | last post by:
I am using a specialized database software (for bibliography: EndNote) that does export in XML. I would like to be able to read that into a simple software, like Excel or Access, in order to do...
0
by: Chris | last post by:
I'am creating program in VB.NET which will transform excel spreadsheet to SQL database automatically. When I use SQL wizard to export excel spreadsheet data there is an option of saving DTS package...
2
by: Colleyville Alan | last post by:
I have been working on an application that queries data from Access, loads it into an array, and then writes it to an Excel spreadsheet. I use the array approach to have fine control over spacing,...
0
by: Mick Hardy | last post by:
Hi, Has anyone seen this weird behaviour or have any suggestions or can anyone reproduce it? The history: I converted a large third party DB from 97 to XP and it uses the...
1
by: FrankJeroen | last post by:
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...
1
by: Charles A. Lackman | last post by:
Hello, I have opened an excel file into a .net application and any trying to determine if column 1 is a checkbox or not. Spreadsheet column 1 has both Text and Checkboxes. This is what I have...
2
by: eakkas | last post by:
All I need to do is; on the click of a button, import the numerical data in an html form (only one field) to a cell in a spreadsheet. Both spreadsheet and the html file reside on the same server...
3
by: gra | last post by:
Hi Access 2002 I have a Command Buton using some VB code to open an Excel spreadsheet. However, when the spreadsheet opens it doesn't refresh the data. The spreadsheet is a pivot table which...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.