...uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management
...table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and
...diharapkan saudara dapat mengkonversi UU dari UU tahun 1989 - 1945 menjadi .txt atau text. Misalkan dari pdf atau word, maka UU dalam bentuk pdf atau word itu dikonversi menjadi UU dalam bentuk .txt dan juga harus rapi. Setiap UU yang sudah diselesaikan atau dikonversi dalam bentuk .txt bernilai 1rb rupiah. Terimakasih. Proyek ini diharapkan selesai dalam
I want to create a scoreboard that can be changed when using PowerPoint on an iPad and on a MAC. Not sure if macros / VBA will be the best way. But it needs to be able to go up and down by hundreds.
I would like someone to write a macro for me that can read an JSON file from a directory and parse the data into a readable worksheet. I will attach a file as I have many of them on my computer.
I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [kirjaudu nähdäksesi URL:n](LookupValue, LookupRange
Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are
The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces [Back-end] The ability to create multiple...
We import csv files to TablePress from various AWS S3 buckets. We need somebody who can write a custom importer that will run as a cron to import all csv files (daily) from various S3 buckets (one per bucket).
HI, We need convert a XML database to CSV. In the database there are 1761 article. (see attachment) We need all the attributes in separate columns. (example in attachment) for each product code(SKU) XML in the zip see also attachment Who can help us out? Gr. Laurens
Boa tarde, O meu nome é Gil. Estou á procura de alguém que faça um ficheiro excel para controlo de produtos. As funções que gostava que tivesse, são: Tabela de produtos, inserção de produtos na tabela, remoção de produtos na tabela e consulta de produtos através de filtro.
...ability for a user to enter information within a CSV file, upload it, then have our application automatically create an online web form based on the info provided by the user (e.g. form field type, form field selections, etc.). Hence, instead of having to manually create an online form, they can upload the CSV file which contains all of the required info
Here is everything you need to understand in the video: [kirjaudu nähdäksesi URL:n] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [kirjaudu nähdäksesi URL:n] Let me know if you have questions, Thanks, Jai
1- Character Count Software from txt files: Report in csv file with fileName > CharacterCount > FileSize. 2- Save small size file (Cut-Paste) in diff folder with specific character count like upto 400 or 450. 3- software to be show progress in percentage/progress bar for approx 1 million txt files
Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.
I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month file to prepare for next month. Af...
I would like a VHDL code that reads 3 txt file and produces 3 txt file. The inputs text files produced by Matlab in binary. please see the attachment for the code I attempted to do but it not working, and text input files.
I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
I have got a shopify store. Our Suppliers have a data feed that is same on two suppliers and is changing on the third one. Also the data feed needs images alt to be checked. How do we update the inventory from our suppliers everyday. I have got all the categories and subcategories sorted according to the suppliers . Tasks that needs to be done 1) How to update inventory from our suppliers everyda...
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File
Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followe...
...– Outbound Standard Interface Files for Debit - Bank Branch Vendor - Customer - Account - VAT TRN Details - Transaction Input - VAT Outbound Above date to be exported in .TXT file with PIPE delimiter Above data to be exported based on configuration i.e. Daily, weekly Above data to be exported from VAT enabled [kirjaudu nähdäksesi URL:n] software only...
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Comments"...
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.
...need this done soon so please reach out if interested. Thank you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard
Advanced VBA needed in 24hrs
Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks
Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing
We need to convert an Excel file to a txt file. This Excel file will bring some data from an internal system that needs to be formatted into a txt file. After that, the txt file needs to be moved to a specific folder that will be accessed by FTP. All this process must be done automatically. The txt header must follow: - Date (dd/mm/yyyy) and time(hh:mm)
I would like to build a tool that will allow us to better manage our user lists and service Providers. Function: I would like an excel to hold the following data: List of all teams List of all users in those teams List of all service providers contracted with those teams and the budgets Contact details at service providers Email text The above data we need to be manually Changeable and updateab...