Need little help with coding In Office 2010 I want from Excel make query in Access. The accd is already open. In Excel I code: Public Function GetCollOntvInBoho(Dosnr) As Collection Dim AccessApp As Object, SqlBoho As String, rsBoho As Object, Coll As New Collection Set AccessApp = GetObject("X:[se connecter pour voir l'URL]").Application If Not Ac...
I need you to develop some software for me. I would like this software to be developed for Mac using .NET. Coding Challenge Overview The coding challenge is to implement the client portion of a custom TCPIP binary protocol. The server is already implemented and publicly hosted. A framework user interface has already been created and you can use this
The original data set is an excel file with information about 117 countries over time (1970-2013) and 40 variables per country and year. Each country's information is within one tab of the excel spreadsheet, ordered by year and then columns for each variable. I need this in one large table in panel data format (column 1: country; column 2: year; column
...for the candidate to start the work ✓ This would be a basic training; the candidate is expected to quickly start and delivery as the job is straightforward and requires no coding or programming knowledge ✓ Required licenses for the products that must be installed on the candidate laptop Candidate should have: ✓ Very good understanding of e-commerce
I have an excel file which have various headers where i have included time stamp in the file which allows me to filter the entries on the basis of the date on which they have been entered in excel file. I want to create an xml file, from the same using vba coding on a prescribed format so that it can be imported in a software.
Project required a visual basic programmed excel form. code is almost finished but stuck needing expertise level. What's required is for the sheet not to save unless all shaded boxes are fully complete. I think coding for it to read all shaded boxes with the index color of the cell so if that or any of the shaded boxes are not complete it wont let it
Hi There, I need someone to enhance exis...I want this to be formatted into a grid (table) where i can export the report to excel. 4) All information must be saved to a SQL DB. Should you be interested, please make contact so we can proceed further. I have attached the API Doc already, remember that all coding was completed and needs to be enhanced,
Hello Freelancers! So this is what I am looking at doing. I have a simple project brief written up (attached in excel) but I am looking for somebody to take my brief and: 1) Do the wireframing; 2) Create any infographics needed; 3) Design the final layout of the one-page dashboard and return it to me in .pds or similiar. The dashboard will be one
• Coding development in VBA (Excel) ((Procedures, Functions & Classes) and advanced Excel functions.
• Should have good knowledge of SQL(Procedures, joins, data manipulation & Functions)
• Create/write VBA programs to automatically update Excel workbooks
• Modifications, Error handling, Debugging in VBA
• Automation by
Hi H John D., I am not as VBA-competent as I would wish, and I want you to engage you to help me understand what VBA coding might be possible to move entries in various Excel worksheets' fields to a single database and allowing for updates of data in subsequent entries into those worksheet fields (essentially allowing for an audit trail, which would
...with to develop an automated spreadsheet: I’m a retired horse racing enthusiast with some coding experience (very limited) and reasonable excel skills and want to automate a daily task. 1. Project to automate excel spreadsheet initially using Visual Basic and excel macros to • Scrape list from first horse racing web site for first column of workbook
I am currently working on an excel app that pulls data from Quickbooks and I need to reconcile inventory and put it back into Quickbooks to update a couple of flags. I need the following with experience: 1. VB coding Maco coding for excel/work with the existing VB code. 2. I need to flag some of the inventory / SN for updates a. SN fix b. SN Changed
...information systems. I have chosen to use excel for this but I need help coding the excel sheets, to automate some aspects of it. For example, if I write "240" in a cell I want this information to jump to another sheet. This is just one example of what I want to do. If you have good experience with excel and coding this is for you. Kind Regards
I'm in the processing of converting several excel workbooks that have extensive VBA coding into Visual Studio with C#. I'd like to start with two `Forms` to see how it goes and then decide on the best course of action from there. The requirement is to have the programmer setup a VSTO project, then convert the VBA user forms into C# windows forms
Looking for an experienced website developer for a budget consulting service. The primary objective is ...spreadsheet in a way users can understand. The goal is to have a user interface that is simple and easy to use; or in other words, easy on the eyes. Must be experienced in coding and excel as well as an understanding in general finance principals.
An Excel spreadsheet on an iphone is being further developed and assistance with coding for two columns is requested. IMPORTANT: Due to the limitations of Excel running on an Apple Iphone environment no VBA code can be used. The two columns to be coded draw on the surrounding columns to decide what data populates each cell.
...they are unable to make the earlier data available in csv format, but I need a substantial amount of it for analysis purposes. There is a massive amount of data each day (Excel columns A - PJ, and up to around 600 rows). I can provide a link to a sample xlsx file (which is how the data appears online) for you to see what is involved, and I can also
Hi, I need to have a vba Excel program built today or tomorrow. I understand that it is short notice however I am willing to pay more to get it done right. Please get back to me so we can discuss the scope of the project. I have good idea of how it should be but I don't have enough coding knowledge to make it work. Thanks, Markus
coding in android studio for protected Excel sheet)
...[se connecter pour voir l'URL] [se connecter pour voir l'URL] You can get some coding help from the below mentioned [se connecter pour voir l'URL] library as well [se connecter pour voir l'URL] 4. List of widgets, Icons and code links In this excel sheet, I have provided you all the code links for widgets and icons. You don’t have to write codes
...points per project with 9. data forms that will be submitted online though a simple fillable forms (obviously I will want to allow clients to populate the fillable forms via an Excel import into the form, and 8. Various dashboards built in Microsoft BI for staff and managers to track their assigned work and next steps for each of their project tasks. This
...clients to populate the fillable forms via an Excel import into the form. Also I will be providing customizables dashboards built in Microsoft BI for staff and managers to track their assigned work and next steps for each of their project tasks. I can send you a simple 6 web page that I have designed in Excel as the portal. From it you can gain some insight
Need a python program to parse XBRL financial statement to excel Requirement: freelancer who has knowledge of XBRL financial report file and also has strong background on coding with python (parsing file skill) Please indicate if you know XBRL in the proposal
I need to import data from multiple Excel spreadsheets (I've started this already but I need some error coding built around this & to tidy it up) into Access. It is informations on client portfolio holdings. Then I need to create reports based on this data (summed, percentages, etc). Also need to have a process for if new investment isn't already recognised
...points per project with 9. data forms that will be submitted online though a simple fillable forms (obviously I will want to allow clients to populate the fillable forms via an Excel import into the form, and 8. Various dashboards built in Microsoft BI for staff and managers to track their assigned work and next steps for each of their project tasks.
...a Dream Opportunity — and dream company. We’re one-year-old and growing, and we’re looking for a second developer to join our team of 12. If you are someone who… - Wants to excel in your career and take pride in active and stimulating work - Is looking for a shot to prove yourself - Gets excited at the prospect of learning a tremendous amount, with fast-paced
I have an HTML coding and i want to create a Macros for the code so that it can auto fill from an excel spreadsheet. There are 43 sections in the excel source document that will need to fill into the word/html document. All i need you to do is write the basic to auto fill the bits from excel (they will be marked in red for you on a word document so
This will be a project with iterations to not make it too complicated in the ...A test dataset will be given but the solution needs to be flexible for a new dataset. I've already tried in Excel but the dataset is too big and the result is exponential. The data most be stored in a MSSQL database and the preferred coding language should be Java or C#.
Im working on a project that has a lot of excel calcualtions , sheets and formulas. I need to automate the process to make it a little more user friendly. I have some basic knowledge of VBA but am havign trouble figuring out the best way to streamline my project.
Hello everyone! The g...calculate the correlation between different time series and create a table with the results. In the excel file attached you will find the input DataBase, how the correlation is calculated and the format of the result table. Please feel free to use the coding language that you would prefer. Thank you for participating!
...It’s a survey research contains both qualitative and quantitative data. Just only descriptive statistics and qualitative by thematic coding. I am unable to report all these information. I just have raw results in excel and PDF. If you are willing to do please let me know in ASAP....
... WEB DESIGN Build simple content pages and landing pages with wordpress plugins, X-Theme and Cornerstone page builder (No coding skills required!) Coordinate with web developer on technical implementation that require coding OFF-SITE SEO / LINK BUILDING Create content marketing plan Propose a link building plan and execute it Distribute content on
...It can access external excel file into unity3d run-time (built / published APPs , not only access in editor) . All Excle format (.xlxs ,.xls , CSV.) are necessary. [se connecter pour voir l'URL] plugin maybe selling on unity3d Asset store. So that , license is legal, not GPL. Don't use any GPL or not using illegal licensing package. 3. Please coding by C-sharp languag...
Hi, I'm looking to find someone who can help me on the coding of an Excel VBA Multithread web scraping project involving multiple URL's, each containing multiple tables. Here's a link to the type of URL's used: [se connecter pour voir l'URL] The full workbook will need
Hello, I have a CRM Template that i have designed in Excel. I need work done to it to make it work the way i want it too. There may be some coding involved. Please message me for details. Thank you
This project will require VBA Excel coding. The attached file consists of the following tabs: Raw Data Name List Pivot Table Email Template The macro will: 1- go to the name list 2- filter the pivot by the name 3- copy the filtered pivot 4- open an email 5- include the email template 6- update the name in the email 7- paste in the
I have an Excel document that auto-sorts my 'Date Due (NLT)' column which is exactly what I needed. However, I've learned that I cannot protect the worksheet without losing the auto-sort capability and I need to protect every column except my 'Last Completed' column. My thought was to use vlookups and another worksheet that I can simply hide from
This project needs to be finished as a matter of urgency. It is currently half finished with a number of items that need finalising. This project...hours based on the projected occupancy of an accommodation camp. It is partially set up but needs to be finished. Also, it needs to work on tablets using excel without throwing errors from the coding.
I have a template for my graphics 1920x1080. It's for a Event Schedule for a hotel that get's updated everyday in a hotel. I want them to be able to have an excel form or some of some sort, that they update each day with that day's info which code will pull info from and display on desired screen. I use BrightSign media players and they're software
...be required to start on the 1st row in excel and pull/copy relevant data (price, description etc) and paste to relevant box on donedeal and then open a folder and select first 1st picture to upload on donedeal then move to next row on excel and 2nd picture etc. I see a guy write one before that copy from excel and move onto next row each time and copy