Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorry i am a newbie (vba)

    I have a prob.

    Make a little prg in VBA with this characctreistic.

    Make a icon on a desktop and after that is clicked appear a form.

    In the form must present:

    In an variable insert in fixed mode the value 36.500
    1) line i insert the amount (in this format ###.###,## example 100,00)
    2) line init date (in this format gg/mm/yyyy)
    3) line and date (in this format gg/mm/yyyy)
    4) line a free insert numer 1 digit

    5) line a result

    In effect is a simple calculator of amount interessing

    The formulas to calculate this is:

    (difference from line 2 - line 1 result in number of day) * amount * the free digit
    all / (devide) for the fixed variable = insert the result line 5

    tks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorry i am a newbie (vba)

    Do you really mean VBA? VBA is the programming language in Microsoft Office programs such as Word, Excel etc. It cannot be used to make stand-alone programs. To create a stand-alone program you need a compiler, for example VB6, C++ or Delphi. Do you have VB6?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorry i am a newbie (vba)

    TKS, Hans
    But not is possible to compile directly in .exe.?
    I dont have a compiler and i dont have exerince in VBA.
    My idea (i know little VBA for Exel)...

    Make a wbook with a form with 5 line (with my suggestion) deposit it ion desktop and when this start after the click appear only the form to insert a data and mantain hide the excrel... is a good idea or not?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorry i am a newbie (vba)

    You can NOT create a .exe with the VBA in Word, Excel etc. You DO need a compiler for that.

    You can create a workbook with a userform that is opened automatically when the workbook is opened. You could even minimize Excel. The userform would be a standard VBA userform, such as you have in several of your workbooks, so you should be able to create it yourself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •