Click here to Skip to main content
15,843,200 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Sonhospa18-May-09 21:14
Sonhospa18-May-09 21:14 
GeneralRe: BackgroundWorkers 'RunWorkerCompleted' not fired Pin
Dave Kreskowiak19-May-09 18:14
mveDave Kreskowiak19-May-09 18:14 
NewsRe: BackgroundWorkers 'RunWorkerCompleted' not fired - Resolved Pin
Sonhospa18-May-09 11:53
Sonhospa18-May-09 11:53 
QuestionConvert Text file into Excel file Pin
vijay248218-May-09 0:14
vijay248218-May-09 0:14 
AnswerRe: Convert Text file into Excel file Pin
Rajesh Anuhya18-May-09 0:29
professionalRajesh Anuhya18-May-09 0:29 
GeneralRe: Convert Text file into Excel file Pin
vijay248218-May-09 1:09
vijay248218-May-09 1:09 
GeneralRe: Convert Text file into Excel file Pin
Rajesh Anuhya18-May-09 1:36
professionalRajesh Anuhya18-May-09 1:36 
AnswerClarification Please Pin
Dalek Dave18-May-09 0:29
professionalDalek Dave18-May-09 0:29 
Just to make sure I understand you correctly...


Do you want to pick up each line in the TextFile, and have it's contents put into a series of cells in XL where the spaces in the line are disposed of?

ie Number of children in one cell, number of balloons in next etc?
So that the cell contents are just the value as VALUE, not as TEXT?


Cos if so there are two methods, one is to just load the text into one cell and then split it via VBA in XL, or to pick up the text form the text file, scan it, apply each set of non space characters to a variable, then fire the variable into a cell in xl, continue until end of line, next line etc.

Which is the one you would like?

------------------------------------

"Possessions make you poor, wealth is measurable only in experience."
Sun Tzu 621BC

GeneralRe: Clarification Please Pin
vijay248218-May-09 0:55
vijay248218-May-09 0:55 
QuestionText is getting typed into another text box Pin
tiagu17-May-09 23:33
tiagu17-May-09 23:33 
AnswerRe: Text is getting typed into another text box Pin
Johan Hakkesteegt18-May-09 1:12
Johan Hakkesteegt18-May-09 1:12 
GeneralRe: Text is getting typed into another text box [modified] Pin
tiagu18-May-09 1:50
tiagu18-May-09 1:50 
GeneralRe: Text is getting typed into another text box Pin
Johan Hakkesteegt18-May-09 1:54
Johan Hakkesteegt18-May-09 1:54 
GeneralRe: Text is getting typed into another text box Pin
tiagu18-May-09 5:40
tiagu18-May-09 5:40 
GeneralRe: Text is getting typed into another text box Pin
tiagu18-May-09 5:52
tiagu18-May-09 5:52 
QuestionInserting block of file into a db...(logic issue) Pin
Lee Mwangi17-May-09 22:12
Lee Mwangi17-May-09 22:12 
AnswerRe: Inserting block of file into a db...(logic issue) Pin
Johan Hakkesteegt17-May-09 22:22
Johan Hakkesteegt17-May-09 22:22 
AnswerRe: Inserting block of file into a db...(logic issue) Pin
riced18-May-09 7:33
riced18-May-09 7:33 
QuestionRe: Inserting block of file into a db...(logic issue) Pin
Lee Mwangi18-May-09 21:27
Lee Mwangi18-May-09 21:27 
AnswerRe: Inserting block of file into a db...(logic issue) Pin
riced18-May-09 23:17
riced18-May-09 23:17 
QuestionProblem when Resoluction Change Pin
Anubhava Dimri17-May-09 20:56
Anubhava Dimri17-May-09 20:56 
AnswerRe: Problem when Resoluction Change Pin
Johan Hakkesteegt17-May-09 22:15
Johan Hakkesteegt17-May-09 22:15 
GeneralRe: Problem when Resoluction Change Pin
Anubhava Dimri17-May-09 22:54
Anubhava Dimri17-May-09 22:54 
GeneralRe: Problem when Resoluction Change Pin
Johan Hakkesteegt17-May-09 23:17
Johan Hakkesteegt17-May-09 23:17 
GeneralRe: Problem when Resoluction Change Pin
Anubhava Dimri25-May-09 2:04
Anubhava Dimri25-May-09 2:04 

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.