Accessing web data vbacông việc
Tôi muốn thiết lập 1 bảng lãi suất tham chiếu theo lãi suất có sẵn, theo công thức của bên tôi. Nhờ các bạn lập giúp tôi và dạy tôi cách lập.
Cần 1 file excel có VBA (Macro) tự động link các thông tin: Định mức nguyên liệu - Kế hoạch sản xuất - Tiêu hao / Tồn nguyên liệu.
viết code vba/macro để lấy dữ liệu từ file tổng sang các sheet và dữ liệu sẽ luôn cập nhật khi có thông tin mới
Dự án của tôi là tự động điền thông tin từ một file excel này vào file excel khác, đồng thời so sánh một số cột dữ liệu giữa hai file.
Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.
Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .
Dựa vào stock và các raw đã được đặt, và bảng thành phần để tạo nên một mã hàng, dùng Vba excel tạo template sao cho chỉ cần nhập vào tên mã hàng, có thể xuất ra mã hàng đó có đang bị thiếu raw không, raw nào thiếu, và những raw thiếu đó ảnh hưởng đến bao nhiêu mã hàng
Dữ liệu về logistic (Có sẵn các cột, trường dữ liệu, cần code VBA để ra được bảng kết quả chuẩn) (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,
Trích xuất 1 số data từ file excel cho sẵn thành bảng mới Budget: 800k/ 2 file excel
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Tạo 1 macro lầy toàn bộ User Agent trình duyệt. Sau đó thay đổi User Agent của trình duyệt và tự động mở trình duyệt Yêu cầu: Lưu lại thông tin thay đổi User Agent để có thể khôi phục lại khi cần thiết (vì khi đóng trình duyệt thì User Agent sẽ tự động về lại như cũ nên cần phải lưu lại để load nếu cần) Ngôn ngữ là VBA viết trên nền Excel
Một file VBA excel kết nối với một số form excel để tổng hợp thông tin và trình bày dưới dạng dash board, xuất ra Powerpoint - Sales development - Margin development; - PL, BS and CF; - Cost development; Một số nút chức năng: - kiểm tra tình trạng file link; - refresh link; - report (click button to release report); Security: presentation format cố định, có password để mở, thay đổi
Mình muốn tìm một bạn code VBA trên exel cho dự án : " Hệ thống thông tin cho phòng cung ứng" Chủ yếu tool này có 3 chức năng chính : + Tạo chứng từ ( PR,PO,RFQ) rồi trình phê duyệt bằng outlook tự động xuất ra các trạng thái của chúg như: ( Mới tạo, đã gửi, đã duyệt , hoàn tất) + Tạo phiếu nhập , phiếu xuất , xem lịch sử nhập xuất + Kết xuất báo cáo : Chi phí vật tư , đánh giá nhân viên ( thông qua làm PO) , nhập xuất
Tôi cần thiết kế 01 file excel (VBA) - để quản lý toàn bộ dữ liệu xuất - nhập - tồn , bán hàng & logistics của công ty
Tôi muốn thuê viết code VBA để lập các báo cáo, tờ trình, quyết định theo mẫu
Mình đang quản lý các DA và muốn thuê viết chương trình trên nền Excel để quản lý các công việc và năng suất trên công trường như sau: 1. Tạo CSDL công nhân viên và mã công việc 2. Tạo CSDL năng suất lý thuyết theo từng công việc 2. Nhập chấm công theo công việc và mã nhân viên 3. Tạo bảng chấm công theo thực tế chấm công và năng suất lý thuyết 3. Tính toán và báo cáo năng suất theo các yêu cầu: loại công việc, thời gian, v.v
Nhập liệu với số lượng lớn , xuất ra theo định dạng có sẵn sử dụng vba excel
- Bạn có thể sử dụng VBA để lập trình quá trình sau: Mô tả: - Khi người dùng chọn vào ô đã thiết lập Data Validation trong Excel và nhập bất kỳ ký tự thì hệ thống sẽ tự động hiện ra list xổ xuống gợi ý những kết quả gần đúng có chứa những ký tự đó. (không sử dụng combo box) - Nếu người dùng bấm "Enter" thì ô sẽ hiển thị kết quả đầu tiên trên list - Nếu người dùng chọn một mục trên list thì ô sẽ hiển thị kết quả đã chọn - Thao tác xong sẽ đóng list lại
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
I need an expert to help me set up and utilize Burp Suite for accessing a single betting account in two tabs concurrently. The main goal is to facilitate simultaneous betting. Key Requirements: - Proficiency in using Burp Suite for managing multiple login sessions - Experience with online betting platforms - Understanding of the requirements for simultaneous betting Please note, the task involves logging into the same betting account in two tabs, not creating multiple accounts.
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.
