thnq for the reply...
when I replace the line with the mentioned line the output stays only in one column...i.e. in column A...but I want the partition in different columns like A, B, C, D....Z...
sivadhanekula
Last Activity: Aug 4 '09, 02:03 PM
Joined: Nov 3 '08
Location: Germany(presently)
-
-
How to get the Next alphabet...in vb6
Hi all
I am working on excel, Macros with vb6....When I was writing the for loop I got stuck with getting the next alphabet...Like I need to extract the data from a database and I need to split that data in to equal parts and each part should go to diff column in the excel sheet like A, B, C, D.....Z
if you look at the code
in the code if you look at the Bold letters...and when the loop is running... -
Reg: Output as repeated input
Hi everyone,
I am working on vb6, macros with excel 2003...in the vb code I am able to claculate the mean value of the data and I need that value in the graph with a full line not at the point(Mean value)...could you plz help me how can I get that value for more than one time...
i.e if my mean value is 5, with that 5 only a dot in the graph is coming, but I want a single line at that particular point...so may be it'll... -
Visual basic in excel: Reg the output sheet
Hi all,
I have to do a project in excel by usung vb. The coding part is done and I am getting the output in .CSV format. when doing project in the main excel sheet I will be having 3 sheets and for every sheet I have done some coding and in the 3rd sheet I have linked with the other sheets, now after running the program my output is the extracted database to be save in .csv format that is happening quite good where the out is saving... -
Hi...Thank you for the reply...
Problem is not with that...it is with LIMIT...if you look at the whole code...I have too many values in Fullname...but I want only the values of certain interval...and for that reason I have used LIMIT statement...but when I use this I am getting only one column and the other columns are nill...The column I am getting is Fullname with all names in it....without any limit....my question is...is there...Leave a comment:
-
How to write SQL statement with LIMIT in it in Visual basic
Hi...every one...
I have a problem with below statement
here the underlined fullname is the item from combo box
If I have the same statement without LIMIT then the program is working...if it is with LIMIT I have some problem...is the statement I have given correct?...
if not can you plzz kindly give me suggestions of how to write an SQL statement with LIMIT in Visual Basic...... -
Thank you...it worksLeave a comment:
-
SQL statement to select only one name from a lot of same names
Hi every one....
I have SQL statement like "Select Fullnmae from abssubtest" and if I do so the output is the list of all data containing in the Fullname...incl uding the data with same names is repeating...I dont want the repeated data...i.e. if the Fullname data has
1. Ulm
2. Prague
3. Frankfurt
4.Prague
5. Frankfurt I want the output as only
1.Ulm
2.Prague
3.Frankfurt... -
Ok...Just for you to remember...I am searching for the code that the extracted data with the help of SQL statement should be saved in file".csv"...an d before doing that if the data has "," in it then it should be converted to "." automaticallay and should save in the file...
Thank you very much for your helpLeave a comment:
-
can I write this.writetofil e(s)...instead of writetofile(s). ..is that what you mean...if so I didn't get the output..the screen was blank!Leave a comment:
-
I have done the above program..but after pressing the run button..I am getting the blank screen and after some time the vb is not responding and I have to close the program...even I have seen it with break point but of no use....can you please tell me where I have done the mistake...
Regards
Siva...Leave a comment:
-
Sorry I didn't get you!..Leave a comment:
-
Hey...I'm sorry...bit confused with rows and columns...but anyways u got me correct...and regarding the program I am getting an error "Sub or Function not defined". and highlighting at WritetoFileLeave a comment:
-
Is Append in the open statement correct, if I use this I am only getting the last field data if I have n fields...and If I use Output instead of Append I am getting only the last value of last field...and one more thing if I use the msgbox I was asking to press Ok for every data that is entering to the file...I have 100's of data and I can't press Ok for each time...any solution for that
the other question was?
If I...Leave a comment:
-
thank you for the reply...may be you might have understand my question in wrong way or my english was poor..I dono...but I am not looking for the data conversion...al ready I have the data that is in the required format...which I dont need to convert...all I need is the extracted data should be saved to file that was specified by me...I have tried some thing if you look at the program....now I can take my extracted data to that particular file...but...Leave a comment:
-
Ok...I'll wait for you...if possible make it fast ah.....thanqLeave a comment:
-
haaa....I am totally new to Visual basic....I am not able to understand what you are telling...can you explain in detail...plzz.. .I have done some program to extract the data...in the program if you look at the SQL statement(under lined) I want to insert all the values of fullname into the combo box, so that if I select one of the fullname then the data regarding that fullname should be extracted and should be displayed after pressing the Ok butt...Leave a comment:
-
How to give an SQL statement in combobox(Visual basic 6.0)
Hi everyone..
I want to insert a combobox with the list of test names of a database, but the testname contains 15000+ data, and I cant type all the data. so can any one help me in writing an SQL statement, so that if I give that statement it will automatically swaps the table names to the combobox.
P.S I know the SQL statement but I dono where to give that SQL statement in combobox
explanation with program... -
ya..If I run the above program, there are no errors in it and I am able to extract the data from the database...now I have to save that extracted data in an excel sheet directly with the help of program... i.e. I have to take a file and write some program so that if I run the program the extracted data will be automatically saved to an excel sheet...hope you understand!...p lease can you help me in this...
Thank you for your suppor...Leave a comment:
-
Thank you...now the program is running!!!....
Can you help me how to Take a FILE in between the program to save the extracted data into it so as it could be helpfull for the future, analysis task.
Thank you
Regards
SivaLeave a comment:
No activity results to display
Leave a comment: