Recent content by Tommy B

  1. T

    use a variable as a pathname for Dir() function?

    Thanks Wayne...I'll check it out :D
  2. T

    use a variable as a pathname for Dir() function?

    Hi All, Well I'm getting quite into vba now...not any good, but its addictive :D I'm trying to write a little procedure that checks for the existance of various files in a directory. The files will be stored in different named folders dependant on month i.e. jan, feb, mar, etc. What I want...
  3. T

    Dir Funtion?

    Thank-You Brilliant, thanks Shadez. Iwas close but no cigar :p Thanks again for taking the time to help me out...much appreciated! Cheers, Tom. :D
  4. T

    Dir Funtion?

    Hi Guys, Well I'm bumbling along with my vba and have had some success (mainly due to the patience and indulgance of fellow members:p ). However I have a hit a problem with the Dir function, I know I must be wrong but I would really appreciate somebody showing me the error of my ways. I'm...
  5. T

    Using VBA to check whether a file in a folder in a certain drive exists.

    Hi, This is not my code so all credit/thanks should go to I think fuzzygeek!? 'Check to see if a File exists ' Public Function strfisfile(stPath As String) As Boolean 'Fully qualify stPath 'To check for a file example ' fIsFile("C:\FolderName\FileName.doc") ' On Error Resume Next strfisfile =...
  6. T

    How do I create a batch file?

    Okay I got it to work...was a problem with my SOE work machine....wouldn't let me run a batch!!! Thanks for all the help guys :D Tommy B
  7. T

    How do I create a batch file?

    Hi Sambo, Thanks for pointing this out...as I'm a newbie this would never have occured to me:o I'm having trouble writing my batch file anyway, can you give me any help? I know it should be simple but I just can't seem to get the syntax right...have been searching the net for a giude or FAQ...
  8. T

    How do I create a batch file?

    Thanks IgorB that was just the info I was after :D Cheers, Tommy B :cool:
  9. T

    How do I create a batch file?

    Cheers for the replies guys. I'd rather just write code to import one file than ten. That's my reasoning :rolleyes: Tommy B
  10. T

    How do I create a batch file?

    Hi Guys, Here's my problem...well the IT related one anyway :D I have 10 text files that I want to append into one file before I import into my database. I think a batch file is the best option for achieving this, so how do I create one? I know this is a bit wide of the mark in terms of...
  11. T

    Just feeling my way with VBA...

    Nice one :) Thanks a million Fuzzygeek...I just couldn't get my head around it, your example has shown me the light...lol!:D I will give it a go now. Once again thank-you for taking the time out to help! Cheers, Tommy B
  12. T

    Just feeling my way with VBA...

    Hi Guys, Just getting into vba and I have the following problem: I have written the following code whose purpose is to look in a directory for specific text files and import them if found, if they aren't there I want a msgbox to appear telling the user which files are missing. This works fine...
  13. T

    Please support these forums

    Hi, I'm just about to design my own homepage and if it helps I'll put both links on it. This forum has helped me out of more holes than i care to remember and basically has helped my career too. Anything I can do to say thank-you i will :D I'm sure many people here feel the same way. Tom.
  14. T

    Matching Text Strings?

    Many thanks for the heads-up Doc Man. I'll go hunting on that subject now :p Cheers mate, Tommy B :D
  15. T

    Finding Dupes.

    Hi Col, Butt in all you like :p I will give your solution a try, I think I see where you are coming from. Thanks for the help both of you :D Cheers, Tommy B
See more
Back
Top Bottom