• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    True or False, Is It Possible To Convert An Excel Module To A Stand Alone App?

    I am not sure what you are trying to do, but there is an option of having the script simply open an excel workbook and call a macro stored inside it. This way you can distribute an excel file with all the macros inside and just have a script (or an app) run them. Keep in mind that excel opens...
  2. V

    True or False, Is It Possible To Convert An Excel Module To A Stand Alone App?

    Just to give you an example (albeit a useless one): Here is a VBA subroutine: <br /> Sub Test()<br /> With Application.ActiveSheet<br /> .Cells(1, 1).Value = 10<br /> .Cells(1, 2).Value = 20<br /> .Cells(1, 3).Value = "=sum(a1:b1)"<br /&#62...
  3. V

    True or False, Is It Possible To Convert An Excel Module To A Stand Alone App?

    Depends on what your code does and how much user input it requires, but the short answer is yes.
  4. V

    True or False, Is It Possible To Convert An Excel Module To A Stand Alone App?

    You have to declare an object such as: Set objXLApp = CreateObject("Excel.Application") then you can use with objXLApp 'code end with
  5. V

    True or False, Is It Possible To Convert An Excel Module To A Stand Alone App?

    Vbscript editors such as vbsedit can help you with converting the excel module into an executable file. There are some changes to the code that need to be made and error checking in vbscript is not as robust as in VBA but it's a n option.
  6. V

    pulling a rabbit out of a hat (or converting timestamp to a shift)

    Try this: =IF(MOD(A1,1)<VALUE("7:30"),3,IF(MOD(A1,1)<VALUE("15:30"),1,IF(MOD(A1,1)<VALUE("23:30"),2,3))) that assumes the time stamp is in A1
View older results
Back
Top