Accessing web data vba일자리
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
I'm in need of a PHP script that will restrict all search engine crawlers from accessing any page on my entire website. The script needs to be robust and capable of preventing page access for these bots. Ideal Skills and Experience: - Proficient in PHP - Experience in web security - Knowledge of bot detection and blocking techniques
I'm in need of a skilled data entry professional to assist with entering numerical data from our databases. The primary purpose of this project is for record keeping. Ideal Skills: - Proficiency in data entry - Familiarity with handling numerical data - Experience with database management - Attention to detail - Good organizational skills Your task will primarily involve: - Accessing our databases - Accurately entering numerical data - Ensuring all records are kept updated and organized
I'm looking for an experienced professional who can configure OpenVPN with SOCKS5 and an undetectable browser on my Windows system. The main goal of this setup is to bypass geo-restrictions, particularly for accessing social media platforms. Key Requirements: - Expertise in VPN and SOCKS5 configuration - Familiarity with undetectable browser setups - Experience with Windows OS - Ability to create a setup that can bypass geo-restrictions effectively Your bid will be considered if you have demonstrable experience in similar projects.
...privacy-preserving techniques to minimize the risk of identifying individuals. Create a basic demonstration of the prototype. Phase 3: Research and document ethical considerations related to the use of AI in public safety. Prepare a presentation summarizing the project and its findings. Budget: Software/Tools: $150 (for cloud computing services, machine learning libraries) Data Acquisition: $50 (for accessing and processing video data) Miscellaneous: $50 (for potential hardware, presentation materials, etc.) Total: $250 Timeline: Phase 1: 2 months Phase 2: 1.5 months Phase 3: 0.5 months Key Considerations for a 9.5/10: Detailed Documentation: Maintain meticulous records of your research, development process, and findings. Focus on Impact: Clearly articulate the p...
...Feature. main site is (Porto Theme) subdomain is (HiStudy Theme) To keep Porto (main) and Histudy (subdomain) theme developers from accessing each other's areas, I MOVED the subdomain out of public_html which broke the multi site setup. DELIVERABLE: a. Network Plugins especially Currency Switcher, User Sync, Global Cart MUST work in domain and subdomain without issues. Plugin updates should also show no errors. b. One database for all products, events, courses on domain and subdomain c. One database for customer data and purchases so customer account in main is same as subdomain. d. Setup a ftp or a way where if Porto developer needs to fix a theme issue, Porto developer cannot access subdomain. This project WILL NOT
...Price: Converted to local currencies for 13 countries using a custom exchange rate. • Local Morocco Price: Always converted to MAT currency for Morocco customers only. 4. Access Control: • Morocco customers: • Can only view local prices in MAT. • Blocked from viewing international prices. • International customers: • Can only view international prices. • Morocco customers are blocked from accessing this category. • Implement VPN blocking to restrict access via proxies. Platform Migration 5. Migration from Existing Platform: • Transfer all DNS records to the new Shopify platform. • Integrate with all social media platforms and Google tools. • Transfer the existing owned domain to Shopify. • Implement 301 ...
I need a webmaster for a small, urgent task. I have a domain, hosting on OVH, and a WordPress subscription. The domain is connected to OVH and my DNS is configured. Now, I need help with: - Connecting my "Work In Progress" WordPress page to my domain. - Accessing files hosted on my FTP. I'm able to upload but can't access them via a browser. Currently, any URL pointing to my file redirects to the OVH "Site under construction" page. The types of files I'm trying to access are various document types. I would appreciate your prompt assistance, as this is quite urgent. I look forward to your help. Thank you.
...social login. Instructor Dashboard: Interface for instructors to upload courses, manage live streams, and track sales. User Interface: Intuitive interface for browsing, purchasing, and accessing courses. Notifications: Push notifications for live session reminders, promotions, and updates. Technical Requirements: Frontend Framework: Use React Native or Flutter for cross-platform development. Backend Framework: Use Node.js with or Django for server-side development. Implement REST APIs or GraphQL for communication between frontend and backend. Database: Use MongoDB or PostgreSQL to store user data, course details, and transactions. Cloud Integration: Use AWS or Firebase for cloud services like video storage, live streaming, and user authentication. Payment Processin...
...Development using ARS Forms & ARS objects - Active Links, Filters, Escalation, Active Link Guides, Filter Guides, Menus, Web Services, and Applications. Very Good Exposure to Remedy Integrations using the latest version of Remedy APIs, ARS workflow, Integrations with SRM, Incident, Change, Work Order and CMDB Module. Strong know-how of functional and design aspects of the BMC Remedy ITSM Suite is a must. Experience in developing enterprise software products, in a fast-paced, distributed, and agile development environment Experience in Asset Management, Smart IT and Helix Dashboard Experience in developing/accessing Web Services including good knowledge of REST protocols and web development using Java-script/Jason will be an added advantage Experience in S...
Project Title: Web-Based CRM System Development for HR and Employee Management Project Overview: I am looking for a skilled developer or team to build a Web-Based CRM System that will efficiently handle various HR and employee management functionalities. The system should provide features such as employee data management, attendance tracking, leave management, salary slip generation, performance evaluation, and other HR-related functionalities. I already have a domain and hosting set up; I only need the website to be designed, developed, and deployed. Key Features to Include: 1. Employee Management: Add, edit, and view employee details (e.g., name, department, position, contact information, etc.). Employee ID generation and profile picture upload. 2. Attendance Trac...
...integrated with Proxmox, specifically designed for managing KVM-based virtual machines. The control panel should include features similar to platforms like Virtualizor, ConvoyPanel or Virtfusion. Below are the key features and requirements: - Key Features Proxmox Integration: Seamless integration with Proxmox for managing KVM virtual machines, including creating, deleting, and managing VMs, accessing the VNC console, and configuring disk and network settings. - VPS Management: Full control over VPS instances, such as starting, stopping, restarting, and other management capabilities. - Resource Monitoring: Real-time performance statistics (CPU, RAM, disk usage, network bandwidth) for each VPS, ensuring efficient monitoring and management. - Billing System: Integration of a rob...
...analyzing data, interacting with users through natural language, predicting behaviors, or automating processes. The platform will enable users, even those without advanced programming knowledge, to develop and manage customized AI agents tailored to their operational needs. 2. Create a first AI agent capable of accessing the cadastral database and resolving queries for AMCO staff PROPOSED ARCHITECTURE: Frontend (User Interface): Streamlit: To create an intuitive interface where users can: Create new agents Configure prompts and behaviors Monitor performance View analytics and results Backend (Agent Logic): CrewAI: For agent orchestration and management Anthropic (Claude): As the base model for the agents AgentOps: For agent monitoring and tracking Storage: Supabase: T...
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
... Must be user-friendly, mobile-compatible, and equipped with a robust content management system to easily update and manage question sets. Key Features Needed: - User registration/login - Multiple choice question interface - Instant score display after test completion - Admin panel for managing questions and users - SEO optimized structure Required Skills: Web Development, PHP, HTML5, JavaScript, SEO Further details - Work Instruction for Developing High-Performing Dynamic Educational Websites with Advanced SEO Purpose To create feature-rich, paid educational website focused on OC (Opportunity Class) and Selective School Test preparation which is mobile phone compatible as well. Both test formats will have two sections on Thinking Skills and Mathematical
Keyboard practice simple game web-based and app pwa development Keyboard position, word sentence keyboard position learning game development Speed and accuracy must be done within the time limit and is the same as the existing keyboard game practice game released on the Internet Users can play the game by accessing the web or app pwa and there is a tournament There are conditions that development participants must know 1. Do not communicate in English, but communicate with a translator. Do not ask the client to speak English 2. If you work together, only developers who can develop immediately and complete development quickly participate Participate in development that meets the above two conditions, and if you do not meet them, Please do not apply for participati...
Multiple analytical works and updating of codes and VBA
I'm having issues accessing my instances from outside my PfSense firewall after creating them in Open Nebula. Everything seems correct but I suspect there might be a problem with the firewall configuration or the network settings. I have already checked the firewall rules, reconfigured instance settings, and verified network connectivity. Unfortunately, the issue is affecting all instances, not just specific ones or new ones. I'm looking for someone with expertise in Open Nebula, PfSense, and firewall configurations to diagnose and fix this issue. Please let me know if you can help.
...Inviting a Friend**: - Users can copy a referral link to their clipboard (for both phone and desktop). - Conditions for Discount: - Friend’s account must be either: 1. Not yet created, or 2. Created less than 24 hours ago and after the referrer’s account. - Discount applies to the friend’s account. - **Price Calculation**: - Use price-per-prompt data from the JSON file: `oneDollarAIBE` - Regular price is 5x the cost listed in the JSON file. - **Record Account Spending**: - Use the provided function to track tokens used and spending. - **Fee Calculation**: - Cost calculated using the function: `oneDollarAIBEchatApimanagementcommands` - Input includes all messages (current
...skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to write clean, efficient, and well...
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
...method for accessing real estate listings from multiple MLSs through one data feed and license agreement. This reduces the complexity of managing data from various sources. API Integration: API Key and Agreement: First, you'll need to secure an API key from MLSGrid, which involves agreeing to their licensing terms. This key allows access to the listing data. RESO Web API: Use the RESO Web API standard for data retrieval. This API is designed to be more efficient for real estate data transfer, focusing on replication rather than real-time access. Data Retrieval and Management: Data Replication: Since MLSGrid does not support real-time data access, you'll need to use a replication process. This invol...
...system administrator or database specialist to assist with the installation and configuration of PostgreSQL on two new servers. The goal is to establish a replication setup where one server acts as the primary (master) and the other as a replica (slave), ensuring automatic synchronization and real-time backup of the primary server’s data. The setup should also allow secure connections to the PostgreSQL database from a third server, which will be used for accessing the database remotely. Key Requirements: PostgreSQL Installation: - Install the latest stable version of PostgreSQL on both servers. - Configure PostgreSQL to run as a service on both servers, ensuring automatic startup on reboot. Master-Replica Configuration: - Set up one server as the primary (master)...
...machines. Example: Install Odoo on a Windows server with a clean configuration. Acceptance Criteria: Odoo is properly installed on our local server. The Odoo interface is accessible via a browser on the local network. The default database is accessible and functional. Remote access should be enabled via virtual machines for accessing Odoo. Test to Perform: Check if Odoo loads correctly in the browser (e.g., http://localhost:8069). Test creating a database and accessing the admin interface. Test remote connection to Odoo. 2. Installation of Stock, Sales, and Purchase Modules Requirement: Install and configure the following modules in Odoo: Stock Inventory Point of Sale (POS) Purchase Accounting All necessary modules for stock management, restocking, and sales. Example: Add ...
...NinjaTrader 8 trading platform using a DLL integration approach. The goal is to automate trading operations seamlessly, facilitate data access, and streamline account management. Key Features: 1. Automated login to NinjaTrader 8 from Python 2. A stable connection maintained by a keep-alive mechanism 3. Comprehensive account information and trading capabilities access, including: - Monitoring account balance and positions - Order management (placing, modifying, cancelling) - Receiving real-time execution updates 4. Extensive market data functionality: - Downloading historical bar data - Creating real-time price feeds - Accessing market depth information Deliverables: - A Python and DLL package with complete integration fun...
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
...need an experienced Node.js developer to set up a secure server for my project. The task involves: - Placing the private key (.key), certificate (.crt), and optionally the CA bundle in the project directory. - Installing required modules like and using the https module to create a secure server by loading the SSL files. - Starting the server on the specified port and testing it by accessing the domain via https. - Ensuring the server allows traffic on the designated port. I already have the SSL certificate and private key files ready. However, I’m unsure about the necessity of supporting HTTP/2 for this secure server, so I would appreciate your advice on that. Ideal skills for this job include: - Extensive experience with Node.js and - Proficient in SSL installation
I need briefing materials for myself to prepare for a panel discussion next week, so OK to use ChatGPT and also translation tools. The focus is opportunities in China biotech, and the audience is healthcare/biotech innovators, investors and executives. They want to learn about (a) accessing the growing market for healthcare in China, (b) partnering with Chinese healthcare/biotech companies, and (c) finding VC investment capital in China. I could also use some general information on growth and size of market in China, and how it ranks in the world. I am seeking business research on the key players and competitors in the China biotech and healthcare industry, focusing on both local and international companies. Your research should encompass: - R&D Activities: A broad overview o...
Welcome! Check out this stunning Gemstone Lamp Clipart Set, featuring 6 high-quality JPEG and PNG images, perfect for digital download. These elegant designs are perfect for creative projects such as logos, invitations, banners, or social media graphics. Set includes: JPEG images for pri...such as logos, invitations, banners, or social media graphics. Set includes: JPEG images for print projects Transparent PNG images for seamless designs Enjoy free commercial use to enhance personal or business projects. With your purchase, you will receive 2 ZIP files, each containing 4096 x 4096 pixel images. This is a digital download, so no physical items will be shipped. For assistance in accessing your files. Please feel free to contact us for assistance. Get creative with this stunning ...
...Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for Payroll - button for creating print page in A5/A4 data on a company letter head based on data size This needs to be developed using excel ...
...support client management. Work independently on tasks such as document creation and organization using G-Suite, Microsoft Office (Word, Excel, PowerPoint). Organization and Reliability: Stay organized, meet deadlines, and provide dependable support with minimal supervision. Additional Expertise (Preferred but not required): Experience with SuiteDash, advanced Excel (e.g., VBA, financial modeling), QuickBooks, Etsy, web design, and graphic design is a plus. Requirements: Language Skills: Excellent verbal and written communication in English. Proficiency in additional languages (e.g., Spanish) is a plus. Tech Skills: Proficient in G-Suite, Microsoft Office, Canva, and social media platforms. Reliable internet connection for seamless communication and online tasks. ...
...platform for purchasing and managing eSIM profiles for international travel and other use cases. Provide seamless user experiences across web, iOS, and Android platforms. Integrate secure and reliable payment gateways for smooth transactions. 2. Scope of Work: The project will be divided into the following key areas: 2.1 Website Development: Platform: Development of a responsive website accessible on desktop and mobile devices. User Interface (UI) Design: Creation of a modern and intuitive UI/UX design, focusing on ease of navigation and user engagement. eSIM Catalog: Implementation of a searchable catalog of available eSIM profiles, including details such as data allowance, validity, and coverage. User Accounts: Development of user account management features, includin...
I'm looking for a flutter developer to create a ride management app. The primary users of this app are both drivers and customers. The app should have a host of features that ensure a seamles...customers. The app should have a host of features that ensure a seamless experience for both parties. 5 Page Design: - Branded splash screens and a user-friendly interface - OTP-based login for security - Real-time trip management - For Drivers: A focus on using OTP for trip management, viewing assigned trips and navigating via Google Maps - For Customers: A priority on tracking vehicles live, accessing driver details, and receiving push notifications for trip updates I will provide the Wireframe design would have to thought, figma or adobe design is not available as it as MVP we are t...
...desktop management to manage our maintenance logbook. The database will be a spreadsheet in a shared OneDrive folder. Key Features: - Automatically assigned Job Numbers and Dates. - Staff inputting data such as issue descriptions, locations (from a dropdown list), their names (from a dropdown list), estimated and actual completion dates (using a date picker), maintainer's names (from a dropdown list), and notes (in a text box). - A checkbox for staff confirming job completion. Ideal skills for this project include: - Mobile application development, specifically for Android - excel development in VBA - Experience with creating user-friendly interfaces - Familiarity with integrating applications with OneDrive - Knowledge in using dropdown lists, date pickers and chec...
...create a trading application for both iOS and Android. The app should function as a broker's interface, allowing it to handle trades for up to 1000 users simultaneously on the GROW platform. Key functionalities include: - Real-time data tracking: Users should be able to see their respective profit, loss, buy, sell, quantity, and investment amount in real-time. - User access management: The app should feature a login page and a new registration page for accessing specific data from GROW. - Data storage: A Cloud-Based Database is preferred for storing user data. The ideal candidate for this project should have proven experience in developing cross-platform applications, with a solid understanding of trading systems. They should also be proficient ...
I'm looking for a comprehensive written document that critically reviews exercise programs aimed at preventing ankle sprains. The review should be grounded in scientific literature, so expertise in accessing and interpreting scientific journals is crucial. Ideal skills and experience for this job include: - Background in sports medicine, physical therapy or a related field - Excellent research skills, particularly in sourcing and interpreting scientific journals - Strong writing skills to produce a clear, concise, and engaging review - Experience in writing literature reviews or critical reviews is a plus.
Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!
I am facing an issue with my Gmail account where I am unable to receive emails. This problem arose after I changed on my hosintg server. I am accessing my Gmail account directly via the web interface, not through an email client like Outlook or Apple Mail. Ideal Skills: - Proficient in troubleshooting email server issues - Experienced with Gmail's server settings - Able to communicate solutions clearly Experience: - Prior experience fixing similar Gmail issues - Positive reviews from previous email troubleshooting projects
...assessment. Certification: Receiving a certificate upon successful completion of the assessment. Placement: Browsing job openings and applying for suitable positions. Employer Journey: Sign-up: Creating a company account and verifying business details. Skills Assessment Questions Creation: Developing and adding assessment questions relevant to their industry and job roles. Candidate Matching: Accessing a pool of candidates who have completed the assessment and match their criteria. Shortlisting: Selecting potential candidates for interviews. Placement: Hiring suitable candidates for internships or entry-level positions. Admin Journey: Managing All Features: Overseeing user accounts, assessments, job postings, platform content, and overall system functionality. Interactive P...
Develop a cost-effective, fully Google-powered workflow enhanced with external data sources to collect, validate, and manage data for local small-to-medium businesses (SMBs) not active on LinkedIn. The focus is on gathering business owner names, email addresses, and price levels (average ticket size). This workflow leverages Google Places API, Google Sheets, Google Apps Script, Google BigQuery, and Google Gemini AI, along with supplementary data sources for broader coverage. Scope: Data Sources: Primary: Google Places API: Core source for structured business data. Facebook Graph API: Supplementary owner and contact information. Yelp API: For reviews, ratings, and price levels. Secondary: Chamber of Commerce Directories: For local owner and email details...
...starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity with Chrome and its developer tools As the user is not sure which version of S...
I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to ...a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, prefer...
...starting it, asking to retry. I am looking for someone who can fix this for me. Runtime error 91 object varialbe or with block variable not set. I would also like this person to be the one to make future updates to the tool. - Error Message: The user did not specify what the error message is, as they skipped the first question. Therefore, the freelancer would need to investigate the error upon accessing the tool. - Selenium Version: The user is not sure which version of Selenium they are using. - Browser: The tool is configured to work with Chrome. Ideal skills for the job include: - Proficiency in Python and Selenium - Experience with Excel automation - Strong problem-solving skills - Familiarity with Chrome and its developer tools As the user is not sure which version of S...
I'm looking for a VBA script that will help me manage my schedule more efficiently. The script should take a list of appointments from an attached file and do the following: 1. Insert the appointments into my Outlook calendar according to the specifications in cell B3. 2. Send the appointments to the email addresses listed in column M. The script should be set to run manually, not automatically. I also need assistance deciding on the format for the email notifications. The options are Plain text, HTML, or Rich text. Ideal skills for the job include: - Proficiency in VBA - Experience with Outlook - Knowledge of email formatting Please let me know if you need any further information to give a bid.
Multiple analytical works and updating of codes and VBA
I'm seeking a designer to create a logo and YouTube banner for my website , a platform dedicated to sharing promo codes, discounts, and deals. Logo Design: - I envision a clean, modern, and vibrant design that communicates the concept of saving money and accessing exclusive promo codes. - The logo should integrate elements like tags, discounts, or visuals representing promo codes. - A color palette that inspires trust and excitement, such as green, blue, or orange, would be ideal. - The site name, "", should be included, although its abbreviation could be used as an optional element. YouTube Banner: - The banner should be professional and visually align with the logo, emphasizing the site's focus on promo codes and discounts. - Incorporating relevant
I'm seeking an n8n specialist to evaluate my workflow with a primary focus on data retrieval. Key Requirements: - Review my current n8n configuration - Identify opportunities for improving data retrieval. - Provide insights on improving overall efficiency The workflow is showing no errors but it doesn't seem to be accessing files uploaded to Google Drive. I also want you to verify the Webhook is working properly. ***You must be an n8n expert to bid on this. You must be able to show me n8n workflows you have worked on.***
I'm seeking an expert in financial analysis to assess our operational efficiency using historical data. The primary goal of this evaluation is to inform our performance review processes. Key Requirements: - Proficient in Excel, including Excel VBA for complex data manipulation - Experienced in Business Analysis and Data Processing - Able to present findings compellingly using PowerPoint - Skilled in developing pragmatic Business Plans based on the analysis The focus of this project is to evaluate our operational efficiency through specific financial metrics. A deep understanding of performance evaluation techniques is crucial. Please only apply if you can deliver high-quality analysis and clear, actionable insights.
