Search:

Type: Posts; User: HeSaidJoe

Page 1 of 13 1 2 3 4

Search: Search took 0.46 seconds.

  1. Replies
    1
    Views
    350

    Excel Sheet is Hidden.

    I am writing to an excel sheet behind the scenes. When I send the sheet to a user and they open it, they open excel but the sheet is for some reason hidden. Is there some code I could use in my save...
  2. Replies
    1
    Views
    417

    Exe Inside another App

    Question:
    I have and exe vb app. It has 3 textboxes and I would like it to seltext and selstart but I don't have the original code .. just the exe file.

    Is there a way to run this inside another...
  3. Replies
    4
    Views
    431

    Like Operator

    Lets say I have a line like

    ************* ** 2345 Page 1 *****

    how do I say if I find the word page then msgbox "Page"
  4. Thread: Word

    by HeSaidJoe
    Replies
    7
    Views
    480

    thanks all...

    thanks all...
  5. Thread: Word

    by HeSaidJoe
    Replies
    7
    Views
    480

    Ok .. I have it all except one thing .. comes...

    Ok .. I have it all except one thing ..

    comes up with a do you want to save changes...

    how can I skip the conversation and just close the sucker as I am not making changes, I am only printing.
  6. Thread: Word

    by HeSaidJoe
    Replies
    7
    Views
    480

    Word

    I have created a word object with a reference .. oWd

    what is the syntax to open a word document.

    oWd. ???????????????
  7. Thread: Excel

    by HeSaidJoe
    Replies
    6
    Views
    537

    oh, and technically cells with formulas ARE in...

    oh, and technically cells with formulas ARE in use, they just don't necessarily have a visible value (depending on the formula and the values it references).

    I realize that .. I guess my...
  8. Thread: Excel

    by HeSaidJoe
    Replies
    6
    Views
    537

    Help ... Si_the_geek That works but not in my...

    Help ... Si_the_geek

    That works but not in my situtation as there are formulas and some of the lines have zero totals on the line so the line shows that it is in use when it isn't.

    Here is a...
  9. Thread: Excel

    by HeSaidJoe
    Replies
    6
    Views
    537

    excellent answer: Thank You. .. would you...

    excellent answer: Thank You.

    .. would you happen to know how I can search the open worksheet for the next available free line so I can start entering code at that point.
  10. Thread: Excel

    by HeSaidJoe
    Replies
    6
    Views
    537

    Excel

    'Reference made to excel 8.0

    Dim xlApp as excel.application
    dim xlBook as excel.workbook
    dim xlsheet as excel.worksheet
    dim myFile as string

    myFile = "C:\myfolder\myfile.xls"

    Open myfile...
  11. Thread: Ping A Mac

    by HeSaidJoe
    Replies
    4
    Views
    325

    View Post

    My error, the question was from my network co-partner..should have read ...

    how do you ping from a Mac
  12. Replies
    0
    Views
    286

    View Post

    Dim b As Bookmark
    If collbookmarks.Count <> 0 Then
    MsgBox "Nothing to remove"
    Else
    Set Favs = New bkmarks
    Favs.Remove Index ' whatever the index number you want removed
  13. Thread: Ping A Mac

    by HeSaidJoe
    Replies
    4
    Views
    325

    Ping A Mac

    anyone know how to ping a Mac to see it it's alive
  14. Replies
    1
    Views
    394

    View Post

    Set the ListBox sorted value to true
  15. Thread: <?>

    by HeSaidJoe
    Replies
    2
    Views
    475

    View Post

    Thanks.
  16. Thread: <?>

    by HeSaidJoe
    Replies
    2
    Views
    475

    View Post

    I have a bitmap stored in a res with id 101

    IF I want to load Image1 with the bmp , how do I do that.
  17. Replies
    6
    Views
    464

    View Post

    FRAIL_KNIGHT
    I have no clue as to how your answer is supposed to help . LOL

    Peet
    I have tried yours and it would seem to have a purpose for flickering once the picture is set, however, I am...
  18. View Post

    Textbox with locked set to true ?????
  19. Replies
    6
    Views
    464

    Lose the filicker in Image Box??

    I have tried this but it flickers when changing.

    Form is Black Background


    'Form keypress event

    Image1.visible=false
    Set Image1.Picture = nothing
  20. Thread: I need Help

    by HeSaidJoe
    Replies
    4
    Views
    283

    View Post

    'your program is doing what you ask of it. "" GIGO"
    'You asked for the time difference in days, the difference in hours,
    'the difference in minuites & the difference in seconds
    '
    'you merely...
  21. Replies
    6
    Views
    330

    View Post

    If WeekDay(Now) = 2 Then
    'Bla bla bla
    End If
  22. Replies
    5
    Views
    459

    View Post

    Ok...seems ok now ..thank you again.
  23. Replies
    12
    Views
    413

    View Post

    You could open it as a text document and then save it as a word document .

    Private Sub Command1_Click()
    'pass it the name of the text file and the filename you want it saved as
    Call...
  24. Replies
    5
    Views
    459

    View Post

    Still doesn't want to work .. originally I had automatically checked off and I changed it to ..every visit to the page, check for new page and it still doesn't give me the latest page, just the one...
  25. Replies
    5
    Views
    459

    View Post

    Thanks
  26. Replies
    5
    Views
    459

    Not VB .. MS Explorer

    Is there a setting in MS Explorer to make it refresh each time it revisits a page .. I open pages and they are opening from my memory and I want to open the latest version of the page.
  27. Replies
    4
    Views
    388

    View Post

    You could chop your code down as well if you are interested



    Private sub ...
    Open stFileName For Output As #1

    If myVariable = True Then
    frmDialog.Caption = "Save As"
    Print #1,...
  28. Replies
    14
    Views
    541

    View Post

    MaskedEditBox1.Mask = "##:##"
  29. Replies
    33
    Views
    584

    View Post

    Depends on what is in your program. If you are using a single form and no created objects then you would simply put and unload in the code for your Command Button.

    Private Sub Command1_Click
    ...
  30. View Post

    Perhaps a silly question, but have you installed Crystal.
    Crystal reports is not automatically installed when you install VB6.

    If it isn't installed you won't find it in projects components.
    ...
  31. Thread: Call a Sub

    by HeSaidJoe
    Replies
    21
    Views
    612

    View Post

    Simplified version of what you are doing

    [code]

    Option Explicit

    'this is your command button on your main form
    Private Sub cmdPrint_Click()
    PrintReport
    End Sub
  32. Replies
    10
    Views
    489

    View Post

    'If you look, I lost this as well.
    If Shift = vbCtrlMask Then

    As far as all that other stuff ... who knows??? You can have other controls on the form.
    The code I gave you works or you can use...
  33. Replies
    10
    Views
    489

    View Post

    Option Explicit

    Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Select Case KeyCode
    Case vbKeyF1: MsgBox "F1 pressed."
    Case vbKeyF2: MsgBox "F2 pressed."
    Case...
  34. Replies
    4
    Views
    381

    View Post

    Thanks

    ..six months off makes one slow!!!!!!!!!!!!!!!!!
  35. Replies
    4
    Views
    381

    Mouse Over Listbox Text

    ListBox1 (data)
    A
    B
    C
    D

    Text1 reflects what is selected in ListBox1

    IE. if I click c in the listbox c goes to the text box
  36. Replies
    12
    Views
    455

    View Post

    Blaster..think I have found a similar situtation...
    try this version.
  37. Replies
    12
    Views
    455

    View Post

    I don't get that runtime errror. Perhpas it's because I have some little thing pointing to my pc...can someone else give it a go and see if you ge the runtime error..while looking for it I found a...
  38. Replies
    12
    Views
    455

    View Post

    ????
  39. View Post

    that could be me...I've used <?> in the subject for so long, every now and then I set a question with that title...if I catch it I delete it and start it over with a topic as <?> in a search would...
  40. Replies
    12
    Views
    455

    View Post

    Corrections Made...any thing else????
    PS..gave you a min button.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width