Click here to Skip to main content
15,889,462 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionvb.net 2010 allow users to update active directory values Pin
dcof8-Sep-14 12:36
dcof8-Sep-14 12:36 
AnswerRe: vb.net 2010 allow users to update active directory values Pin
Eddy Vluggen9-Sep-14 8:37
professionalEddy Vluggen9-Sep-14 8:37 
QuestionProblem in program VBA excel. Kindly guide me. Pin
Member 110635316-Sep-14 6:57
Member 110635316-Sep-14 6:57 
AnswerRe: Problem in program VBA excel. Kindly guide me. Pin
Tim Carmichael6-Sep-14 9:19
Tim Carmichael6-Sep-14 9:19 
GeneralRe: Problem in program VBA excel. Kindly guide me. Pin
Member 110635316-Sep-14 16:49
Member 110635316-Sep-14 16:49 
GeneralRe: Problem in program VBA excel. Kindly guide me. Pin
Member 110635317-Sep-14 3:46
Member 110635317-Sep-14 3:46 
GeneralRe: Problem in program VBA excel. Kindly guide me. Pin
Tim Carmichael7-Sep-14 5:59
Tim Carmichael7-Sep-14 5:59 
GeneralRe: Problem in program VBA excel. Kindly guide me. Pin
Member 110635317-Sep-14 18:27
Member 110635317-Sep-14 18:27 
Hi Tim Carmichael,

I have created a visual basic program as follows:

Sub writetotextfile1()

Dim rngLoopRange As Range
Open "C:\Users\Kanini\Desktop\VisualSudhu\A1.txt" For Output As #1
For Each rngLoopRange In Range("A1:A20")
Print #1, rngLoopRange
Next rngLoopRange
Close #1

End Sub

Sub writetotextfile2()

Dim rngLoopRange As Range
Open "C:\Users\Kanini\Desktop\VisualSudhu\A2.txt" For Output As #1
For Each rngLoopRange In Range("B1:B20")
Print #1, rngLoopRange
Next rngLoopRange
Close #1

End Sub

These are the macro created for 2 files created text format. But, I need to create it for 500 rows at a time, so that it can give me 500 text files. Is there any way that I can loop these macros and as well create a formula where in I can get 500 rows at a time. Kindly help me in this regard.


Thanks in advance,


Warm Regards,
R. Sudhakar
GeneralRe: Problem in program VBA excel. Kindly guide me. Pin
Chris Quinn8-Sep-14 4:30
Chris Quinn8-Sep-14 4:30 
QuestionGet Attributes of External Assemblies Pin
Dominick Marciano4-Sep-14 15:09
professionalDominick Marciano4-Sep-14 15:09 
AnswerRe: Get Attributes of External Assemblies Pin
Richard Deeming5-Sep-14 1:46
mveRichard Deeming5-Sep-14 1:46 
GeneralRe: Get Attributes of External Assemblies Pin
Dominick Marciano12-Sep-14 6:36
professionalDominick Marciano12-Sep-14 6:36 
QuestionSynchronization of camera and shell orientation Windows 8.1 Surface Pin
Member 110572154-Sep-14 3:33
Member 110572154-Sep-14 3:33 
QuestionCopy selected listview item to a textbox VB.NET Pin
Pete_1233-Sep-14 5:49
Pete_1233-Sep-14 5:49 
AnswerRe: Copy selected listview item to a textbox VB.NET Pin
Eddy Vluggen3-Sep-14 7:14
professionalEddy Vluggen3-Sep-14 7:14 
QuestionRe: Copy selected listview item to a textbox VB.NET Pin
Pete_1234-Sep-14 7:01
Pete_1234-Sep-14 7:01 
AnswerRe: Copy selected listview item to a textbox VB.NET Pin
Eddy Vluggen4-Sep-14 8:15
professionalEddy Vluggen4-Sep-14 8:15 
AnswerRe: Copy selected listview item to a textbox VB.NET Pin
Tino Fourie24-Sep-14 6:49
Tino Fourie24-Sep-14 6:49 
Questionstring to byte, having trouble with line feed characters Pin
jkirkerx1-Sep-14 10:15
professionaljkirkerx1-Sep-14 10:15 
AnswerRe: string to byte, having trouble with line feed characters Pin
Dave Kreskowiak1-Sep-14 11:19
mveDave Kreskowiak1-Sep-14 11:19 
GeneralRe: string to byte, having trouble with line feed characters Pin
jkirkerx1-Sep-14 12:09
professionaljkirkerx1-Sep-14 12:09 
QuestionHow to use own collections in application settings in VB.NET? Pin
ponchofiesta31-Aug-14 21:35
ponchofiesta31-Aug-14 21:35 
AnswerRe: How to use own collections in application settings in VB.NET? Pin
Eddy Vluggen1-Sep-14 0:27
professionalEddy Vluggen1-Sep-14 0:27 
Questionwav to mp3 Pin
Ali Asgar29-Aug-14 4:52
Ali Asgar29-Aug-14 4:52 
AnswerRe: wav to mp3 Pin
Dave Kreskowiak29-Aug-14 5:05
mveDave Kreskowiak29-Aug-14 5:05 

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.