Click here to Skip to main content
15,910,358 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Windows Shutdown Pin
klmall24-Aug-05 12:51
klmall24-Aug-05 12:51 
GeneralActiveDocument.SaveAs Problem Pin
Jim Munton24-Aug-05 8:36
Jim Munton24-Aug-05 8:36 
GeneralRe: ActiveDocument.SaveAs Problem Pin
Dave Kreskowiak24-Aug-05 9:00
mveDave Kreskowiak24-Aug-05 9:00 
GeneralRe: ActiveDocument.SaveAs Problem Pin
Jim Munton24-Aug-05 9:10
Jim Munton24-Aug-05 9:10 
GeneralRe: ActiveDocument.SaveAs Problem Pin
Dave Kreskowiak24-Aug-05 10:00
mveDave Kreskowiak24-Aug-05 10:00 
Generalmaking backup and recovery using vb.net and Sql server 2000 as a database Pin
Mamokwena24-Aug-05 7:50
Mamokwena24-Aug-05 7:50 
GeneralRe: making backup and recovery using vb.net and Sql server 2000 as a database Pin
Dave Kreskowiak24-Aug-05 8:50
mveDave Kreskowiak24-Aug-05 8:50 
GeneralExport to excel formatting question Pin
raj_marthy24-Aug-05 6:26
raj_marthy24-Aug-05 6:26 
Hi,
I am exporting a chunk of data in html present in a div tags to excel on the client side using some thing like following piece of code. It exports fine and it is working correctly.
The data in the div tags contain two tables inside it. The first table will give you the header information and the second table will give you the body of the data.

In the excel I want the data in the first table to be aligned to the center of the page which will be left aligned on the web page.So, i.e when I click the export to excel button I want the header information which is left aligned in the webpage must be aligned to center of the excel page. How can we do that? If you can post me a piece of code it will be of great help.

Thanks,
Raj.
<scriptlanguage="vbscript">
Sub exportbutton_onclick
Dim sHTML, oExcel, oBook
sHTML = document.all.item("DataGrid1").outerhtml
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
oBook.HTMLProject.RefreshDocument
oExcel.Visible = true
oExcel.UserControl = true
End Sub </script>
GeneralRe: Export to excel formatting question Pin
raj_marthy25-Aug-05 9:27
raj_marthy25-Aug-05 9:27 
QuestionHow can I add VBIDE in my VB solution references? Pin
ATC24-Aug-05 5:54
ATC24-Aug-05 5:54 
AnswerRe: How can I add VBIDE in my VB solution references? Pin
Dave Kreskowiak24-Aug-05 8:49
mveDave Kreskowiak24-Aug-05 8:49 
GeneralDatagrid - Last row always blank Pin
dptalt24-Aug-05 5:07
dptalt24-Aug-05 5:07 
GeneralRe: Datagrid - Last row always blank Pin
Dave Kreskowiak24-Aug-05 5:54
mveDave Kreskowiak24-Aug-05 5:54 
GeneralRe: Datagrid - Last row always blank Pin
dptalt24-Aug-05 6:13
dptalt24-Aug-05 6:13 
GeneralRe: Datagrid - Last row always blank Pin
Dave Kreskowiak24-Aug-05 8:42
mveDave Kreskowiak24-Aug-05 8:42 
GeneralRe: Datagrid - Last row always blank Pin
dptalt25-Aug-05 3:27
dptalt25-Aug-05 3:27 
GeneralImport XML into a Dataset Pin
UniBond24-Aug-05 5:00
UniBond24-Aug-05 5:00 
GeneralRe: Import XML into a Dataset Pin
Dave Kreskowiak24-Aug-05 5:48
mveDave Kreskowiak24-Aug-05 5:48 
GeneralFormatting datagrids Pin
evertbylt24-Aug-05 4:21
evertbylt24-Aug-05 4:21 
GeneralRe: Formatting datagrids Pin
Dave Kreskowiak24-Aug-05 5:43
mveDave Kreskowiak24-Aug-05 5:43 
GeneralComboboxes in datagrid Pin
evertbylt24-Aug-05 4:16
evertbylt24-Aug-05 4:16 
GeneralAuto Setup for Datagrids Pin
RichardBerry24-Aug-05 4:10
RichardBerry24-Aug-05 4:10 
Generalretrive data from datagrid Pin
elcheah24-Aug-05 3:14
elcheah24-Aug-05 3:14 
GeneralRe: retrive data from datagrid Pin
Dave Kreskowiak24-Aug-05 5:36
mveDave Kreskowiak24-Aug-05 5:36 
GeneralConnection time out Pin
Rizwan Bashir24-Aug-05 0:06
Rizwan Bashir24-Aug-05 0:06 

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.