-
Began Watching Science
who has been a teacher before i know i haven't this is my first time being one can anyone give me any tuips about being a teacher? -
Replied To a Post in Science
Wow, did this topic get derailed or what? As for teaching, I would like to add that your written word is important. For instance, > who has been a teacher … -
Began Watching Comic Con NY 2014
After a week of Jewish holidays bookending Advertising Week, SMX East, IAB Mixx, and OMMA, I took a break this past weekend to attend Comic Con NY at the Javits … -
Replied To a Post in Comic Con NY 2014
Maybe she was sweating while working on them? :) -
Replied To a Post in VBA Assistance
To start, that is way too much criteria regarding things that only you know about. I'm not even sure what you mean by forward pass and backward pass methods. I … -
Gave Reputation to Not Available in VBA Assistance
Please Could Someone Help Me With some VBA coding. I have project To determine the critical path Method (details below), I have attempted to do the majority of the coding … -
Replied To a Post in VBA Assistance
What about your previous problem? -
Replied To a Post in VBA Assistance
Hi Lynton 1, You'll have to adapt this to your own needs as you weren't specific regarding which column. Sub FindNumeric() Dim wS As Worksheet Dim oC As Range 'Loop … -
Began Watching VBA Assistance
How do i do a loop which is verifying that cells in the same column are numeric until the last cell which will be determined by an empty cell? Thanks … -
Stopped Watching VBA Assistance
How do i do a loop which is verifying that cells in the same column are numeric until the last cell which will be determined by an empty cell? Thanks … -
Began Watching VBA Assistance
How do i do a loop which is verifying that cells in the same column are numeric until the last cell which will be determined by an empty cell? Thanks … -
Began Watching Starting an application within a timer
Hello group! I've created a short program to open an application at a specific time. It's working but is attempting to open the application multiple times. What should I be … -
Replied To a Post in Starting an application within a timer
Or maybe If DateTime.Now.TimeOfDay = "12:02:00 AM" Then... However I did not test that and am only really guessing. -
Began Watching Bad computer habits
Here's Some of my habits that i picked up over the years, How about you? - Refresh every 5min - my fingers are on "A", "W" and "D" keys - … -
Replied To a Post in Bad computer habits
Aside from having my desktop, laptop, and phone blaring at me, I am always guilty of fast-saving files and such onto my desktop. Every other month or so I have … -
Began Watching Internet Marketing
I know I have the right system and the right mentor. This is very important to me. I researched both. I made several sales this week by using pay per … -
Replied To a Post in Internet Marketing
There is a lot to learn and good for you for making the effort. It seems to me that you are going about things the right way but make sure … -
Replied To a Post in What are you eating/drinking right now?
I had supplements for lunch today and a pool of water! -
Began Watching Finding a date in a column via VBA
Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a … -
Replied To a Post in Finding a date in a column via VBA
Hi Don, I'm not sure if what I have will help but if you select the date to find and then run the code, it should find it on the … -
Marked Solved Status for Search Through C:\ - VBScript
Hi All, I'm working on a script which has a primary function to look for jpg files. I can get it to work if the folder path is just my … -
Gave Reputation to cgeier in Search Through C:\ - VBScript
Add the following to the end of the script: '==================================== 'Loop through the files in the 'sub-folders in the path 'from above (objStartFolder) '==================================== ShowSubFolders objFolder Sub ShowSubFolders(Folder) On error … -
Replied To a Post in Search Through C:\ - VBScript
Thanks a lot for that. Now that the error is gone, I'm finding that the script is not actually searching through each folder in C:, it is just searching through … -
Gave Reputation to cgeier in Search Through C:\ - VBScript
The reason for your error is because Mid throws an error if the value of start is < 1. [Mid Function](http://msdn.microsoft.com/en-us/library/wffts6k3(v=vs.84).aspx) *start: Character position in string at which the part … -
Gave Reputation to cgeier in Search Through C:\ - VBScript
Try deleting the following code (lines 15-17): if (LCase(Mid(objFile.Name, InstrRev(objFile.Name,"."))) = ".jpg") then oFile.Write objFolder & objFile.name & vbCrlf end if and replace it with this: if (LCase(objFSO.getextensionname(objFile)) = "jpg") … -
Created Search Through C:\ - VBScript
Hi All, I'm working on a script which has a primary function to look for jpg files. I can get it to work if the folder path is just my … -
Began Watching Search Through C:\ - VBScript
Hi All, I'm working on a script which has a primary function to look for jpg files. I can get it to work if the folder path is just my … -
Replied To a Post in Random Facts
LoL, yeah but that's not from the pot is it? Or is it!!!! On a serious note; during my time as an adult, I've never understood the laws that prohibit … -
Replied To a Post in Random Facts
Ya but marijuana is evil and a scourge against all societies RJ. Plus, men will grow boobs and become gay if they smoke it. LoL, that's what the doctors a … -
Replied To a Post in Things I hate about TV shows
> Looks like those "Housewives of XYZ" shows are about as real as it is amongst typical American housewives! See, now that's what I don't really understand about many in … -
Replied To a Post in Things I hate about TV shows
I know I've stated before that I have a distaste for reality tv but I thought I would pose a real question about that genre of crap; who's reality is … -
Replied To a Post in VBA - How to convert xls, xlsx files in a directory to csv
Hi Summer 1, Perhaps you should post this question in a database related forum, located around [here](http://www.daniweb.com/web-development/databases/ms-sql/127). This thread is dealing with Excel VBA. -
Gave Reputation to Tensigh in VBA - How to convert xls, xlsx files in a directory to csv
According to this: http://msdn.microsoft.com/en-us/library/zwwhc0d0(v=vs.90).aspx it basically says that that error means you're referencing a non-shared item (whatever that is) without an object reference. Since opening an Excel workbook requires a … -
Replied To a Post in VBA - How to convert xls, xlsx files in a directory to csv
> The workd set deletes itself... Really? I've never heard of that happening before. Where are you applying this code exactly? Is it in Excel's VBE(Visual Basic Editor)? -
Began Watching VBA - How to convert xls, xlsx files in a directory to csv
I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets … -
Replied To a Post in VBA - How to convert xls, xlsx files in a directory to csv
I think Tensigh got it on the last post. @Summer, you had stated your code line to be: wb = Workbooks.Open(fPath & fDir) While it should be Set wb = … -
Replied To a Post in Administrator Issues & Cannot Run Windows Update
Yes I did and nothing came of it. -
Created Administrator Issues & Cannot Run Windows Update
Hi All, I have two issues that I cannot seem to resolve using Google. 1. My windows account, the only one I have, is the Admin account. However, I cannot … -
Began Watching Administrator Issues & Cannot Run Windows Update
Hi All, I have two issues that I cannot seem to resolve using Google. 1. My windows account, the only one I have, is the Admin account. However, I cannot … -
Replied To a Post in 4th dimension
It occured to me that since time is not constant but rather relative to the observer, could it really be a part of dimensional thinking? -
Replied To a Post in Education
I can't really answer that RJ, except to say that the pressures of work and the pressures of an exam are two entirely different situations. I do just fine with … -
Replied To a Post in Education
I don't argue against verification and am proud of my education. However, I get nervous if an employer (like Hydro) requires a the transcript. -
Began Watching Education
Do we really need accrediated education to effectivly have the expected experience and/or knowledge in a chosen field? For instance can we learn more from doing a course in programming … -
Replied To a Post in Education
A point I wanted to make on the transcript is that even that is not a true depiction of one's ability. It doesn't take into account a whole bunch of … -
Began Watching Save DataBase !?
Hi.. How can I save and block the data base (Access) by VB6 ? I made a pass word for the data base, but not enough !! some programs can … -
Replied To a Post in Save DataBase !?
See [here](http://office.microsoft.com/en-ca/access-help/about-user-level-security-mdb-HP003070410.aspx) to set user-level security instead of just using a password. Passwords only provide limited restrictions in Access. -
Began Watching how to create excel file using data from access database
hi is there someone that can give me some hints on how to create excel file using data from my ms access database..because i haven't seen one in the net … -
Replied To a Post in how to create excel file using data from access database
You don't need Crstal Reporting for this. It's as easy as clicking the Data tab and then "From Access" and then follow the prompts. -
Began Watching format a text to display in flexgrid
can anyone help me arrange my code?..i would like to format a text to be displayed in a flexgrid.. Format(len(rs!UserPassword),"•") the len = 11 so i would like to display … -
Replied To a Post in format a text to display in flexgrid
Have you tried assigning the length to an integer variable and then using that variable in the format?
The End.