Click here to Skip to main content
15,904,156 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Why onpaint doesn't work in numericupdown Pin
beifangcc9-Jun-04 17:30
beifangcc9-Jun-04 17:30 
GeneralRe: Why onpaint doesn't work in numericupdown Pin
10-Jun-04 4:16
suss
10-Jun-04 4:16 
GeneralRe: Why onpaint doesn't work in numericupdown Pin
beifangcc10-Jun-04 15:55
beifangcc10-Jun-04 15:55 
GeneralRe: Why onpaint doesn't work in numericupdown Pin
Aaron Eldreth11-Jun-04 3:20
Aaron Eldreth11-Jun-04 3:20 
GeneralDropdownlist Pin
dotnet_cpp8-Jun-04 19:50
dotnet_cpp8-Jun-04 19:50 
GeneralRe: Dropdownlist Pin
Dave Kreskowiak9-Jun-04 0:07
mveDave Kreskowiak9-Jun-04 0:07 
Generalgetting listbox contents.. Pin
JasonRey8-Jun-04 16:54
JasonRey8-Jun-04 16:54 
GeneralRe: getting listbox contents.. Pin
Dave Kreskowiak9-Jun-04 6:57
mveDave Kreskowiak9-Jun-04 6:57 
You would have to set a Reference to the Microsoft Excel whatever.0 Object Library, then use something like the following code to create an instance of Excel and populate some cells:
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

'Start a new workbook in Excel
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add


'Add data to cells of the first worksheet in the new workbook
Set oSheet = oBook.Worksheets(1)
oSheet.Range("A1").Value = "Last Name"
oSheet.Range("B1").Value = "First Name"
oSheet.Range("A1:B1").Font.Bold = True
oSheet.Range("A2").Value = "Doe"
oSheet.Range("B2").Value = "John"

'Save the Workbook and Quit Excel
oBook.SaveAs "C:\Book1.xls"
oExcel.Quit



RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

GeneralCode for a Calculator Pin
nofrills138-Jun-04 16:14
nofrills138-Jun-04 16:14 
GeneralRe: Code for a Calculator Pin
Jim Taylor8-Jun-04 22:15
Jim Taylor8-Jun-04 22:15 
GeneralTreeView in run time Pin
Brad Fackrell8-Jun-04 9:16
Brad Fackrell8-Jun-04 9:16 
GeneralRe: TreeView in run time Pin
Dave Kreskowiak8-Jun-04 9:31
mveDave Kreskowiak8-Jun-04 9:31 
GeneralRe: TreeView in run time Pin
Brad Fackrell8-Jun-04 9:36
Brad Fackrell8-Jun-04 9:36 
GeneralRe: TreeView in run time Pin
Dave Kreskowiak8-Jun-04 10:08
mveDave Kreskowiak8-Jun-04 10:08 
GeneralRe: TreeView in run time Pin
Brad Fackrell8-Jun-04 10:12
Brad Fackrell8-Jun-04 10:12 
GeneralRe: TreeView in run time Pin
Brad Fackrell8-Jun-04 11:48
Brad Fackrell8-Jun-04 11:48 
GeneralRe: client/server read and write Pin
fo0lish8-Jun-04 5:45
fo0lish8-Jun-04 5:45 
GeneralRe: client/server read and write Pin
Dave Kreskowiak8-Jun-04 6:47
mveDave Kreskowiak8-Jun-04 6:47 
GeneralRe: client/server read and write Pin
fo0lish9-Jun-04 14:59
fo0lish9-Jun-04 14:59 
GeneralRe: client/server read and write Pin
Dave Kreskowiak9-Jun-04 15:30
mveDave Kreskowiak9-Jun-04 15:30 
Generaladding days to current day being displayed Pin
devgeez8-Jun-04 5:08
devgeez8-Jun-04 5:08 
GeneralRe: adding days to current day being displayed Pin
Dave Kreskowiak8-Jun-04 5:38
mveDave Kreskowiak8-Jun-04 5:38 
GeneralRe: adding days to current day being displayed Pin
devgeez8-Jun-04 8:16
devgeez8-Jun-04 8:16 
GeneralRe: adding days to current day being displayed Pin
Dave Kreskowiak8-Jun-04 8:43
mveDave Kreskowiak8-Jun-04 8:43 
GeneralRe: adding days to current day being displayed Pin
devgeez9-Jun-04 4:45
devgeez9-Jun-04 4:45 

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.