Search:

Type: Posts; User: Garratt

Page 1 of 4 1 2 3 4

Search: Search took 0.08 seconds.

  1. [EXCEL VBA] Read two Date Columns for a Total Time Difference?

    I'm trying to find a good way to do this.

    (say) I have a spreadsheet with two columns: IN and OUT.
    These two columns are in the full date-time format (mm/dd/yy hh:mm:ss). I need to go down...
  2. Re: Excel Constants Problem [help a total newb]

    That didn't help at all but I blame myself. :p I could not figure out how to get the v11 object library going

    I did figure out a way around it though

    "Imports Excel.Constants" takes care...
  3. Excel Constants Problem [help a total newb]

    Me = totally new to VB.NET

    I downloaded the free VB.NET express edition to give it a try at work. I have a bunch of VB6 applications that I would need to convert, most that end up dumping data to...
  4. How to make a web db when you know nothing?

    I'm pretty good with VB, but that's it (well, I know a little SQL).

    I have a need to make a web db. This would be for the purpose of asking a large number of multiple choice questions (radio...
  5. Thread: SQL problem

    by Garratt
    Replies
    4
    Views
    449

    TempA: Original String TempB: The search...

    TempA: Original String
    TempB: The search string ('BLUE') is inside of the TempA text
    TempC: The String to replace the found string with if found (i.e. if "blue' is found, replace 'blue' with...
  6. Thread: Ut2004

    by Garratt
    Replies
    12
    Views
    664

    UT2004 Onslaught is an amazingly fun online...

    UT2004 Onslaught is an amazingly fun online action game.

    I've played everything online or head to head starting with Doom I via a serial cable in the old days.

    (Considering That) I have to say...
  7. Replies
    1
    Views
    380

    Totally wrong forum. This is the VBA forum for...

    Totally wrong forum. This is the VBA forum for discussing "Visual Basic For Applications".

    You'll probaly want to post your question here:
    http://www.vbforums.com/forumdisplay.php?s=&forumid=11...
  8. Replies
    14
    Views
    1,183

    He'd need some type of matching key field for...

    He'd need some type of matching key field for that right though?

    Depending on what he's doing it could end up being a Union or even he could open two record sets at the same time... ?
  9. Thread: Can I...

    by Garratt
    Replies
    7
    Views
    1,044

    ? Open "C:\myfile.txt" for Output as #1...

    ?




    Open "C:\myfile.txt" for Output as #1

    Do until rs.eof = true
    Output #1, rs.fileds("myfield1") & "," & rs.fields("myfield2") & "," & rs.fields("myfield3" )
    rs.movenext
  10. Replies
    3
    Views
    696

    http://www.exceltip.com/st/Use_a_closed_workbook_a...

    http://www.exceltip.com/st/Use_a_closed_workbook_as_a_database_(ADO)_using_VBA_in_Microsoft_Excel/432.html
  11. Replies
    13
    Views
    1,309

    :p typo = copy and paste error.

    :p typo = copy and paste error.
  12. Replies
    2
    Views
    728

    http://msdn.microsoft.com/library/default.asp?url=...

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00k1.asp

    There should be nothing in that folder unless it was setup on purpose to database replicate. I'd say...
  13. Replies
    13
    Views
    1,309

    I think it would be something like: ...

    I think it would be something like:



    oldString = InputBox("Type the four digits you want to replace")
    newString = InputBox("Type in the Replacement Digits: ")

    strSQL = "SELECT SUB_ID,...
  14. Selecting records if two (text format) times are within 20 seconds...

    This post got really long (sorry).... To sum up, I'm looking for a way to make a select statment that says something like: "SELECT all records where the timestamp is withing +/- 20 seconds of this...
  15. Replies
    6
    Views
    590

    I'm a little boerd so I worked out a solution. ...

    I'm a little boerd so I worked out a solution. I'm sure someone smarter could find a more quick and simple way to do this, but here's what I came up with:


    (Assuming that Column A is filled with...
  16. Replies
    2
    Views
    690

    Wow... I had no idea. For "Input", "Line...

    Wow... I had no idea. For "Input", "Line Input" doesn't show up as a related topic in the help file.

    Poop - egg on my face.


    Thanks man :wave:
  17. Replies
    2
    Views
    690

    ASCII File input# problem w/ commas

    I'm using Excel VBA to read some big ASCII/Text files.

    I've run into a problem and finally figured out that when I'm INPUTing lines in from the text file, lines with commas in them are broken up....
  18. Replies
    2
    Views
    393

    Is everything always 2 alpha and 2 number? ...

    Is everything always 2 alpha and 2 number?

    TempstringA = Left(Cells(1,1).value,2)
    TempStringB = Right(Cells(1,1).value,2)
    TempIntegerA = Val(TempStringB)
  19. Replies
    1
    Views
    377

    A listbox can either be setup (properties) as a...

    A listbox can either be setup (properties) as a single selection type only, or a multi-selection type.

    Assuming you only have 1 selection enabled, you need to scan the listbox items first to find...
  20. Replies
    5
    Views
    528

    Sorry, I should have been more clear. One of...

    Sorry, I should have been more clear.

    One of the Oracle databases I pull data from is not under my control. For corporate security reasons (blah blah), I only have read access to that db. Plus,...
  21. Replies
    5
    Views
    528

    You wouldn't have an example of a small PL/SQL...

    You wouldn't have an example of a small PL/SQL file and what it would look like in VB would you? :)
  22. Replies
    5
    Views
    528

    Oracle PL/SQL file through VB ADO?

    Is it possible to pass a small Oracle PL/SQL program through a VB Oracle ADO connection?

    I haven't tried yet and was just wondering if it was even possible.
  23. OK, that didn't work at all. VB kept saying that...

    OK, that didn't work at all. VB kept saying that an object was required.

    But, I played around for awhile and this worked:


    Dim exl As Excel.Application
    Set exl = New Excel.Application
    ...
  24. Excel Object Library w/ VB6. Need some help/examples

    After searching around the forums, I found a reference to the Excel Object library and some starting code:


    Dim exl As Excel.Application
    Set exl = New Excel.Application
    etc..

    How to I use...
  25. Thread: path

    by Garratt
    Replies
    3
    Views
    410

    There are different types of mail objects, but...

    There are different types of mail objects, but all of them will email the open file, or a single sheet from it.

    So, you don't have to worry about where the file lives.


    :( I'm late for work,...
  26. OK, that's cool... I'll give that a try at work...

    OK, that's cool... I'll give that a try at work today. The only problem would be that Sheet1 is not a static size. So I guess I would need to make the VLookup up on the fly and insert it into the...
  27. Replies
    2
    Views
    518

    I can't picture what you are trying to do at all....

    I can't picture what you are trying to do at all.

    Can you upload a small example sheet or something?


    Column A has computer brand names
    Columns B:H have.... ?
    Columns I:O have.......?
    ...
  28. [EXCEL VBA] Help - Datafilling 1 wks from another (need a fast method)

    I've got a massive Excel VBA 'macro' that in the middle of running ends up with two worksheets of data. These two sheets are farily large, containing up to 5,000 rows of data on the largest.
    ...
  29. Thread: vb for excel

    by Garratt
    Replies
    4
    Views
    560

    MyString = "sheet1" ...

    MyString = "sheet1"

    Worksheets(MyString).activate
  30. Replies
    4
    Views
    576

    I was curious enough to look around for a few...

    I was curious enough to look around for a few seconds.

    I found this,
    http://www.excelforum.com/t209535-s

    But got boerd a few posts down. :p
  31. Replies
    2
    Views
    664

    If you click on the workbook item you can create...

    If you click on the workbook item you can create a "open" sub in there:

    Private Sub Workbook_Open()
    'code
    End Sub


    But, because of security issues of course the user only has to hold down...
  32. If you load a .dot file or any word document,...

    If you load a .dot file or any word document, access to the macro subroutines exist as long as they are "Public" subs.

    I'm guessing you pointed to it's location as a template folder location and...
  33. Are you saying you have a "Normal.dot" file on a...

    Are you saying you have a "Normal.dot" file on a shared or network drive and both of you have changed the "File Location" for templates to that dive (and it still doesn't work)?
  34. Replies
    4
    Views
    760

    From what? Which office product and which...

    From what? Which office product and which office version?

    I'm guessing you're talking about Outlook.
  35. Replies
    9
    Views
    1,141

    Just a guess, but considering what the error...

    Just a guess, but considering what the error points to, try changing the cell type to "text" for the cells in the "Name" column.

    The first name is a number. Since the cell type is "general" Excel...
  36. Replies
    9
    Views
    1,141

    You should "Google" the phrase "data type...

    You should "Google" the phrase "data type mismatch for criteria expression"

    I just did it and it game me a lot of ideas as to what the problem might be.


    example:...
  37. Replies
    1
    Views
    462

    Go into the Visual Basic Editor. Double click...

    Go into the Visual Basic Editor.

    Double click one of the worksheet items under "Microsoft Excel Objects".

    Add this code:


    Private Sub Worksheet_SelectionChange(ByVal Target As...
  38. Replies
    1
    Views
    394

    Repaints of the form my be causing delays. You...

    Repaints of the form my be causing delays.

    You could try adding in some screenupdating toggles to manually refresh the screen every so often (so the user doesn't think things have crashed.


    ...
  39. Replies
    10
    Views
    612

    If you have multiple forms, global variables...

    If you have multiple forms, global variables won't work.

    Jmacp has the right idea... On one of your forms make either a text box or label for ever variable you need to share.

    ...
  40. Replies
    2
    Views
    539

    File Access - Reading the Last Line?

    This is for Excel97 VBA if it matters.

    I've been trying to read up on the file access methods but I'm a little slow this morning:
    (example)...
Results 1 to 40 of 160
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width