Vba data extract vbaงาน
...expert who can help me extract all the email lists that have ever subscribed to my website's newsletter. Here's a brief overview of what I'm looking for: - **Data Extraction**: I'm looking for a full database extraction - including names, email addresses, subscription dates and any engagement metrics, if available. - **Data Compilation**: I would prefer to receive the compiled list in a Google Sheets document. **Ideal Skills and Experience:** - Proficiency in WordPress and email list management. - Previous experience in data extraction and compilation. - Strong attention to detail and ability to ensure data accuracy. - Excellent communication skills to keep me updated on the progress. Please note that I'm not looking to ap...
I'm looking for a skilled individual who can help me scrape data from a dead mobile app (has both ios and android versions). The database of the app is of particular interest, however, I am not sure of the specifics such as the Database Management System (DBMS) it uses. Key Points: - Extracting data from the database of a defunct mobile app - Unspecified Database Management System (DBMS) - will require exploration and identification Ideal Skills and Experience: - Proficiency in data scraping and extraction - Strong background in database management and familiar with multiple DBMS - Resourcefulness and ability to work with minimal information Please get in touch if you're confident in your abilities to handle this task.
I'm seeking a skilled professional to develo...specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can b...
...need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimi...
...images of menus, wine bottle labels, and food items, expertise in image processing techniques will be necessary to extract relevant information from these images. Familiarity with Conversational AI: Experience in building conversational AI agents or chatbots will be crucial for implementing the virtual Wine Advisor's conversational interface on the Shopify website. Understanding of Integration: The developer should be able to integrate the AI solution seamlessly into Shopify websites, ensuring smooth interaction with users. Ability to Work with APIs: Given the need to access and consume a wine knowledge library, proficiency in working with APIs to fetch and utilize external data sources is required. Strong Communication Skills: Effective communication skills are e...
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication ski...
I am looking for a freelancer who can extract specific data from a Swedish business directory using Python. Main URL: Key Objectives: - Extract company names, contact information (phone/email), and business numbers from the directory. Ideal Candidate: - Proficient in web scraping techniques - Strong command of Python - Previous experience with similar projects will be considered a plus. Please reach out if you have the necessary expertise.
...delivered as an executable(.exe) file that can be installed on multiple computers. There should be an on/off option: 1. Check Current Microsoft Edge Version: • The program will first determine the current version of Microsoft Edge installed on the user's system. 2. Download Correct Version of Microsoft Edge WebDriver to match with Microsoft Edge version: 3. Extract WebDriver and Rename: • Once the WebDriver is downloaded, the program will extract the msedgedriver file from the downloaded ZIP archive. • It will then rename the extracted msedgedriver file to edgedriver. 4. Update Local Directory: • The program will save the renamed edgedriver file to a specified location on the user's local computer: "C:Users[my computer]AppDataLoca...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
...professional to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) Authentication is done through twitter, it has to be done manually to access the marketplace Deliverables: - Format: Script that I can run to export the required data in a CSV
As a start, we need someone to continue an existing data scraping project, coupled with Artificial Intelligence for one of Brazil's largest legal platforms, "JusBrasil." The primary task is to effectively scrape and identify case descriptions that deal with our specialty: immigration cases, specifically focusing on citizenship and international law cases. Project Scope and Expectations: - Enhance the existing data scraper to efficiently extract case descriptions from JusBrasil - Implement AI algorithms to accurately determine the relevancy of these cases to our requirements - Leverage keywords such as 'citizenship' and 'international law' to highlight the cases we focus on Skills and Experience Required: - Proficient in data...
I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to preserve original formatting in Excel - Excellent English language understanding and communication
I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.
...Handling: Develop a system to receive HTTP POST requests containing specific data. Extract relevant details from the POST request body to initiate alert notifications. Azure Alert Integration: Integrate with Azure Monitoring to create alert rules based on the received data. Configure alert thresholds and conditions according to project requirements. Voice Call Notification Action: Implement a voice call notification action group within Azure. Configure the system to trigger voice calls as part of alert notifications. Message Playback: Capture the body details from the HTTP POST request. Play back these details during the voice call notification. User Interface (Optional): Develop a user-friendly interface to submit data for alert notifications. Provide fe...
**Purpose:** To collect data (product information, stock status, prices, etc.) in the B2B programs of 8 different suppliers. Developing software that can instantly capture data and automatically integrate this data with the user's own sales system. - **Main Features:** - Ability to securely log in to each supplier's B2B system. - Ability to instantly capture and process data. - Conversion and integration of the captured data into a format suitable for the user's system. 1. **Backend Development:** Required for system integration and data processing. 2. **Data Scraping/Web Scraping:** It is important to extract data from suppliers' B2B programs. 3. **API Development/Integration:** To securely integrate with s...
I'm urgently looking for a skilled Python developer to assist me with a project involving data analysis, web scraping, and potentially machine learning. Your role will be crucial in helping me to derive insights from a large dataset and extract specific information from the web. Key Responsibilities: - Conducting in-depth data analysis using Python - Implementing web scraping scripts to collect relevant data - Potentially developing machine learning models (based on your expertise) While the client did not specify the exact libraries, the ideal candidate should be well-versed in Python programming, particularly with libraries such as Pandas and NumPy. Familiarity with Django, although not mentioned, could be a plus if the project expands to web applicati...
..."Which are the recent/today's news about (...?) (**1) better to replace GPT4All with text-generation-webui or something (which can be automated) (***1)all extracting/converting instruments can be enhanced/replaced on your choice (*2) We talk about kpop news rss feed like ,soompi,kpop ,boo,kpop2 ,kmap,kpop3 (**2)We need to extract from ALL today's news a set dedicated to our subjects of interest (lets say Band1, Band2 & Artist1) in a form of short review with a link to the full source OR in a form of a full news text Choose which is easier to implement. (***2)It could be excellent to experiment with Native Korean web sources (full site or rss scraping) but i doubt any good local LLM can do it in Korean language giving out
I have a large file from my old website, saved in an unknown format (likely HTML, CSV, or XML). Key Points: - The file is from my old website, saved in an unknown format....and media from the old website to publish them on a new website. - The exact format of the file is unknown. It will be a TAR file and it is rather large file (5.9 gb) Ideal Skills and Experience: - Proficient in web development and file parsing. - Experienced in handling legacy website data. - Strong problem-solving skills for dealing with unknown file formats. - Ability to extract, organize, and migrate content effectively. This project requires someone who can navigate legacy systems and extract relevant data for repurposing. The successful freelancer must be resourceful and capable of ...
My project requires a well-versed professional proficient in to extract critical takeoff quantities from IFC files and integrate them flawlessly into operational smart contracts. Key requirements include: - Extraction of material types and quantity calculations from IFC files - Direct integration of the extracted data into smart contracts to ensure automatic updates - Generation of detailed reports that will pave the way for seamless smart contract integration The perfect candidate will have a strong front-end development foundation and proficiency in IFC.js. Experience with ReactJS and blockchain technology is also essential for the job. Your primary task is to create a user-friendly interface that makes integrating IFC files into smart contracts a breeze. Efficiency, ac...
...Database * Use Azure Storage or Microsoft SQL Server as local database * Store indexed data and search results in local database * File System * Use Windows File System or macOS File System * Index local files and folders * Search * Search local database and file system for relevant results * Display search results in user interface * User Interface * Develop user interface for Quivr Agent * Include search bar, search results, and settings Cloud Component: Calendar Service * Calendar Integration * Integrate with Microsoft Graph API for calendar data * Retrieve calendar events and appointments * Event Processing * Process calendar events and appointments * Extract relevant information (e.g., attendees, location, time) *...
I'm currently in need of a proficient CAD designer to create detailed, highly precise drawings based on a reference image I provide in JPEG format. Main Responsibilities: - Produce...Responsibilities: - Produce advanced CAD drawings that capture intricate details and exact measurements - Interpret the reference image accurately into the design This job is ideally suited for a CAD specialist with: - Exceptional skills in generating high-level detailed CAD drawings - Demonstrable experience working on CAD designs for manufacturing purposes. - Strong ability to interpret and extract details from JPEG images These CAD drawings will be used directly for manufacturing, so extreme precision and attention to detail are crucial. Please only bid if you understand and can meet thes...
...upload files downloaded from the Colombia Rama Judicial website. 3. Processing of uploaded files to extract and structure the required information*. 4. Visualization and filtering of the list of processes. 5. Detailed view of specific process information. 6. Temporary storage of uploaded files in the browser. 7. Functionality to delete data being processed and start a new analysis. 8. Automatic process to delete old records from the database. 9. Recording of deletions for audit and regulatory compliance purposes. Technical Requirements: - Development in Java, NodeJs, or Python languages. - Implementation of API for file processing and database access. - Data storage in a database. - Data security and encryption. Expected Deliverables: - Comp...
...Description: I need a developer to create a system that queries multiple external sources (18) through APIs, web scraping, and web page reengineering processes to extract information and structure it in the expected format. The system should generate a record of each query made, indicating whether results were obtained, no results were obtained, or if the source was not available. A document detailing all the sources of information from which data should be extracted will be provided. Main Features: 1. Automatic Querying of External Sources: Perform queries to multiple external sources according to the provided specifications. 2. Data Structuring: Process the obtained information and structure it in the required format. 3. Query Log Generation: Create a detailed l...
I'm in need of a proficient coder who specializes in regular expressions (regex). The goal is to extract specific data from a log file. Here are the task details: - Develop a regex expression to parse a log file - Specifically, I need to retrieve software name, version and install date Ideal Skills: - Strong experience with regex expressions - Understanding of log file structures - Attention to detail In your proposal, please include examples of previous similar projects.
Project ...Lead Conversion: Ultimately, our goal is to convert these leads into satisfied paying customers, driving tangible business growth. Desired Skills & Experience: Proficiency in lead generation and management across Facebook, Instagram, and Google Ads platforms. Demonstrated success in designing and managing effective lead capture forms. Strong analytical prowess to extract actionable insights from lead tracking and analytics data. Proven expertise in developing and implementing successful lead nurturing strategies. We invite you to share your relevant experience and outline specific strategies you would employ to help us achieve our objectives. Join us in shaping the future of our digital presence and driving impactful results for our business. Looking forward...
I'm seeking an expert in the field of data extraction from PDF files. Your responsibility will be to obtain the necessary content from a variety of PDFs diligently and accurately. Ideal Experience and Skills: * Proven track record in data extraction * Proficiency in dealing with PDF file formats * Attention to detail, for precise data extraction While the specific details required for extraction were not specified in the brief, it is expected that the suitable freelancer will have the skills to extract a wide range of content. Please bid with this in mind.
As a website owner, I am in need of a freelancer to scrape the text content from the unstructured, plain text and...owner, I am in need of a freelancer to scrape the text content from the unstructured, plain text and HTML of my website's homepage. Tasks to complete for this project will include: - Identify valuable text data from the webpage - Create scripts or suitable methods to extract this text data - Clean and deliver the scraped data in a readable, usable format The ideal candidate for this position will be proficient in data scraping technologies, HTML, Python (or similar), and have the ability to work with unstructured data efficiently. Prior experience in a similar project and familiarity with data cleaning will be a huge plu...
I am seeking for a skilled web scraper who can effectively extract product information from online catalogs on a website. The aim here is quite straightforward; we need to gather and download catalogs to enrich our store's database. To further specify, the data in question include: - Product Images - Product Descriptions - Pricing Information - Category Details You will be tasked to focus on all categories available on the website. As such, proficiency in navigating various website blockades is a must. Your ability to deliver comprehensive, detailed, and accurate information in a well-structured format is crucial to this job. Prior experience in similar e-commerce web scraping projects would be a great advantage. Look forward to your bids. Thanks in advance!
crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:
I am in need of an artist with a flair for traditional art styles to create an emotionally stirring cover art for my song. It's important that the artwork fully embodies a melancholic sentimentality. (You can create it with AI and combine artist face in it) Key Requirements: - Proficiency in capturing emotion through traditional art mediums - An ability to extract and interpret key events from music - Ability to translate the song's pivotal moment into a compelling visual narrative Bring this song's dramatic climax to life in a somber, moving piece of art. Experienced music interpreters and those with a talent for storytelling in the visual arts would be a natural fit for this project. Proven track record in delivering high quality traditional art pieces is a mus...
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integ...
...off a Dokuwiki for use elsewhere, (maybe in Dokuwiki or another html, css format) I am in need of an expert who can skillfully extract content from http: // geodesicsolutions . org /wiki/. The task is not recurring; it will require a single extraction that encompasses: - all the text content, - images, and - links. Ideally, the perfect candidate for this assignment will possess expertise or qualifying experience in web scraping. Knowledge on how to extract data from diverse formats will be beneficial. Proficiency in web scraping tools and techniques is a prerequisite. Once the content has been scraped successfully, I would appreciate if you can help arrange the data in a clear, accessible structure. Kindly ensure that while conducting the web scraping, the...
I am in need of a freelancer who is skilled in summarizing and essay writing. The task involves the summariza...summarization of a 5 to 10-minute educational or informative video into a concise, informative written piece, that is 1 to 2 pages in length. Ideal Skills and Experience: - Strong summarizing ability - Excellent written communication skills in English - Proven background in educational or informative writing Key Responsibilities: - Watch and thoroughly understand content of the video - Necessarily extract and capture key points - Compile summarization into a cohesive 1-2 page essay. Your work should reflect a great understanding of the topic, be reader-friendly, and mistake-free. Please include any relevant work examples in your bid. Looking forward to connecting...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
...for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools wi...
I'm seeking an expert in data scraping who can gather menu items and prices from all restaurants listed on Hungerstation. Key Details: - Your task is to extract data specific to menu items and their respective prices. - The project spans all restaurants on the platform, not just specific ones or top-rated restaurants. - I need the final data to be organized and shared in an Excel file. Appropriate Skills and Experience: - Proficiency in data scraping - Strong attention to detail - Familiarity with Excel for data organization and delivery.
I am seeking a proficient freelancer who can effectively extract data from six graphs (line and area) and reproduce the graph in Excel. Please review the attached Excel file for grahps (3 of them are already processed as an example). Ideal Skills & Experience: - Demonstrated ability in data extraction - Excel competence - A keen eye for detail Freelancers should include examples of their past work for consideration. Your bid should be reflective of your skills and experience. I am looking forward to viewing your proposals. Please make them as detailed as possible.
I'm searching for a professional with experience in data scraping to extract availability details from a list of Airbnb properties. Interestingly, you will: - Collect availability information from the Airbnb calendar for each URL provided. - The data to be extracted pertains to the 'status of availability'(whether a property is booked or available). No further details are required. - Upon completion of scraping, the availability data should be compiled into an Excel file. Skills and Experience: - Proficient in data scraping specifically from websites like Airbnb - Familiarity with Excel formats - Exceptional attention to detail - Strong adherence to timeline and deadlines.
I am in need of a freelancer who can assist me in the scraping of LinkedIn for the purpose of lead generation. The ideal candidate should be able to organize the data by industry and deliver the final dataset in CSV format. Key Requirements: - Efficiently scrape LinkedIn for specific industry - Organize the data by industry - Compile the final dataset in CSV format Ideal Skills and Experience: - Proficiency in web scraping, particularly LinkedIn - Ability to extract and organize data efficiently - Proficient in CSV file formatting - Understanding of lead generation needs and strategies Please provide examples of similar projects you have completed in the past, and let me know your approach to this task. I am looking for a freelancer who is detail-oriented and...
As a business owner, I need a meticulous and efficient individual who can extract image data from a series of PDF files. Key responsibilities: • Accurately extract image data from between 10 and 50 PDF files. • Ensure all extracted data is correctly logged and formatted. Ideal candidate: • Previous experience in data entry, particularly in handling image data. • Proven ability to work with PDF files. • Detail-oriented with high level accuracy. • Able to handle high volumes of data within a short period.
I'm looking for professional help to automate the process of uploading invoices to Amazon through the Selling Partner API. This will enhance our enterprise resources planning (ERP) system. A key feature needed is an ability to extract from the invoice filename data points such as marketplace id, order id, and invoice number. Ideally, the freelancer should have significant experience with Amazon APIs and ERP systems. Your deliverables should provide a seamless, error-free integration process which significantly reduces manual efforts. The invoices are already on the server as PDF file. I got the first step of the workflow to get an document id, but i can not upload the invoice to the given url. I only need the step 2 with upload an invoice to the given url or if neccess...
I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I'm looking for a skilled developer who can assist me in creat...within OpenAI's ChatGPT. This function will retrieve a number from a table, aiding me in my AI related tasks. Key Requirements: - Create a function within ChatGPT that can extract a specific number from a table. The table will be structured similarly to the example provided in this video: Ideal Skills and Experience: - Prior experience working with OpenAI's ChatGPT or similar AI assistants. - Strong programming skills, particularly in Python, which is the language used to interact with the OpenAI API. - Knowledge of data manipulation and extraction from structured data sources, like tables. - Ability to understand and implement the requirements specified in the video example.
I'm seeking a skilled data analyst to enhance our business insights using financial data. The ideal professional for this role should have a strong history in financial data analysis, and a knack for developing interactive dashboards for data visualization. Key Responsibilities: - Dive deep into our financial data to extract valuable insights - Help us understand our business better through these insights - Develop interactive dashboards to make the data accessible and actionable for the team Ideal Skills: - Proven experience in financial data analysis - Familiarity with data visualization techniques - Expertise in developing interactive dashboards
I'm in need of a seasoned Python developer to create a program to scrape information from Telegram channels. The main purpose of this project is to: - Develop a Python program that can successfully extract all usernames from diverse Telegram channels. Given the nature of this project, it would be ideal if you possess extensive experience in Python programming. Understanding the operations and functionalities of the Telegram API is a prerequisite as well. This project requires a comprehensive grasp of web scraping principles and a consistent track record in data extraction tasks. Please bid if you are confident that you can deliver this Python program efficiently.
I have a one-time project that involves converting a PDF file with tables into an Excel spreadsheet. The main purpose of this conversion is to extract specific information from the tables. Key Requirements: - Convert a PDF file containing tables into an Excel spreadsheet - Extract specific information from the tables Ideal Skills and Experience: - Proficiency in Python - Experience with PDF to Excel conversion - Ability to extract information from tables If you have the skills and experience I'm looking for, please submit your proposal.
I am looking for a Python experienced person capable of creating a web scrapper that can extract text content from Aliexpress and then categorize these extracted data into a Google Sheet in a specific format. Crawler in python format. Thanks. Please provide a sample
I need a freelancer to scrape text data from a PDF and output it into separate cells by paragraph in an Excel document. Key Requirements: - Extract and convert text data from a PDF into a structured Excel file. - Each paragraph should be in a separate cell in the Excel sheet. Ideal Skills and Experience: - Proficiency in PDF scraping and Excel data entry. - Attention to detail to ensure accurate data transfer. - Understanding of text formatting to ensure the data is organized accordingly in the Excel sheet.
I need a web scraper for Website 2, specifically to extract product details on a daily basis. Key Requirements: - Web scraping tool to extract product details from Website 2 - Automation to carry out the process on a daily basis Ideal Freelancer: - Proficient in web scraping with experience in similar projects - Knowledge of automation tools - Able to deliver a reliable and efficient solution
