Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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

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.

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...

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...

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

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...

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

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. ??

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...

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

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

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...