Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can't completely close MS Excel 2007...
Hi. I don't know if this is a VB2005 or MS Excel issue so I will start with VB2005. This is how I open an Excel file in VB2005: Dim objExcel As New Excel.Application Dim objWorkbook As Excel.Workbook Dim objSheet As Excel.Worksheet objExcel.Visible = True objWorkbook =...- dtvonly
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
using VB2005 with Excel 2007...
Dim objExcel As New Excel.Application Dim objWorkbook As Excel.Workbook Dim objSheet As Excel.Worksheet objExcel.Visible = True objWorkbook = objExcel.Workbooks.Open("c:\Dat.xlsx") objWorkbook = objExcel.Workbooks.Add() objSheet = objWorkbook.Worksheets(1) objSheet.Cells(2, 2).Value =...- dtvonly
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
checking variable type size...
Hi. Please see the short sample below: unsigned int var1; var1 = 0x0001; // 16-bit data to device A var1 = 0x01; // 8-bit data to device B Send_Data(var1); my objective: Send_Data subroutine function depends on the data length of var1. How can this be done? Thank you for your help.
