Accessing web data vbaJobb
I need Terraform scripts to deploy a NodeJS project container on AWS Fargate serverless. The container should only be accessible through an AWS Gateway, which also needs to be set up via these scripts. Key requirements: - Deployment should be in us-east-2 region. - No database setup is necessary for this project. - Use of IAM Roles for accessing the container via AWS Gateway. Ideal skills and experience for this job include: - Proficiency in writing Terraform scripts. - Experience with AWS Fargate and AWS Gateway. - Familiarity with NodeJS container deployment. - Knowledge in implementing IAM Roles for access control.
I need assistance with my Excel VBA and Python integration. I can open a Colab Notebook from VBA, but I'm having trouble getting the code to execute automatically upon opening the Notebook. VBA-code: Sub StartColabScript() Dim colabLink As String colabLink = "" colabLink End Sub I cant get this code to run my Python-script. I also tried: # Add code to Colab Notebook !python /path/to/ !python (I dont know if the Notebook is called the right way. The name of my workbook is: Ny241028Hent33Tickers3Blokke5y I guess its .py How do I refer to this workbook from VBA, and how do I get to autoexecute
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I'm looking for an experienced kitchen designer who can use 2020 Design software to create simple kitchen layouts based on our provided blueprints. You will need access to KCD and/or CNC cabinetry catalogs for specifications, as I have specific brands/models in mind. The job involves: - Designing kitchens using 2020 Design software. - Accessing KCD and/or CNC cabinetry catalogs to meet the specifications. - Creating layouts and elevations from supplied blueprints. - Providing a comprehensive parts list. Ideal candidates will be USA based, have a deep understanding of 2020 Design software, and experience with KCD and/or CNC cabinetry catalogs. Familiarity with specific cabinetry brands/models is crucial. A portfolio demonstrating previous work with 2020 Design software will be...
Vänligen Vänligen Registrera dig eller Logga in för att se mer information.
I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only be to help me progre...
I'm experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it shoul...TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am not usi...
Excel VBA Macro Debugging - Compiler Error Fix I'm encountering a compiler error while running a macro in Excel VBA. The macro is primarily designed for data manipulation and includes various functions. I need assistance to diagnose and fix this issue so the code can run without errors. Ideal Candidate: • Extensive experience with Excel VBA and macros. • Strong troubleshooting skills to resolve compiler errors. • Proficiency in data manipulation using macros. • Ability to maintain existing code functionality while fixing errors. Important Instructions (Read Carefully): 1. To Be Considered: You must resolve the error and provide the complete, functional code. I will test the code, and payment will only be made if it works as ex...
...server code is available. Basic routes for processing requests are connected. API access is open (successful connection to the Viva Wallet server). What is required: Check the current code for compliance with the Viva Wallet documentation. Fix errors that cause HTTP 404 when accessing the API. Configure and test Success and Failure callbacks. Make sure payments work correctly on the Production environment. Technical details: Backend: Python (Flask). Encoding: UTF-8. Test server is available for deployment. Real API data (Production) is used. What I will provide: Access to the server via SSH or FTP. Environment variables (client_id, client_secret, source_code). Files with the current project code. Timeframe: Complete the task within 3-5 days. Expected result: Fully wor...
...sampling from images or other sources, and they should be integrated into the system with unique branding names (e.g., "Ocean Blue"). 2.6 Copyright Protection: Processed images will include a transparent watermark (Kerato Life logo) across the photo to protect copyright, without significantly impacting the user experience. 2.7 Terms of Use Agreement: Users must agree to the terms of use before accessing the system, acknowledging its purpose and limitations. 2.8 User-Friendly Interface: The system should be accessible on both desktop and mobile devices. A side menu will allow users to easily browse and select eye colors. 2.9 Sharing and Saving Options: Users will be able to share their results on social media (e.g., Facebook, Instagram) with the Kerato Life logo included...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you have a...
We are looking for a DLL written in C# that can be used with MS Access through VBA code using late binding. The library should be capable of sending controlled error emails from MS Access and returning a response confirming the success or failure of the sending.
I'm looking for a professional developer who can create a macro for my Excel file "Report1". Here's the functionality I need: - When the user clicks the "Select File" button in the Excel file, they should be able to choose the Word document (e.g., "SampleForm1"). The macro sh...legacy forms, which may complicate things, but this needs to be handled. Considerations: - The software versions in use are Office 365. - Text fields from the Word file should match with the columns in the Excel file by field name. - If a field from the Word file does not exist in the Excel template, it should simply be ignored. Ideal skills for this job include advanced Excel and Word knowledge, VBA programming, and experience with legacy Word forms. Please provid...
I am looking for an Excel expert who ca...combinations that I will provide. Initially, I will supply a list of origins and destinations, but I need the matrix to be easily expandable for future use. Key Requirements: - Creation of a simple distance-only freight matrix - Integration of a user-friendly Excel form to add new locations - Incorporation of specific truck combinations into the route planning I am not familiar with programming or VBA, and I would like to know if this project is feasible before awarding it. Please, check the NHVR API tool link: Ideal candidates should have extensive experience with Excel and route planning tools, and should be able to provide a clear, user-friendly solution for future use.
...for each profile such as: - Viewing and posting journals - Accessing forums - Updating personal information - Choosing to make some private entries public - Downloading a free PDF of their private journal - Ordering a printed copy of their spiritual journal The home page should highlight the members' journals and the blogs/forums. All members should only access these features if their membership is paid. Ideal skills and experience for this job include: - Extensive knowledge and experience with WordPress - Previous work with subscription-based sites - Understanding of creating both private and public user profiles - Experience with integrating e-commerce functionalities into a website - Excellent web design skills to create an engaging and ...
...camera does not load when I try to use my mobile to scan. Key Requirements: - Troubleshooting and fixing the QR code and barcode scanner issue on my web application, which is accessible via both iPhone and Android devices. - Ensuring that the camera loads correctly when trying to scan barcodes and QR codes. - Optimization of the web application for use on Firefox, which is my primary browser for accessing the site. Ideal Skills and Experience: - Proven experience in web development and troubleshooting web applications. - Expertise in understanding and fixing issues related to web-based QR code and barcode scanners. - Familiarity with optimizing web applications for mobile use and different browsers, particularly Firefox. - Excellent com...
...**Early Childhood Development:** Supporting the growth and development of young children to ensure a solid foundation for their future. - **Addictions Counseling:** Offering necessary support for individuals facing addiction challenges. - **Cultural Integration:** Weaving Indigenous cultural practices and teachings into everyday life. - **Education and Career Training:** Assisting families in accessing educational opportunities and career training to enhance their futures. ### Our Mission As a proudly Indigenous-owned organization, we understand the unique challenges faced by our people and families. Recognizing the lack of Indigenous-owned group and reunification homes, we strive to fill this gap with compassion and empathy—key ingredients for the success of our homes. ...
I need an Excel macro that can automate the creation of product labels. The macro should be able to generate labels that include: - SKU number - SKU Description - UOM (Unit of Measure) - Up or Down Arrow The ideal freelancer for this project should have extensive experience in Excel and VBA (Visual Basic for Applications) for creating macros. Please provide examples of similar projects you have completed. The macro should recognize various size labels based on avery sheet label sizes. The Description, font size and number of characters should adjust based on size of label. I have existing file but would like to review as I speak to a developer to ensure needs are understood before sharing.
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I've recently installed a new OPNsense firewall and am experiencing an issue with my Windows PCs not displaying in the network file manager. Despite being able to ping other PCs and accessing their shares via direct IP input, the PCs are not visible in the network file manager. Key Points: - All PCs are connected to the same network segment. - Network discovery has been enabled on all the PCs. I reset the firewall and restarted discovery on 2 of the PCs to see if that resolves it, but nothing... I suspect there is a setting on the OPNsense firewall that I do not know about. Your task will be to troubleshoot and resolve this issue, ensuring that all PCs are visible in the network file manager. Ideal candidates for this project would have a strong background in network config...
I need a service-oriented website that includes a client portal. This portal should facilitate: - Booking appointments - Accessing account information - Submitting service requests The level of user authentication will be basic, using just a username and password. Ideal candidates for this project should have a strong background in web development, particularly in creating interactive service-based websites. Experience in developing client portals is crucial, along with a solid understanding of implementing secure, user-friendly authentication systems.
...- Develop firewall rules and security protocols to prevent unauthorized access. 3. Laptop Configuration: - Install and configure Linux OS (Ubuntu Desktop 22.04) on 10 Dell XPS 13 laptops. - Set up secure remote access (e.g., SSH, VNC) for laptops to connect to the Maryland server. - Test and optimize traffic routing to ensure all data passes through the server. 4. Testing and Troubleshooting: - Simulate real-world activities (e.g., accessing news sites and other approved platforms) to verify system performance. - Identify and resolve issues related to latency, connectivity, or geolocation detection. 5. Documentation and Handover: - Create detailed documentation for system setup, configurations, and maintenance procedures. - 2 HRS Training end users ...
...unauthorized users from embedding the origin stream directly in a player. On the edge servers, implement a secure token system for HLS streaming: Every time a user attempts to view an HLS stream, they must provide a valid token. The token should be generated using a secure hash algorithm and must include an expiration time. If the token is invalid or expired, the user should be blocked from accessing the stream. 3. Optimization for High Viewer Capacity: Optimize the NGINX RTMP configuration to handle a large number of concurrent viewers with minimal resource usage. Implement caching. Deliverables: A 2 fully configured NGINX RTMP (origin and edge) setup with the described authentication and security features. Documentation explaining the token generation process for bot...
...Features Instant Messages: Saving frequently used messages and quickly accessing them with the “/” command. User Tagging: Assigning labels to users’ messages. For example, labels such as “VIP Customer”, “Pending”, “Completed”. Listing by Labels: Displaying and filtering customer groups based on labels. 6. Integrations WhatsApp API Integration: Integration of official WhatsApp API or third-party APIs. CRM Integration: Automatically transfer user information to a CRM system. Webhook Support: Data transmission and integration to external applications. 7. Security and Performance User Verification: Support for two-step verification and OTP. Data Encryption: End-to-end encryption to ensure the security of user and m...
Vänligen Vänligen Registrera dig eller Logga in för att se mer information.
...and building relationships with high net worth individuals (HNIs). Key Responsibilities: - Client Acquisition: Primarily focusing on HNIs through various strategies including digital marketing, networking events, and referral programs. - Client Management: Overseeing existing clients and their financial goals. - Support Provision: Assisting clients with trading, opening demat accounts, and accessing other financial services. - Product Recommendation: Advising clients on an array of financial products such as mutual funds, stocks, and bonds. - Portfolio Planning: Creating and managing bespoke investment portfolios. Ideal Skills: - Proficiency in digital marketing strategies targeted towards HNIs. - Excellent networking abilities and experience in attending high-profile events. ...
Project Title: Build a Secure Java & Angular-Based Platform for Accessing Third-Party Services Project Description: I am looking for a skilled developer to create a web platform similar to , where users can log in once and seamlessly access various third-party services like Freepik, Envato, SEMrush, and more, without needing to handle or manage individual service credentials. Scope of Work: The platform will have the following key features: User Authentication and Dashboard: Users will log in using a single set of credentials for the platform. Once logged in, users will see a dashboard listing third-party services (e.g., Freepik, Envato, SEMrush) they can access. Clicking on any service will redirect users to the service's website, alre...
I'm looking for an Excel VBA expert to help me with a local Excel file. The task involves creating a script that will filter data in a pivot table based on specific criteria. Ideal skills and experience: - Proficient in Excel VBA - Experienced in working with pivot tables - Strong understanding of data filtering techniques - Ability to write clean, efficient code
I'm looking for a skilled VBA programmer to create a dynamic filter function for my Excel pivot table. The data source is an Excel workbook and the pivot table is primarily dealing with numeric data. Key Requirements: - Create a VBA code that allows the pivot table to filter numeric data based on custom criteria. - The filter should be dynamic, adjusting as the data changes. Ideal Skills and Experience: - Proficiency in VBA programming with a strong understanding of Excel pivot tables. - Experience in creating dynamic Excel functions. - Ability to understand and implement custom filtering criteria.
...programmes. The system must include automated daily web scrapers to pull new announcements and update the database efficiently. This solution will enable seamless data retrieval, analysis, and management for stakeholders. Scope of Work 1. Database Development • Design and implement a scalable, secure relational database (e.g., MySQL or similar) for storing funding and tender listings. • Database structure should accommodate fields such as: • Title of the funding or tender. • Description and eligibility criteria. • Submission deadlines. • Funding amount or programme budget. • Contact details or application process links. • Relevant documents (if applicable). 2. Web Scraping Setup • Develop web scrapers...
I am in need of accessing the Meta Media Partner support portal, primarily for the purpose of utilizing its collaboration tools for an account we manage. Ideal skills and experience for the job include: - Proficiency with Meta Media Partner portal - Strong understanding of collaboration tools - Excellent communication and project management skills
...developer to address a set of tasks related to my WordPress and Laravel setup. The current setup is hosted on a subdomain () for testing purposes. Below are the project details: Current Setup Details: WordPress is installed in the root folder within a Laravel application. Both platforms need to work seamlessly together. Tasks and Requirements: Fix URL Conflict: Resolve the issue where accessing URLs like incorrectly redirects to /blog without showing the public folder content. Ensure WordPress and Laravel URLs function independently and as intended. Cross-Platform URL Search for Internal Linking: Implement a feature to search and manage URLs across both WordPress and Laravel platforms. This tool will help in identifying, managing, and linking URLs across both platforms
I'm facing a serious issue with my Server 2003. It's an additional domain and we're having replication problems. Specifically, we're seeing replication failures with error messages. The types of error messages we're encountering are primarily n...encountering are primarily network connectivity errors. The ideal freelancer for this project should have: - Extensive experience with Server 2003 and its domain configuration - Proficiency in diagnosing and resolving replication issues - Strong understanding of network connectivity errors and their potential solutions - Skills in configuring and troubleshooting DNS settings - Familiarity with accessing and interpreting server error logs Please, only apply if you have the necessary experience and skills to resolve...
I need assistance in accessing and extracting inventory details from three Oracle .dmp files and five other files with no extension that I have. The data needs to be compiled into an Excel file, and preferable to access the files themselves via a google drive or similar Ideal skills for this project include: - Proficiency in Oracle database - Data extraction and manipulation experience - Excel data formatting skills Please note, I only have the export files and do not have direct access to the Oracle database.
I'm seeking an Excel expert to assist with my spreadsheet. I need help with creating and modifying formulas, writing VBA scripts, and troubleshooting existing issues. The spreadsheet has some minor discrepancies that need to be corrected to enhance data accuracy and improve the user interface. Ideal Skills: - Advanced Excel skills - Proficiency in writing and modifying VBA scripts - Strong troubleshooting skills - Experience with data accuracy improvements - User interface design skills in Excel The goal is to tighten up the spreadsheet, improve its performance and make it more user-friendly.
PS : BIDS WITH NO EXAMPLE OF THEIR WORK WILL BE REJECTED I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests u...
...Incident Management (Ticketing): Verification of all operations related to the creation, processing, and closing of incidents. Asset Management: Verification of operations related to asset registration, modification, and deletion. Administration: Verification of all functionalities offered in various modules, including user management, access rights, and system-wide settings. Dashboard: Verify that the data displayed on the dashboard is correct and up-to-date. Test dashboard customization. Jobs: Verification of the proper functioning of various application jobs, ensuring they execute correctly and on time. 3. User Types and Access Levels Verification The tests must include verification of the system's operation for three types of users and ensure that each user has the corr...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. r...
I require an Excel expert to create macros and VBA scripts to transform my imported Excel data into a specific format. The necessary modifications span across data formatting, calculations, and filtering. You will need to adjust: - Headers - Columns - Rows The data will be imported from another system, so I need a professional who is skilled in data manipulation and can ensure the output is consistently formatted according to my requirements. The format of excel before editing & after editing are attached for your final product should come with a button "Format" which can convert my excels to my required format. NOTE: I need to see your previous works in Excel macros & VBA before awarding this work
Do analysis and create data visualize for company product
I'm looking for an advanced Excel expert who can create a roster maker fo...shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts. - User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours. - Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros. Ideal Skills: - Expertise in Excel and VBA for Macros - Experience with creating complex scheduling tools - Ability to understand and implement conditional formatting and formulas The goal is to have a functional, user-friendly Excel sheet that can simplify the task of roster creation. Please provide examples of similar projects you have complet...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. r...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **...
...an experienced Memberstack expert to help resolve an issue with my membership site built on Webflow. Currently, I have clients on a free plan who have access to the site, but when users upgrade to the paid £99 plan, they encounter a "404 Access Denied" error. Here are the details: My site is built on Webflow and uses Memberstack to manage memberships. Clients on the free plan have no issues accessing content. Users on the paid £99 plan experience a 404 error when trying to access protected content. I need someone who can diagnose and fix this issue ASAP. Ideally, you should have: Proven experience with Memberstack and Webflow integrations. A clear understanding of membership access settings and permissions. Ability to provide a fast resolution to this iss...
I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summ...
...skilled Digital Forensics Expert to investigate and recover critical data related to a legal case. This involves accessing and analyzing call records, WhatsApp conversations, and other digital communication data without direct access to the involved devices. The recovered data must adhere to strict confidentiality and legal standards. Key Responsibilities: - Use advanced forensic tools and techniques to recover communication records. - Analyze telecommunications systems for potential evidence, including call logs and message metadata. - Reconstruct deleted or hidden data from WhatsApp or other messaging platforms. - Provide a detailed forensic report with timestamps, recovered data, and actionable insights. - Ensure data integrity and le...
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