Vba code to open excel file from folder jobs
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
...experienced blog writer or team of writers to rewrite 4000 existing articles from a source website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free ...
I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process
I'm looking for a skilled professional to assist with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Id...
I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.
I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process
I'm seeking a detail-oriented freelancer for a project involving manual data entry from PDF files. The primary purpose of this task is to prepare the data for analysis, so accuracy and attention to detail are crucial. Key Responsibilities: - Manually entering mixed data (numerical and textual) from PDFs into a specified format or database - Ensuring the accuracy of the data entry to facilitate reliable data analysis Ideal Skills: - Proficiency in data entry - Strong attention to detail - Familiarity with handling mixed data types - Capability to work with PDF files Experience: - Prior experience in manual data entry is highly preferred - Experience in data analysis will be a plus I look forward to your bids!
I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.
...seeking a skilled blockchain developer to rebuild and set up a wallet scanner specifically for the Solana blockchain. The scanner’s primary purpose is to identify profitable wallets worth copying, based on reliable data metrics such as Profit and Loss (PnL), win rate, and performance over weekly/monthly timeframes. The current implementation is plagued by inaccurate or false data, resulting in wallets with near-zero balances being reported as highly profitable. Despite trying multiple APIs (Solana public API, GMGN API, and BirdEye API) and even scraping data from relevant websites, the results have been inconsistent and unreliable. This project requires a solution that not only filters out fake or non-credible wallets but also provides a robust mechanism...
I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process
...Short-Form Real Estate Video Editor (Fast Turnaround Needed!) ✨Offering pay for every edit completed✨ Are you a skilled short-form video editor who knows how to turn real estate talking head content into engaging videos under 60 seconds? Do you excel at delivering scroll-stopping edits quickly while maintaining quality? We’re looking for someone who specializes in short-form content that captures attention and drives engagement! What We’re Looking For: Expertise in editing short-form real estate talking head videos (less than 60 seconds) Strong knowledge of platform-specific trends (Instagram Reels, TikTok, YouTube Shorts) Ability to create dynamic captions, transitions, and hooks that capture viewers' attention in the first 3 seconds Efficie...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
I need assistance with uninstalling the McAfee product from our corporate Windows devices. These devices are managed through Intune. Ideal Skills and Experience: - Proficient in using Intune for device management - Experience with software uninstallation on corporate devices - Familiarity with McAfee product removal process - Knowledgeable in Windows operating system management
...experienced blog writer or team of writers to rewrite 4000 existing articles from a source website. The goal is to create 4000 entirely new, unique, and plagiarism-free articles for publication on our website. The rewritten content must maintain the original meaning and factual accuracy of the source material while sounding natural, engaging, and human-written. We want to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free ...
...you ready to bring your creativity, organization, and communication skills to the forefront? We’re looking for a dynamic Remote Real Estate Marketing, Outreach, & Transaction Coordinator to join our growing team. If you’re passionate about real estate, love connecting with people, and thrive on keeping deals moving smoothly, we want to hear from you! What You’ll Do As a vital part of our team, you’ll: Cold Call & Client Outreach Build genuine connections with property owners and motivated sellers through outbound calls. Use persuasive communication to uncover opportunities for real estate deals. Engage with past clients to collect testimonials and success stories that highlight our impact. Marketing Campa...
I need an arrest record removed from Google. It's currently affecting my online reputation. Ideal skills for this job include: - SEO and Google ranking knowledge - Experience with online reputation management - Understanding of privacy laws and regulations Please include your proposed strategy for this task in your bid.
I am seeking an experienced sales professional, specifically a senior-level candidate, to close sales for my consulting business. Your role will be critical in making a tangible difference in our growth. Ideal Skills: - Proven track record in sales closing - Extensive experience in consulting industry - Experience in recruitment - Exceptional communication and negotiation skills - Ability to understand and convey the value of our services - Committed to making a positive impact Required: - Be located in the Pacific Northwest - Be open to commission-based work Desired: - Mission-based (you want to make a difference)
I'm looking to build a website that facilitates file uploading and retrieval. The specific requirements are as follows: - The site should allow users to upload and retrieve various types of files, including documents, images, and videos. - Landing page with parallax scrolling. - Login functionality to help users to upload and retrieve files. - Website able to run photos/videos (built-in) - Robust security measures to protect users' files and personal information. - CMS access for admin to manage files, users & password in batch - Mobile responsiveness to cater to users on different devices. The ideal candidate for this project should have a strong background in web development from scratch (eg with...
...photoshoot. We are open to casual as well as traditional photos - whatever looks gorgeous. The shoot will take place in beautiful outdoor nature settings like parks, forests, or beaches. We live in Seattle area and wish to cover nearby locations that are popular for wedding/prewedding photoshoots. Key Requirements: - Experience in capturing natural and casual moments - Expertise in outdoor prewedding photography, particularly in nature settings - Ability to suggest suitable locations and times for optimal lighting and scenery - Proficiency in editing to enhance the natural beauty of the images This is an opportunity for a creative photographer to capture a love story in a serene and beautiful backdrop. Please include examples of similar work i...
I need a talented graphic designer to transform a written image into a classic style logo. Key components of the project: - The design should be classic in style, not overly modern or minimalist. - The logo needs to incorporate specific shapes and icons from the written image. - The color scheme of the logo should align with that of the written image. - The logo should also include a tagline that I will provide. Ideal Skills and Experience: - Strong background in graphic design, with a portfolio showcasing classic style logos. - Proficiency in using design software. - Excellent communication skills for discussing design elements and incorporating feedback. - Experience in logo design and brand identity development.
...command, including managers and supervisors. 3. Allowing supervisors and managers to see their respective employees by ID and name. 4. Ensuring that supervisors and managers are also listed as employees under the top officer. 5. Developing a system where each employee can see who their immediate superior is. I am open to suggestions regarding the top office table's content, but ideally, it would include names, roles, and departments. Ideal skills for this project include: - Advanced proficiency in Tableau, - Experience with creating hierarchical structures in data visualization, - Understanding of organizational data and employee relationships. Please note, relevant data for the top office table will need to be inferred or created as you see fit, as...
I'm seeking an Excel expert who can help me automate a project progress report using macros. The report will track task completion status. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Proficient in creating and implementing automation and macros - Previous experience with project tracking and reporting - Excellent attention to detail
I have a Xamarin code for iOS and Android apps, written in 2020. I have installed visual studio 2022 on my Mac. when i try to run the project, it is throwing errors as it is 2020 code. Need a developer who can fix the environment issues and generate iOS and Android app builds.
I am seeking a proficient freelancer with expertise in automating data entry tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minimal room for errors. Accuracy and speed are of the essence in...
I need a skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give i...
I need someone to sift through my text-based PDF records of SMS messages to locate and extract weekly pay information. This data will be used to generate pay tickets. Key Requirements: - Data extraction from PDF: You'll be looking for approximately 30 instances of weekly pay information within my text message history. - Data entry: The extracted information needs to be organized into a spreadsheet for easy access. - Specific spreadsheet columns: The spreadsheet will need specific columns for the date of payment and pay details (including hours, Gross, Net and other info). - Excel Skills: I do not need any complex formulas or calculations. Just basic data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel is a must....
I'm seeking a skilled professional to create a CNC file for my logo. The file will be used with a plastic CNC machine, specifically working with HDPE 2 ply material. The logo design needs to incorporate intricate patterns. Ideal Skills and Experience: - Proficiency in CNC file creation - Experience working with plastic CNC machines - Understanding of HDPE 2 ply material - Ability to design intricate patterns - Prior experience with logo design
...within two user-defined time ranges (start and end times adjustable to the second for each range). Price Entry Monitoring: Instead of placing OCO orders immediately, monitor the price until it is within 5 points of the entry point for each time range. Order Placement: Submit a stop order when the price is within 5 points of the high or low of the range for either session. Cancellation Logic: If an order is placed near either the high or low but remains unfilled, and the price moves to the opposite side where another order is placed and filled, immediately cancel the unfilled order from the initial side. Trade Management: Stop-Loss Monitoring: For the reverse trade, monitor when the price is 5 points away from the stop-loss level of the first trade. Con...
...developer to integrate a Telegram bot with Python code that will execute predefined terminal commands. The system should take messages which are broadcasted to the bot and execute the corresponding command. Key Requirements: - Python programming skills - Experience with Telegram bot development - Familiarity with terminal commands - Knowledge of MySQL for querying The primary goal of this project is to automate the execution of specific tasks via the Telegram bot. The user will interact with the system by sending MySQL queries, which the bot will interpret and respond to. The ideal freelancer for this project should be able to help me with the following: - Executing predefined commands - Using MySQL queries to trigger these commands - E...
...software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the outline and flow. Please DM me if this isn't clear - I would like each page to have the same attractive single-color background. The text colors described above are NOT the colors that I want to Question & Answer text. Those texts can be the same, but should look good with the background Additional Information...
I need two simple logos converted from Adobe Illustrator (AI) files for merchandise use. The logos don't have specific size requirements, so any size will work. 2 logos from files attached Ideal skills and experience for the job include: - Proficiency in Adobe Illustrator - Understanding of logo design for merchandise - Ability to create scalable designs without loss of quality
I'm looking for a quick Python script that can help me automate the reading and databasing of LAS file format headers using the LASIO library. The product tables should be exported in csv format. - Read a library of LAS files - Ingest and export CSV files The task is straightforward: there's no need for specific processing or data transformations on the files before exporting to CSV. The ideal freelancer for this job should have: - Proficiency in Python, particularly in file handling and CSV manipulation - Experience with automating tasks using Python scripts - Ability to deliver a simple and effective script in a short timeframe.
I'm in need of a modern, black and white DJ logo for 'DISCO DAVE'. The design should embody a contemporary style while being clean and easily recognizable. Ideal Skills: - Graphic Design - Logo Design - Illustrator Proficiency - Modern Design Aesthetics Please note that the design should solely utilize black and white, focusing on sharp contrasts and clean l...being clean and easily recognizable. Ideal Skills: - Graphic Design - Logo Design - Illustrator Proficiency - Modern Design Aesthetics Please note that the design should solely utilize black and white, focusing on sharp contrasts and clean lines, without incorporating any additional color palettes. The absence of specific elements in the design leaves room for creative interpretation, so I'm open t...
Please Sign Up or Login to see details.
I'm looking for a skilled CAD designer who can convert my 2D JPEG/PNG drawings into high-detail STL files for 3D printing. These files will be used to assemble a scale model of a locomotive headlight. Ideal Skills: - Proficient in CAD software - Experienced in creating STL files for 3D printing - Detail-oriented and able to replicate intricate designs - Familiar with converting 2D drawings into 3D models Requirements: - Use the provided JPEG/PNG drawings to create high-detail STL files - Ensure the files are suitable for 3D printing - Deliver the completed files in a timely manner I already have the 2D drawings, and they are available in JPEG/PNG format. I require high-detail STL files that accurately represent the intricacies of the locomotive headlight. The i...
I'm looking for a ...a number of significant events and issues. These pieces should be included to showcase the journalist's impact on the field. - Professional Background: A detailed account of the journalist's career trajectory will need to be included. I am open to the use of both specific and commonly available online sources. However, the freelancer may need to help identify reliable sources. The tone of the page should be neutral and objective, in line with Wikipedia's standards. Ideal skills and experience for this job include: - Strong understanding of Wikipedia's content guidelines - Excellent writing skills with a knack for creating engaging yet neutral content - Experience in journalism or media-related fields - Abil...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
I need an expert in Libre Office to assist in transferring files to PDF. Key Requirements: - Transfer of text documents from Libre Office to PDF - Dividing the master document into three separate files Ideal Skills: - Expertise in Libre Office - Proficient in creating and formatting PDFs - Attention to detail to ensure contents are accurately divided
I'm seeking an experienced professional who can integrate the Binance API into my React.js application. The exact details and functionalities required from the API can be discussed further, as I'm open to suggestions based on your expertise. the candidate should work on binance future trading api based on current ongoing project which has been done around 70 %. This project should be completed. if the freelancer dose not have the own binance account verified, don't bid. Thanks.
Project Description: We are seeking a skilled developer to create a freelance platform dedicated to all types of automotive services. The platform will allow businesses and individuals to list services like tire changes, car washes, repairs, detailing, and more, while giving customers an easy way to browse and book appointments. The initial version of the platform doesn’t need to be overly complex but should include: - A user-friendly design for service listing and booking. - A revenue system (e.g., commissions on bookings or fixed fees for service listings). Requirements: -Experience building service-oriented marketplaces or similar platforms. -Strong understanding of intuitive user interfaces and functional design. -Ability to scale th...
I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.
I'm seeking a professional who can assist me in retrieving data from several social media platforms. The platforms of interest are Telegram and WeChat, with additional data from WhatsApp. Information to be retrieved includes: - Chat records - Call logs - Pictures Ideal candidates for this project should have experience in data retrieval and have a strong understanding of the mentioned social media platforms. They should also be skilled in handling potentially sensitive information with the utmost confidentiality and discretion.
I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates
I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.
I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous work with travel-...
I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
Custom PHP Script for Batch Code Update in MySQL Database I am looking for an experienced PHP developer to create a simple and effective script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warnin...
