-
Replied To a Post in issue in crystal report(8.5) opening with VB 6.0
That's not much to go on. My gut tells me it's a local systems issue ie your computer can't handle (have the resources) the report gerneration. Do you think this … -
Began Watching MDB to excel
Hi I will from the database only copy some textboxes to excel to specifik place in the excel sheet Just those from the database surename,lastname,adress,zip,zipadress,prn only one at the time … -
Replied To a Post in MDB to excel
You haven't asked anything here. In any case, did you try clicking the "Data" tab and then "From Other Sources"? If you follow the prompts you should be able to … -
Replied To a Post in How is the weather today in your country?
-28, feels like -35! It's like a spring day here! -
Replied To a Post in Macro to adjust Row Height based on cell Character Count
Try shutting off sheet calculations in the procedure: Sub ShrinkToFit() Dim wS1 As Worksheet Dim aRng As Range Dim oC As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set wS1 … -
Replied To a Post in Macro to adjust Row Height based on cell Character Count
I just tested this code on 150,000 lines and it took about 20 seconds. I'm not sure why it's taking so long with your workbook. Do you have a bunch … -
Replied To a Post in Macro to adjust Row Height based on cell Character Count
It's freezing because it's making a fair amount of changes to the layout of the sheet. I'm sorry, I should have turned off screen updating in the example I gave … -
Replied To a Post in Macro to adjust Row Height based on cell Character Count
I see you've come back to Daniweb well after I posted my last comment. Can you please let me know if that worked and if so mark the thread as … -
Replied To a Post in EXCEL LOOP....
I forgot to set the screen updating, before and after all the work in the procedure gets done. Sub promotion() Dim ws As Worksheet Dim cl, region As Range Application.ScreenUpdating … -
Began Watching Best first lines of a song
What's you favourite first line, or start, to a song? Mine varies according to my mood, but currently it has to be: **"Everybody here comes from somewhere that they would … -
Replied To a Post in Best first lines of a song
I am the tv cuz tragidy fills me, whatever flavour, it happens to be like. Tool - Vicarious -
Began Watching excel
Hi there displaying data on an excel to a already designed web page ? i have no idea at all -
Replied To a Post in excel
Designed by what? Maybe something like (but has not been tested): <iframe src = "YourExcel.xlsx" width="100%" height="100%"></iframe> but you must have your Excel file in the same folder path as … -
Gave Reputation to Minimalist in School Timetable
Well, I do think you might want to reconsider. 1)There are already lots of these programs around. 2)VB6 doesn't cut it anymore. Why? 3)I have coded and sold a program … -
Began Watching School Timetable
Hi comrades. I am new to VB6 and I have a problem. I would like to develop a programme that generates a school timetable. The school is three steamed from … -
Replied To a Post in School Timetable
You'll have to be more descriptive as I'm not sure what three steamed from form one to form four means. -
Replied To a Post in Macro to adjust Row Height based on cell Character Count
You'll have to adjust the sheet name, the cell numbers (wS1.cells(x,x)) and the RowHeight but the following will get you where you need to be. Sub ShrinkToFit() Dim wS1 As … -
Began Watching Macro to adjust Row Height based on cell Character Count
I have a 31,000 line spreadsheet, that will become a printed book. Based on the current column width (which has to stay the same for printing purposes) there are many … -
Replied To a Post in Macro to adjust Row Height based on cell Character Count
What specific height? -
Replied To a Post in EXCEL LOOP....
Without criteria the following will do it for you: Sub IncrementCells() Dim wS1 As Worksheet Dim cRng As Range, oC As Range Set wS1 = Worksheets("Sheet1") Set cRng = wS1.Range("C2:C1001") … -
Began Watching EXCEL LOOP....
Hi Champs, Im using VBA for Excel. and Im trying to use the code below to move through records and increment their values by one since they meet a certain … -
Replied To a Post in EXCEL LOOP....
What is the criteria for incrementing? -
Marked Solved Status for Write to File
Not sure if this is the right spot for this question but I'm here! I'm trying to make a vb script that opens large text files, one at time, searches … -
Replied To a Post in Write to File
Well my solution has been built in the form of VBA. The following does what I need and it works way faster than the script I have. Sub RnR_Nulls() Dim … -
Replied To a Post in Write to File
I mean the vbscript takes about 15 minutes to go through each line and do it's thing. I tried your suggestion but I get "Expected End of Statement" errors. Thanks … -
Replied To a Post in Write to File
I'm still trying to solve this but to no avail. I've tried the following functions: Do until objFile.AtEndOfStream strCharacters = objFile.ReadLine newStrCharacters = strClean3(strCharacters) on error resume next f.WriteLine newStrCharacters … -
Began Watching Converting Standard Form Quadratic to Vertex or Opposite
So I just finished up a way to solve Standard Form Quadratic Equations, Now I want to code a way to automatically Convert a given Standard Form equation to Vertex … -
Replied To a Post in Converting Standard Form Quadratic to Vertex or Opposite
This type of math is definitely not my strongest point so I'm hoping that [this](http://www.mathwarehouse.com/geometry/parabola/standard-and-vertex-form.php) can help with your equations. In saying that, if it were me writing the code, … -
Gave Reputation to Reverend Jim in How is the weather today in your country?
Back from Bulgaria? -
Replied To a Post in How is the weather today in your country?
It's warming up!! [Winnipeg Weather](http://www.theweathernetwork.com/weather/canada/manitoba/winnipeg) -
Began Watching Birthdays
I have another birthday anniversary today, I'm now only 39, with 32 years of experience. -
Replied To a Post in Birthdays
Happy belated AD. -
Replied To a Post in What movie have you seen lately?
It was a classic and I would say still so however Hollywood can do so much more with graphics now, which made the new one better imo. Plus, I liked … -
Replied To a Post in What movie have you seen lately?
Carrie was alright, better than the first imo. -
Replied To a Post in Write to File
Hi SalmiSoft and thanks. I did realize that about the Asc call and switched Chr with Asc but it seems it is the Write that's erroring because the newStrCharacters holds … -
Replied To a Post in What IT path should I follow ?
Well if you're not doing what you love, like coding, and you can accept a temporary reduction in pay; then yes, move on as it will no doubt do your … -
Began Watching Get highest in row help!
I am trying to get the highest value in my rows. I have been at this awhile trying to figure it out. I assume it is suppose to return 3 … -
Replied To a Post in Get highest in row help!
Hi lauren.vitiello.12, I'm not entirely sure if this will help but try changing col < numbers[row].length to col < row Or something like that. Does your code even compile like … -
Began Watching What IT path should I follow ?
I work in a european country branch for an international company with thousands of employees globally. My job is to administer the network and infrastructure. Actually what I am doing … -
Replied To a Post in What IT path should I follow ?
My own opinion, which may or may not mean much is this; you are doing too much! Even your 9 to 5 job there is just too much for one … -
Replied To a Post in Macro to copy values from columns and insert into column list
Nevermind, it's marked solved, thanks. -
Replied To a Post in Macro to copy values from columns and insert into column list
You're very welcome. If it worked like a charm and your issue has been resolved, please mark this thread as solved and have a great day. -
Began Watching VB Project
Sir i want to know what is the complete and correct code of daily report of an inventory control system in vb6 -
Replied To a Post in VB Project
How can you expect anyone to know something like that and that they would be able, or willing, to just provide it all in one go? I would imagine that … -
Replied To a Post in Macro to copy values from columns and insert into column list
Alright, try the following on a data sample and let me know how it goes. Sub OrganizeItemColumn() '*****************************************************************' '**This procedure goes through a user-defined column **' '**Most likely A and … -
Began Watching Macro to copy values from columns and insert into column list
I copied a list into Excel and some of the list formatted into the neihgboring columns instead of lining up in the list. I need to get the items floating … -
Replied To a Post in Macro to copy values from columns and insert into column list
Hi Jeffrey 1, this is definitely doable but may take a moment to come up with the right macros to make. In saying that, there will be a significant amount … -
Replied To a Post in What movie have you seen lately?
I'm going to watch the new Carrie tonight on Bluray. I liked the old one and have heard good things about this one. -
Created Write to File
Not sure if this is the right spot for this question but I'm here! I'm trying to make a vb script that opens large text files, one at time, searches … -
Began Watching Write to File
Not sure if this is the right spot for this question but I'm here! I'm trying to make a vb script that opens large text files, one at time, searches …
The End.