|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/mguerinweb/Offline_Archive/VB2EXCEL/ |
Upload File : |
VERSION 5.00
Begin VB.Form Form1
Caption = "Form1"
ClientHeight = 3960
ClientLeft = 60
ClientTop = 345
ClientWidth = 3825
LinkTopic = "Form1"
ScaleHeight = 3960
ScaleWidth = 3825
StartUpPosition = 3 'Windows Default
Begin VB.CommandButton Command1
Caption = "Show Excel"
Height = 420
Left = 1530
TabIndex = 2
Top = 2655
Width = 1005
End
Begin VB.TextBox Text2
Height = 375
Left = 855
TabIndex = 1
Text = "Nasrul Saiyed"
Top = 1395
Width = 1995
End
Begin VB.TextBox Text1
Height = 375
Left = 270
TabIndex = 0
Text = "A1"
Top = 1395
Width = 465
End
End
Attribute VB_Name = "Form1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'Here is the Simple Programm from Nasrul Saiyed
'To Send the Data from Vb To Microsoft Excel
Dim NashXl As Excel.Application
Private Sub Command1_Click()
NashXl.Workbooks.Add
NashXl.Range(Text1.Text).Value = Text2.Text
NashXl.Visible = True
End Sub
Private Sub Form_Load()
Set NashXl = CreateObject("excel.application")
End Sub
Private Sub Form_Unload(Cancel As Integer)
NashXl.Quit
End Sub