Search Results - VBForums

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    6
    Views
    197

    Re: Data Type Conversion Error

    Second reply --> http://objectmix.com/basic-visual/155084-mshflexgrid-error-13-a.html
  2. Re: Using VBA to find and move data from one sheet to another

    excerpt from his code


    *snip*

    For J = 0 To UBound(strArray)
    Found = Found Or Not (rngCells.Find(strArray(J)) Is Nothing)
    Next J
    *snip*
  3. Re: Using VBA to find and move data from one sheet to another

    Loop backwards through sheet1 (For i=123456 to 2 step-1)
    Keep a counting variable J (or x or whatever) you increase +1 for everytime you find your criteria in sheet1 and use this variable as the...
  4. Re: Need help for barcode reader to have cursor jump to next row

    I assume that the OP scans directly into a cell, so he can still do it manually if the scanner/barcode itself doesn't support CR



    Private Sub Worksheet_Change(ByVal Target As Range)

    ...
  5. Replies
    6
    Views
    197

    Re: Data Type Conversion Error

    Don't forget that a Date can be represented by a Long-Type, a DateTime by a Double-Type (the Time being represented by the part after the decimal-separator), so i agree with Phill: Never compare...
  6. Replies
    3
    Views
    103

    Re: Help with using Array and/or Loop

    If the Values to be assigned (depending on the Index) are constant, an approach might be to use an INI-File and/or database (db could even be a small textfile with UDT's)

    Something like:


    ...
  7. Replies
    51
    Views
    779

    Re: Find file in each Drive and Sub Folder

    Errr... nevermind, that i still have to see how you can delete a file from a CD/DVD (and don't start arguing with "rewritable" CD/DVD), i highly, highly recommend against doing anything with...
  8. Re: VBA swaps month and day pre the 13th day of the month

    You do realize, that you use the variable "Data" to build your Save-FileName, and that Data gets its value from range("F2")?
    What's the Value in F2?
  9. Re: Listview control help: Header and selected line color

    For the headers: No Idea. Probably to do with systemcolors and/or color-themes
    For the selected line: if i remember correctly, there are several color-properties for the ListView. I'd check out some...
  10. Replies
    3
    Views
    201

    Re: Add each list view item into string array

    This should work



    Sub Something()
    Dim MyArray() As String

    ReDim MyArray(1 To lvF.ListItems.Count)

    For i = 1 To lvF.ListItems.Count
  11. Replies
    9
    Views
    189

    MsOf10 Re: Reference all cells in a column

    Exactly my thoughts!
  12. Replies
    9
    Views
    189

    MsOf10 Re: Reference all cells in a column

    Well, since Target is a Range-object, i would have expected a Is-Nothing-Expression, since IsEmpty refers to numeric or string-values



    EDIT: Or did i just fell for the Trap with the...
  13. Re: hide Excel instance and show only the userform

    Don't forget if you have code running which crossreferences another workbook like


    ActiveSheet.Cells(2,7)=Workbooks(2).sheets(1).Cells(5,9)


    That's a pre-programmed timebomb
  14. Replies
    9
    Views
    189

    MsOf10 Re: Reference all cells in a column

    errr..... am i supposed to understand this line?


    If IsEmpty(Target) Then Exit Sub
  15. Replies
    9
    Views
    258

    Re: Disable Ctrl-Tab in MDI child forms

    What's wrong with Max's suggestion in Post #7?

    If everything else doesn't work, i'd rather do the subclassing-approach than starting some weird magic with hidden picture-boxes

    EDIT: You'd have...
  16. Re: Run Time error -624820215 (dac20009)

    Why not use an OERN right before the loop, with an On Error Goto 0 after the loop?
    He could even check inside the loop for the error and count the failed extraction attempts, like
    "18 Items...
  17. Re: Problem : Generating Unique Number (too slow)

    I think your problem's in the datatype, since you're using MAX on a Textfield (think sorting by string)
    But i'm not sure about it. It's been over 10 years I've done anything serious with Access
  18. Replies
    6
    Views
    216

    Re: Changing Array Index Numbers

    Sounds like a chess game.
    Turning a chessboard around you get the same board (Background) again (White square in upper left corner), but now the black pieces are at the bottom instead on the top.
    ...
  19. Replies
    2
    Views
    6,394

    Re: How do I use SendMessage and GetMessage?

    I'd rather subclass the windows-procedure on the receiving end with a unique message-header sent by the sender (e.g. WM_Custom or something) with the pertinent data sent in lparam or wparam.
    In that...
  20. Re: Upload to FTP-Server using the wininet-InternetFunctions

    I don't have any access to other FTP-sites.

    Could someone of you, who has an FTP-Server, make me an account, and PM me the Login-data?

    EDIT: I tried to upload the file via a Web-FTP-Provider...
  21. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Nope.

    Getting the file back is an empty file

    I just called the FTP-operator.
    They had an update last week on monday (the day my code started to misbehave!), but according to him, the update...
  22. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Something else:

    I just tried to upload the file using the ftp.exe commandline-program

    Strange thing:
    after entering put c:\temp\myfile.xml (which is 6KB)
    200 PORT command successful
    150...
  23. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Very curious.

    I tried pete's suggestion with the Shell-Object, and i got the following phenomenon:

    I have a Windows-Explorer open connected to the Folder on the FTP-Server (for watching in...
  24. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Nice, pete.

    didn't think on that. Will try on monday. In germany is holiday tomorrow, and i took off friday, so next i'll be able to test it will be coming monday.


    will report on monday if it...
  25. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Hi Shaman,

    First off: thx for taking time to think about my problem.

    No updates on my machine for the last 2-3 months, so nothing there.

    Yes, the bat is an idea, but i would have to figure...
  26. Re: Upload to FTP-Server using the wininet-InternetFunctions

    Good idea with trying an old file, but has the same result.
    Empty file with zero bytes.

    My xml starts like this



    <?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>
    <!DOCTYPE...
  27. [RESOLVED] Upload to FTP-Server using the wininet-InternetFunctions

    Hiho,

    I'm using the Internet-Functions of wininet.dll (InternetOpen, FtpPutFile etc.)

    Until last week it worked without problems.

    Now i got the following Problem:

    My Code creates a...
  28. MsOf10 Re: Excel 2010 - error message "Cannot run the macro "C:\Bookings\......"

    ThisWorkbook.Path-Property?

    without seeing the code it's just guesswork
  29. MsOf10 Re: Excel - Ignore empty cells/rows when using XML-Export

    That's the complete Function:


    Sub GenerateXML(Directory As String, File As String)
    Dim XML_str As String


    ActiveWorkbook.XmlMaps("CarloAuftragIn").ExportXml data:=XML_str
    ...
  30. Replies
    24
    Views
    1,699

    Re: How do I use a Listbox in a BAS module

    Recommending Chapter 4 of "Hardcore Visual Basic"
    http://vb.mvps.org/hardcore/html/collectingobjects.htm
  31. MsOf10 Excel - Ignore empty cells/rows when using XML-Export

    Hiho,

    issue: User uses an Excel-Sheet filling out pertinent data for a freight-carrier order
    There is data only to be filled once (Sender, receiver etc.)
    and repeating data (Positions 1 to 20,...
  32. Replies
    22
    Views
    1,142

    Re: Alarm for last sunday of month

    Looks like some Backup-thingy
    Drive D --> January
    Drive E --> February
    .
    .
    Drive O --> December

    Meaning: Right now is Mid-March. His Drive for March is Drive F.
    So, on the last Sunday in...
  33. Replies
    14
    Views
    1,372

    Re: LocalAlloc verus GlobalAlloc?

    Maybe something like this?
    http://msdn.microsoft.com/en-us/library/windows/desktop/aa366551%28v=vs.85%29.aspx
  34. Thread: Ping someone?

    by Zvoni
    Replies
    4
    Views
    329

    Re: Ping someone?

    Shell the ping to a textfile and read the textfile
  35. Replies
    2
    Views
    258

    Re: How to extract parts of a text string

    So if i understood you correctly you're looking for a 4-character long partial string, which is in the format e.g. a4b2 or any combination of it within the limits you said (a-h, 1-8)

    my first...
  36. Re: Main form not visible means it's not available when Alt/Tabbing

    http://www.vbforums.com/showthread.php?256662-Why-is-my-program-not-showing-in-the-taskbar-*RESOLVED*
  37. Re: Checking for file existence with long file names

    Shot in the dark: He's searching for files without providing the full path to the file, meaning he only looks for the filename without the path.

    First rule for file-processing: The path to a file...
  38. Replies
    5
    Views
    357

    Re: Another Question About INI Files

    You don't have to do any Do-Loop with INI-files.
    Use GetPrivateProfileString with the section you're looking for, but with the second argument empty.
    the returnvalue has all keys assigned to this...
  39. Replies
    5
    Views
    357

    Re: Another Question About INI Files

    The same with GetPrivateProfileString
  40. Replies
    5
    Views
    357

    Re: Another Question About INI Files

    Read the description for the GetPrivateProfileString-API again......
    .... or wait until Doogle finds this thread :D
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.