Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. deltaair

    N-TILE query without function

    Hello, I have a table with 3 fields id_person, id_event, value I need to divide all id_person(s) into deciles/quartiles. I am using ANSI SQL on Netezza and it does not support the Quartile/Ntile functions. How can I write a manual query to give me a list of id_persons, sorted in descending...
  2. deltaair

    Pivot table in SQL ?

    Hello, I have a table with 3 columns, where person_id is unique id. <person_id> <event_type> <number_events> 1. I need to transform this into a table with <person_id> <event_type1> <event_type2>.... <event_type-n> And under each column I need to fill the number_events for each event_type for...
  3. deltaair

    PIVOT TABLE in SQL

    Hello, I have a table with 3 columns, where person_id is unique id. <person_id> <event_type> <number_events> 1. I need to transform this into a table with <person_id> <event_type1> <event_type2>.... <event_type-n> And under each column I need to fill the number_events for each event_type for...
  4. deltaair

    Convert excel spreadsheet to flowchart

    I think we're on the right track. That is almost exactly as how we have it right now. However, we are having trouble connecting dynamic arrows because the arrows need to be optimized according to no. of blocks at each level. If there was a pre-defined tool or function in ms.office that could...
  5. deltaair

    Convert excel spreadsheet to flowchart

    I have an excel spreadsheet which has a 3 columns b.) From Process c.) Process Descriptions d.) To Process I need to conver this spreadsheet to a flowchart in excel or visio, or any other MS.OFFICE platform. If the above format is not possbile to be converted but you know of another way to...
  6. deltaair

    Setup email form

    This maybe a very elementary question, but I don't know how to set it up. I need to develop a form, so that people can fill it, submit it and it will populate values in a database. ( I can do this part). However, I need to put this form on the web, so people can click online and it can populate...
  7. deltaair

    Open with .exe application file

    This external application is say myApp.exe. This application itself has self-contained macros, which exist in the form of unicode text files. These text files have to be updated for certain dates. My macros read in these text files and update the dates for more current ones, so that these macros...
  8. deltaair

    File Read/Write Replace

    I tested the code given by Caution MP and I made the supporting functions and subs, however, I ran into the problem that I predicted: the string to be replaced, if found at the divide of two records, doesn't work. Anyway to make it cycle until all of the occurences of the string to be replaced...
  9. deltaair

    Open with .exe application file

    How can i convert my VB Excel code to a Batch Script ?
  10. deltaair

    Open with .exe application file

    How do I use a batch script. Where can I read more reference material on "Shell"... how do I use it, what is it. Thank you for your help.
  11. deltaair

    Open with .exe application file

    1.) In Excel VB Editor, is there a way to code a subroutine, to open an external .exe file. 2.) If the above is possible, the external .exe file is an internal company program with a text prompt like DOS (or UNIX), IS THERE A Way I can have the computer run a key combination like CTRL+X or...
  12. deltaair

    check if folder is present

    any way to code a subroutine to check if a folder is present or not. i know how to make the folder, but it doesn;t work if its already there...
  13. deltaair

    convert Excel VB code to .exe file

    so could i use excel to make it a scheduled task instead ?
  14. deltaair

    convert Excel VB code to .exe file

    I'm sorry but I'm still confused, is it that code written in Excel is VBA, and only VB Script can be converted to .exe? If so, then what do I need to convert my VBA EXCEL code to VB Script or a .exe file. Can i just write, compile a VB Script File in Excel itself or what else do I need. I...
  15. deltaair

    convert Excel VB code to .exe file

    I'm sorry but I'm new to this, I don't know where to look in the reference material you referred. Appreciate your help. Thank you
  16. deltaair

    convert Excel VB code to .exe file

    I have some code that I wrote in Excel 2003, which doesn't really involve Excel, I was wondering if there's a way I can convert this code into a .exe application file, and make that .exe a scheduled task or something like that. ??
  17. deltaair

    Convert code to .exe file

    Its basically reading/ finding replacing text in text files and copying / deleting them from folders etc. Here's what the code looks like Const pathname = "C:......." Const filename = "fname.txt" Public Function replaceAll(pathname, filename, String1, String2) As String..... This replaces...
  18. deltaair

    Convert code to .exe file

    Thanks for replying, I have some code in excel which I want to make a standalone .exe program because it doesn't need excel really. i don;t know if thats vb or vba. Please let me know how i can do this. Thanks
  19. deltaair

    Convert code to .exe file

    How can i convert some VB code to a standalone .exe program.
  20. deltaair

    File Read/Write Replace

    Wow, Thank you so much! Just to make sure - the file is around 3KB (in windows explorer atleast). Also, I understand that this would replace the stuff line by line, however, the text i need to replace is not really linear, so I could potentially run into the problem that the date, say 25DEC...

Part and Inventory Search

Back
Top