...column values as first. psc_name result should come second with the 2 columns concatenation. 2. query should work irrespective of no stop words. Query is working fine in some cases, but its not working some scenarious. Thats need to fix Here is the Query : SELECT refpsc.* FROM iae_reference.ref_product_service_code refpsc WHERE 1=1 AND refpsc.active_ind='Y'
I have an already functioning VBA-code, which hast to be modified to fit an other case. A new variable hast to be added, which also affects already existing variables. The VBA-skills you need do not have to be very advanced, but you need enough experience in programming because understanding the problem is pretty hard. You also would have to work with
We are looking for a developer who works with Microsoft Office and perhaps with VBA or some kind of artificial intelligence approach to develop a program or Office application that summarizes tabular data. We will supply the language and the program needs to simply "read" the table and summarize the results of multiple choice questions and of tables
I have a calculation tool at hand whose macro is currently written in OpenOffice Basic. I need this macro rewritten in Excel VBA. The code is approximately 600 lines, but not complicated. If the programmer knows both OpenOffice Basic Syntax and Visual basic, the conversion should not be too time consuming.
we need such code that will play against a real player and will always win. the game is about: 1- there must be maximum 200 numbers and minimum of 2 (it must be randomly generated by code) 2-each number must be between 1 and 100 (randomly generated) 3-there must be 2 buttons (start, play) gameplay: player clicks start button. numbers are generated randomly everytime when a player presses the ...
...soll ein VBA Code geschrieben werden, welcher von Java aus gestartet werden kann und in einer Excel Datei enthalten ist. Das Programm soll auslösen, dass die, in der Excel-Datei enthaltenen Parameter (Informationen aus einem oder mehrerer Objekte) als Serienbriefverknüpfung in eine Word-Datei-Vorlage integriert werden. Die Excel- als auch Word-Datei sollen
****german speaking freelancers only******* Hallo, habe ein Excel Worksheet mit Makros über Projekteingabe und verschiedenen Darstellungen und Berechnungen. Soweit funktioniert alles. Im Moment kann ich aber nur 1 Eingabe pro Projekt eingeben, das Ziel wäre, dass ich per Buttons etwa 20 Eingaben pro Projekt machen kann. Am Besten mit einem Eingabepopup Formular. Bevorzuge einfache L&o...
...of stock symbols and i need a makro/vba that could scrap the following information from this website ->[url removed, login to view] whereas "COST" in the url coresponds to the stock symbol that i have in excel IV Pct Rank: Prev. Close: Equity: Sector: Industry: i can have a macro/vba that could scrap that data in my excel
I need two VBA macros for the attached excel file. Background information (the following is already created with formulas and conditional formatting): - The user selects the parameters that he would like to analyze in the x/y-axes selector in sheet "Data input" - Upon selection, the columns for his data input appear in orange in the same sheet
Hi we are looking to automate data entry to our company dashboard. We are food tech startup and we need to upload a lot of cooking related videos to our servers. We have a simple web based dashboard to upload local videos. We need to capture the mouse movements and automate the process to a point where it seems that a person is sitting in front of the screen and doing it herself. There will be ...
Looking for expert system engineer who can consult and giv solution how to fix on slow query. our project is about ecommerce system and handle multi-product what we found problem is - search product - import product via CSV (which has many process behind) we want fast speed and good approach. we usign laravel backend MySQL DB You can setup
Hi, good day ! Thanks for viewing my project. This VBA macro is work on Excel2010 and later. Details is as follows. [VBA Macro Overview] 1. Input source data is [url removed, login to view](this is sample input file) which includes user’s results. From A1 to D2 is question ID, and the following rows is user’s answer. 2. Final output data is result_data
I have txt log files with data. I need to parse data and seperate it into two files. With the data that is seperated i need to seperate it again and then query my database to determine which files do not exist to add data not already there.