Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #54.9K
I have a function and I want it to output one word in the current cell and one in the cell to the right (i.e., the next column). Is there a way to write this in VB? So, something along these lines (though this doesn't work): [code] Function test(word1 As … |
|
Re:
Hi, This is my coding......... Private Sub Command1_Click() Dim xlApp As Excel.Application Dim Wb As Excel.Workbook Dim ws As Excel.Worksheet Dim name As String Set xlApp = New Excel.Application Set Wb = xlApp.Workbooks.Open("E:\Projects\VB Excel to textfile\crse.xls") Set ws = Wb.Sheets(1) Open "C:\rolllist.xls" For Output As #1 For i = 1 … |