Search Results - VBForums

Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. MsOf10 Re: Excel 2010 - error message "Cannot run the macro "C:\Bookings\......"

    ThisWorkbook.Path-Property?

    without seeing the code it's just guesswork
  2. 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
    ...
  3. Replies
    24
    Views
    766

    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
  4. 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,...
  5. Replies
    21
    Views
    517

    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...
  6. Replies
    14
    Views
    731

    Re: LocalAlloc verus GlobalAlloc?

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

    by Zvoni
    Replies
    4
    Views
    196

    Re: Ping someone?

    Shell the ping to a textfile and read the textfile
  8. Replies
    2
    Views
    158

    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...
  9. 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*
  10. 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...
  11. Replies
    5
    Views
    238

    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...
  12. Replies
    5
    Views
    238

    Re: Another Question About INI Files

    The same with GetPrivateProfileString
  13. Replies
    5
    Views
    238

    Re: Another Question About INI Files

    Read the description for the GetPrivateProfileString-API again......
    .... or wait until Doogle finds this thread :D
  14. Re: How to add multiple rows in multiple locations in MSFLEXGRID

    Try




    yearDisplay.AddItem " ", (m_no + 1)
  15. Replies
    4
    Views
    184

    Re: get value in between phrase

    Just use the split-function twice
  16. Re: Assigning variables values from a limited pool

    Here you go: http://www.vbforums.com/showthread.php?690093-VB6-Lottery-Algorithm

    Your Call would be Call Lottery(6,6)
    To catch the results you just have to move the declaration of arrDest to...
  17. Re: How to add multiple rows in multiple locations in MSFLEXGRID

    Never worked with Flexgrid, but in Excel i'm doing such things always backwards.
    Meaning: I start with the last row
  18. Re: [RESOLVED] Application defined or object defined issue

    The Range-Object has a Sort-Method......
  19. Re: Assigning variables values from a limited pool

    It's the lottery-problem.
    i have a ready-to-use algorithm in the codebank here
  20. Replies
    7
    Views
    291

    Re: Similar repeating code and testing tools

    Wrong forum! *GROWL*
  21. Thread: randomize

    by Zvoni
    Replies
    3
    Views
    169

    Re: randomize

    In the codebank here is a code-snippet from me for the Lottery-Problem. just search for it
  22. Re: Need macro to Copy sent items to my computer desktop folder

    And i'm pretty sure by reading the documentation it's not a challenge at all.
    i don't have/use outlook, but i'm pretty sure there is an event "OnSend" or something, and i know there are the...
  23. Re: Need macro to Copy sent items to my computer desktop folder

    Since we're in the office-forum i'm suspecting Outlook
  24. Replies
    7
    Views
    291

    Re: Similar repeating code and testing tools

    This looks like .NET
    In that case: Wrong Forum!
  25. Re: "syntax error in where clause" - please help

    Correct, since 5 lines later he uses the Find-Method of the Recordset.

    But for what he wants to do, a proper SELECT with a correct WHERE-Clause would be better
  26. Re: No value given for one or more required parameters

    I see something else:


    First SELECT:
    SELECT transactionno,vehicleid,grossshiftdate,custname,prcname from transact

    Second Select (to go in Union with First Select)
    SELECT...
  27. Re: Getting the value of the last characters from a string

    Never seen the notation Bonnie uses, i'd guess Member 1 from the resulting array of the split.
    Member 0 should be everything left of the "="-character
  28. Replies
    11
    Views
    352

    Re: Read CD Directory and save to text file

    That's actually the main API from my post #4

    EDIT: you know, after reading so many queries like "list contents of drive/folder/directory" we could actually do a community-project, say write a...
  29. Replies
    11
    Views
    352

    Re: Read CD Directory and save to text file

    What i'm trying to say is, that i'm pretty sure that there is a similiar way to read the MFT of a CD/DVD, just not the way a MFT on a NTFS-Drive is read.
    The document in my link is a description of...
  30. Replies
    11
    Views
    352

    Re: Read CD Directory and save to text file

    During my research i found something called Path table for ISO9660
    http://www.ecma-international.org/publications/files/ECMA-ST/Ecma-119.pdf
  31. Replies
    9
    Views
    282

    Re: page wise record show database

    where moid='no'

    That one looks fishy to me.
    I'd expect something like:
    Query = "SELECT * FROM onlymoney where moid=" & no & " LIMIT 5,10"
  32. Replies
    16
    Views
    506

    Re: RecordSet Problem with exporting data

    Then the only explanation is: Either you don't have a table called "Funds" or you don't have a field in that table called "name"
  33. Replies
    11
    Views
    352

    Re: Read CD Directory and save to text file

    I have to contradict myself.
    There is a faster way.
    http://stackoverflow.com/questions/4203573/finding-a-set-of-file-names-quickly-on-ntfs-volumes-ideally-via-its-mft...
  34. Replies
    11
    Views
    352

    Re: Read CD Directory and save to text file

    API's
    SHBrowseForFolder to assign a starting folder
    FindFirstFile and its sisters to traverse the folders
    wouldn't know of anything faster
  35. Re: Application defined or object defined issue

    18-20 minutes?

    well. I'm coming back to my suggestion to use SELECT INTO and then in a second step do your cosmetic stuff
  36. Replies
    16
    Views
    506

    Re: RecordSet Problem with exporting data

    ReqSQL = "SELECT * FROM Funds WHERE Name='" & NameFund & "'"
  37. Re: Application defined or object defined issue

    Are you trying to edit that worksheet while at the same time it's filled up by your code?

    http://www.xtremevbtalk.com/showthread.php?t=184723
  38. Replies
    16
    Views
    506

    Re: RecordSet Problem with exporting data

    Then you're missing single quotes around namefound in ReqSQL
  39. Replies
    16
    Views
    506

    Re: RecordSet Problem with exporting data

    Is NameFund a textvalue or numerical?
  40. Replies
    6
    Views
    230

    Re: Output a UDT array to an external file

    Shouldn't that be



    Put #f, i, Pole(i)
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.