Find Jobs
Hire Freelancers

Write some Software

£10-15 GBP / hour

종료됨
게시됨 9년 이상 전

£10-15 GBP / hour

I have a database for which I require a number of tools creating. I have written a number of PowerShell scripts that I have written to pull relevant information from my database, but as most of this information is ending up in an Excel spreadsheet it would be nice to migrate my tasks into macros and have the information automatically populate my workbook. Task 1: After the user specifies a path to a project\database the macro will write three strings into a particular file ([login to view URL]) that exists in multiple folders i.e. "c:\...\WINDOW\folder1\[login to view URL]", "c:\...\WINDOW\folder2\[login to view URL]". The macro will then read information from each of these files to polpulate three columns in a table. Also information will be read from "c:\...\WINDOW\[login to view URL]", "c:\...\WINDOW\[login to view URL]". Task 2: This macro will read one aspect of the three pieces of information being read in task 1 from the '[login to view URL]' files, to keep one column up to date on demand. Task 3: The first macro would have read folder names contained in "c:\...\WINDOW\..." folder1, folder2 etc. into column one. There will be a fifth column where the user can specify an identifier, one of three possibilities, to each folder name in column one. Based on this identifier I need a third macro to set the file attribute of a number of files relating to this folder to 'read-only' and reflect this read-only status in column six. This macro could be a toggle, so that if the file attribute is change back on forth, checking and unchecking read-only, on successive clicks of a button. Task 4: There will be two other copies of this database in use in two other locations. If the user can specify two separate paths to two other projects, for all of the folders in "c:\...\WINDOW\..." that exist in the other projects say compare and say whether the files are "same" or "different". I do this in PowerShell comparing hash values. I'm not sure what is possible with a macro. Moreover if there are additional files in "c:\...\WINDOW\...", get and display the file names on a second sheet. I could do this with a little time, but I want to migrate the functionality of my PowerShell scripts into an Excel workbook with Macros so I have amore sophisticated singular tool. This project although for work, will come from my personal expenditure, but I'm confident it will be a quick a simple task for more experienced readers... Hopefully so, as I'm looking for someone to complete the work within a number of days. I look forward to discussing this job with interested readers. Thank you!
프로젝트 ID: 7187633

프로젝트 정보

12 제안서
원격근무 프로젝트
활동 중 9년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
12 이 프로젝트에 프리랜서들의 평균 입찰은 £15 GBP입니다./시간
사용자 아바타
A proposal has not yet been provided
£38 GBP 1일에
4.9 (260 건의 리뷰)
7.7
7.7
사용자 아바타
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
£14 GBP 8일에
4.9 (233 건의 리뷰)
6.9
6.9
사용자 아바타
Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VBA and Powershell Script I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
£13 GBP 20일에
4.9 (62 건의 리뷰)
5.6
5.6
사용자 아바타
Hi, Thanks for providing the additional information. Please share some supporting files if possible. Also I am assume when you say within this week, you are ok to have it before your start of day on Monday (this way I can even utilize the week end). I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
£15 GBP 5일에
4.9 (72 건의 리뷰)
5.6
5.6
사용자 아바타
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
£13 GBP 13일에
5.0 (57 건의 리뷰)
4.8
4.8
사용자 아바타
Hi, Can you please provide some samples of edf and xalm files? Also are you going to provide the existing Powershell scrips in order to make the job easier? Thank you very much and looking for your answer.
£12 GBP 10일에
5.0 (27 건의 리뷰)
4.7
4.7
사용자 아바타
I have worked extensively on Excel macros. The path files for other locations can be stored in a hidden sheet in the excel sheet and can be accessed using the code to check whether the files are similar or different. We can provide a radio button in the excel sheet which we can toggle in the macro. I am available in Skype for further discussion.
£11 GBP 15일에
4.8 (5 건의 리뷰)
2.9
2.9
사용자 아바타
I am a freelance Advanced excel teacher having expert level knowledge in excel and also write my own vb scripts & macros to automate excel. Hence i can execute deliver the job to you quickly.
£11 GBP 10일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED KINGDOM)
Runcorn, United Kingdom
5.0
1
2월 22, 2015부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.