Click here to Skip to main content
15,922,696 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: File Delete problem in Windows Service Pin
Anonymous12-Jan-05 1:37
Anonymous12-Jan-05 1:37 
GeneralRe: File Delete problem in Windows Service Pin
P Holroyd12-Jan-05 1:46
P Holroyd12-Jan-05 1:46 
GeneralRe: File Delete problem in Windows Service Pin
Dave Kreskowiak12-Jan-05 11:51
mveDave Kreskowiak12-Jan-05 11:51 
GeneralRe: File Delete problem in Windows Service Pin
P Holroyd13-Jan-05 7:17
P Holroyd13-Jan-05 7:17 
GeneralRe: File Delete problem in Windows Service Pin
P Holroyd17-Jan-05 23:35
P Holroyd17-Jan-05 23:35 
GeneralSerial com port communication! Pin
Member 162670711-Jan-05 10:38
Member 162670711-Jan-05 10:38 
GeneralRe: Serial com port communication! Pin
Ritesh123411-Jan-05 21:21
Ritesh123411-Jan-05 21:21 
GeneralExcel Automation VB.Net (SQL Server) Question Pin
JZion11-Jan-05 5:57
JZion11-Jan-05 5:57 
I need to automate Excel on my Intranet Server to do the following.
In Excel I need to produce a report (in worksheet one) and in worksheet two I need to produce a Pivot Table of information (stored in worksheet one).

The report needs to be generated from tables in SQL Server Version 5.1, I am familiar with .asp and a little asp.net, but have now purchased Visual Studio Pro 2003 and Visual Studio Tools for the Microsoft Office System (not opened the boxes yet).

I think that it would be best to code an application in VB.NET that can be executed from .ASP (which the intranet is programmed in), however I don't have any resources available to me on automating Excel in such a way or know if a console type application (as in C++) can be compiled using VB.NET.

My main questions however are, is there any such resources (available online) to help me out with excel automation?

Also is the now familiar process of creating a DSN connection with SQL Server the way to connect with VB.NET? A guide to this would be helpful.

If C# or C++ is the way to go, then is there any resources that could help?

With thanks

Jason



Generalcopy & paste in VB6 Pin
Britnt711-Jan-05 4:32
Britnt711-Jan-05 4:32 
QuestionHow to integrate reporting service with vb.net Pin
Mekong River11-Jan-05 4:29
Mekong River11-Jan-05 4:29 
AnswerRe: How to integrate reporting service with vb.net Pin
Member 56585711-Jan-05 6:41
Member 56585711-Jan-05 6:41 
GeneralEasy Questions for CPians Pin
Sebastien Lachance11-Jan-05 4:17
Sebastien Lachance11-Jan-05 4:17 
GeneralRe: Easy Questions for CPians Pin
Dave Kreskowiak11-Jan-05 6:09
mveDave Kreskowiak11-Jan-05 6:09 
GeneralRe: Easy Questions for CPians Pin
Sebastien Lachance11-Jan-05 6:38
Sebastien Lachance11-Jan-05 6:38 
GeneralRe: Easy Questions for CPians Pin
Dave Kreskowiak11-Jan-05 9:18
mveDave Kreskowiak11-Jan-05 9:18 
GeneralRe: Easy Questions for CPians Pin
Sebastien Lachance12-Jan-05 2:34
Sebastien Lachance12-Jan-05 2:34 
GeneralRe: Easy Questions for CPians Pin
Dave Kreskowiak12-Jan-05 8:13
mveDave Kreskowiak12-Jan-05 8:13 
GeneralRe: Easy Questions for CPians Pin
Sebastien Lachance12-Jan-05 8:43
Sebastien Lachance12-Jan-05 8:43 
GeneralVBA richtextbox produces error Pin
littleGreenDude11-Jan-05 4:12
littleGreenDude11-Jan-05 4:12 
GeneralRe: VBA richtextbox produces error Pin
Dave Kreskowiak11-Jan-05 15:56
mveDave Kreskowiak11-Jan-05 15:56 
GeneralSetting ToolTip for selected ListViewItem Pin
kobezt0811-Jan-05 3:58
kobezt0811-Jan-05 3:58 
GeneralRe: Setting ToolTip for selected ListViewItem Pin
Dave Kreskowiak11-Jan-05 6:06
mveDave Kreskowiak11-Jan-05 6:06 
GeneralRe: Setting ToolTip for selected ListViewItem Pin
kobezt0811-Jan-05 16:08
kobezt0811-Jan-05 16:08 
GeneralRe: Setting ToolTip for selected ListViewItem Pin
Dave Kreskowiak12-Jan-05 0:48
mveDave Kreskowiak12-Jan-05 0:48 
GeneralDeleting file from HD Pin
Jodd11-Jan-05 3:25
Jodd11-Jan-05 3:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.