Vba error handling in loopcông việc
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
- Topics: ra mắt set menu mới cho nhà hàng - Thương hiệu: The Loop - Độ dài video: <= 2phút - Yêu cầu: có các thiết bị hỗ trợ cho việc quay hình (ánh sáng, chân máy,...)
Một nhà hàng nhỏ phong cách Châu Âu - The Loop
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
đơn giản chỉ là mở trình duyệt Chrome để đọc các element trên trang web Nhưng tôi bị lỗi Run-time error '33' SessionNotCreateError
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
WooCommerce website encountered an error when installing the "Square up for Woocommerce" plugin I am using the Square up plug-in and my checkout page has serious errors and my customers cannot make payment by credit card, they cannot enter credit card information and cannot pay mình đang sử dụng cổng thanh toán Square Up để chấp nhận thanh toán thẻ tín dụng (visa, master ...) hiện tại trang woo của mình bị đơ khi cài đặt plug in : Square for WooCommerce Cụ thể: ở trang check out form điền thông tin thanh toán tự động bị bật lựa chọn : Ship to a different address?" mặc dù khách hàng ko tích chọn vào ô tuỳ chọn đó, và lỗi nghiêm trọng ...
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
1) Hiện cần lập trình java sử lý lại các thuật toán logic và phát triển thêm game, sử lý sự co debug lỗi . 2) Có kinh nghiệm lập trình game cocos...cá nhân đảm nhận build game đã có sẵn và kết nối data mongodb để game chạy. Có thể làm việc theo dự án. Ngoài ra , một số project cần phát triển thêm tính năng mới cho game đã có sẵn. Liên hệ với tôi 0967939897 hoặc telegram quay_hu I need to develop my game project: demo: The server is operated by Java I need the technique to debug errors due to error code translation, develop more features. Client is written in cocos2d I need to replace the other int...
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
Tôi cần lấy link stream tv từ ứng dụng: Bạn cần phải viết code bằng php để vượt qua bước xác thực để lấy được link gốc. Ví dụ: link của CCTV8 có dạng: => Việc của bạn là lấy được link stream của CCTV8 mà không bị lỗi: 401 Error: Not authorised
Default paper for print barcode in odoo is A4 or letter my machine print barcode with width limit 5.2cm i want print barcode is 3x4cm please config for me print on this machine fix print with font unicode install module Purchase Barcode QWeb i install but it have error and i can't fix it
Mình cần một bạn cấu hình cho server chạy site tin wordpress cho 10000 user cùng online! My wordpress site always goes down (gives 500 Internal Server Error) during high traffic when it's over 2,000 users online. It needs to handle up to 10,000 at least. Hoàn thành dự án trong thời gian đảm bảo, giá hữu nghị nhé Có thể hợp tác lâu dài Mong hồi âm nhanh chóng của các bạn quan tâm! Cám ơn nhiều
... Key Requirements: - Extensive experience in writing product descriptions, ideally in a B2B environment - Strong understanding of SEO with the ability to conduct keyword research - Ability to tailor content to a professional audience The successful applicant will need to understand the intricacies of B2B marketing and be able to craft compelling product descriptions that resonate with this particular audience. This will involve a blend of strong copywriting skills and SEO optimization. Tasks will include: - Conducting keyword research and integrating these into the product descriptions - Writing engaging, professional, and accurate descriptions that highlight the features and benefits of our products - Ensuring all content is original, error-free, and consisten...
I have a 49-page double-spaced research proposal that requires meticulous proofreading. It's in the field of Social Sciences, and it's formatted using APA style. I need someone who can offer: - Proficiency in APA formatting - Extensive knowledge and understanding of Social Sciences - Fluent English language and grammar skills - Attention to detail in spotting inconsistencies and errors Your main task will be to ensure the text is error-free, coherent and adheres strictly to APA guidelines. Experience in academic writing and proofreading, particularly within the Social Sciences, is a big advantage. I'm looking forward to bids from professional proofreaders who can guarantee accuracy and quality. rewriting any weak or unclear sections, as we...
I'm seeking an experienced WordPress developer to bring my e-commerce website to life. Key project requirements: Fix cors Error issue Host website Integrate smtp mail Fix website routing (upon refresh navigate to home page) Debug Headless cms Communication will primarily be through email, so it's important that you're able to provide clear and detailed updates in writing. Ideal skills and experience: - Extensive experience in custom WordPress design - Proven track record in e-commerce development - Strong communication skills for regular email updates
I need a program that can scrape ...automatically eliminated. Key Responsibilities: - Scrape for home addresses - Compile addresses in CSV format - Include the duration each house has been listed - Run the program every hour to capture new listings - Automatically eliminate any duplicate entrie - Run CSV file against another data base that has age and name of owner and contact info. Ideal Skills and Experience: - Experience in web scraping and data extraction - Proficiency in programming languages suitable for web scraping (e.g. Python, Scrapy) - Knowledge of CSV file creation and data handling - Ability to automate processes for regular data updates Please note that the addresses should be stored in the CSV file with each one on a separate line for...
I'm in need of a talented software developer experienced in creating desktop applications, API integration with eBay, and inventory management. The application will interface with aspects of my business (selling digital items) that are not typical for eBay, so off-the-shelf apps aren't capable of handling. It should be a standalone Windows app. Key features you should be able to develop: - Listing Quantity updates -- Update my local inventory count as items sell -- Pull from my local inventory files on demand and update quantities available on eBay accordingly - Order Tracking -- Alert on new orders -- Identify repeat customers -- Pull specific info from buyer note or buyer messages -- Help with fulfillment by pointing to locations inventory i...
...intensive experience in FusionPBX and Freeswitch. The main objective of this project is the creation of a precise dial plan for FusionPBX. The developed dial plan should effectively handle active calls - holding them temporarily during paging calls. Key tasks include: * Dial plan must allow higher priority calls to override held calls * Acceptance of priority levels for different callers as input parameters The ideal candidate should possess these skills and experience: * Proven experience in FusionPBX and Freeswitch * Knowledge of implementing dial plans * Understanding of call flows and priority handling. Your task will revolve around ensuring a smooth call flow process during the paging, which detailed understanding of PBX systems and dial plans would be ...
we can do a task in different ways: I want to extract text from images with but I have a vulnerability error code which concerns , firestore and others I don't see any report but that's it for me prevents us from going further to remove these vulnerabilities?
I've run into an issue where the layout on my Home page, About Us page, and Contact Us page is not rendering correctly when using Avada Builder with my WordPress Theme. This error occurred without any recent changes being made to the layout or content that could have triggered this issue. The error occurred after we enabled SSL. The ideal freelancer for this project would: - Be highly experienced with Avada Builder and acquainted with potential rendering issues. - Understand WordPress Themes in detail. - Be proficient in problem-solving and bug fixing. - Communicate closely with me for project updates and any potential changes needed on the site. I need this problem to be fixed efficiently and quickly to ensure a seamless user experience on my website.
I'm seek...seeking a WordPress expert to help me resolve an issue I'm facing with my WordPress website. The problem I'm experiencing is that despite using the WordPress editor, I'm unable to add new posts or pages. This issue has been persistent and is causing a disruption in my content management process. Key requirements: - Fix the error that is preventing me from adding new posts or pages - Ensure the website's functionality is fully restored, so I can continue updating it without any hindrances Ideal skills and experience: - Proficiency in WordPress development - Understanding of WordPress editor and its functionalities - Troubleshooting skills to identify and fix the root cause of the issue - Excellent communication to keep me informe...
I'm seeking an experienced React developer to rectify a couple of bugs in my application. The issues include: - Navigation errors - Form validation inconsistencies Benchmarks for this job: - Prior React knowledge - Debugging abilities - Experience in handling similar technical issues Please discuss your relevant React debugging experience when you apply. The task should be completed within a week's time. Can't wait to hear from you all! Don't bid if your budget is mor than $20 and start your bid with "React bug".
...Please mention the name of the main character in the explainer video so I know you watched it. Bids that failure to register and mention the character’s name will receive no reply. I am looking to build an automotive marketplace app that will have a range of features to make it user-friendly for both buyers and sellers. Key Features: - User registration and login, Search functionality, Listing creation and management - 24-7 Ai agents support, API integrations from multiple service providers - In app purchases, Context aware AI agents for tasks API Integrations: - Price comparison, GPS and mapping services - vehicle search API, Third party services for warranties and ancillary products - AI Tools like and SalesGPT for handling inbound and outbound calls ...
I'm in need of a WooCommerce expert who can help with the maintenance and troubleshooting of my online store. Key Responsibilities: - Troubleshooting errors: I need someone who can identify and fix the issues that arise in my WooCommerce store in a timely manner. - Ad-hoc maintenance: The role will be primarily on an as-needed basis. Whenever there's an issue, I'll need you to be available to troubleshoot and resolve it. Ideal Skills & Experience: - Proven experience with WooCommerce: You should have a solid track record of working with WooCommerce and handling troubleshooting tasks. - Strong problem-solving skills: The ability to identify errors and find solutions quickly is essential. - Availability: Since the role is primarily on an as-ne...
I am seeking an Arduino programmer with specific expertise in ESP32. The nature of this project requires the development of functionalities that can enable event scheduling in the ESP32 environment. Iot will send a schedule to the device. The schedule will look something like this CO2 2% 1 hour 20 minutes, CO2 0% 2 hour 0 minute, CO2 3% 1 hour 30 minute. The code already controls the CO2 levels to that percent. The problem we are having is running the schedule. So with the CO2 level there is a setpoint. That part works fine. You give it the setpoint and it maintains that level of CO2. However we need it to change the setpoint after x amount of time has elapsed and then change the setpoint again after another x amount of time has elapsed etc...We have a real time clock on ...
...the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the detail of the record. Simultaneous connection with all configured and active API connectors must be possible, with clear indicators of success or error, considering 3 retries if the source rejects the connection. Finally, the information obtained from all sources can be queried from the frontend where the source of information for each record must be clear, and a functionality to visualize this information in a table with filters and sorting, or directly from the backend through a JSON API. When performing a new sear...
I need to convert a complex PDF file into AutoCAD 2021. The original document contains a number of layers and dimensions that need to be accurately transcribed. I prefer working with someone who is comfortable with video calls as I will need to communicate and request revisions through this...need to convert a complex PDF file into AutoCAD 2021. The original document contains a number of layers and dimensions that need to be accurately transcribed. I prefer working with someone who is comfortable with video calls as I will need to communicate and request revisions through this medium. Your understanding of AutoCAD should be advanced to ensure that the converted file is precise and error-free. Additionally, promptness and responsiveness to video call meetings is crucial for thi...
I'm looking for a skilled web scraper to handle challenging websites with advanced detection. The main data you will be required to scrape is text content. Here are the key project details: Ideal...skilled web scraper to handle challenging websites with advanced detection. The main data you will be required to scrape is text content. Here are the key project details: Ideal candidate should have: - Experience in web scraping, especially from challenging sites - Strong knowledge of web scraping tools and techniques - Proficiency in handling advanced automation detection - Excellent attention to detail to maintain a high level of data accuracy - Ability to deliver monthly updates in a timely manner Please include any relevant past experiences or examp...
I'm looking for a professional videographer to produce a documentary-style video of interior design of building, focused specifically on showcasing its interior and architectural design. Key Re...documentary-style video of interior design of building, focused specifically on showcasing its interior and architectural design. Key Responsibilities: - Produce a documentary-style video of the building - Skillfully capture and highlight the interior design - Ensure high quality video production standards are met Ideal Skills and Experience: - wide angle, camera handling experience -Proven experience in documentary-style video production - Proficient in capturing architectural designs - Understanding of video production standards and techniques Note: The project doe...
I'm seeking a Wordpress expert to handle a one-time website maintenance task. The job involves fixing an error on my Wordpress site. Key Responsibilities: - Identifying the root cause of the error. - Implementing the necessary fix to rectify the issue. Ideal Skills and Experience: - Proven experience in resolving Wordpress website errors. - Strong understanding of Wordpress, plugins, themes, and overall website structure. - Excellent troubleshooting skills to quickly identify and resolve the issue. - Ability to work efficiently and deliver the solution promptly.
...the mapped information to standardize the response from all external sources to be configured. The results will be displayed independently in each API connector created in a table viewer as it comes from the source to perform mapping within the detail of the record. Simultaneous connection with all configured and active API connectors must be possible, with clear indicators of success or error, considering 3 retries if the source rejects the connection. Finally, the information obtained from all sources can be queried from the frontend where the source of information for each record must be clear, and a functionality to visualize this information in a table with filters and sorting, or directly from the backend through a JSON API. When performing a new sear...
... Key Requirements: - 5kW Power Output: The inverter should be capable of handling 5kW of power, suitable for residential usage with inductive loads. - Battery Backup Compatibility: It must be designed to work with a battery like lead acid and LifePO4 battery of 48V which will be a 16 string LifePO4 battery.. This is crucial for ensuring uninterrupted power during times of outages or low sunlight. -Tgere whouxl be an lcd screen to do settings and check status. - Residential Suitability: The inverter should be designed for residential environments, taking into account factors like space constraints, noise levels, and ease of installation. Ideal Skills and Experience: - Solar Inverter Design: Experience in designing solar inverters with battery backup compatibili...
I'm desperately requiring some expert help with my FreeScout application...desperately requiring some expert help with my FreeScout application within RunCloud. Unfortunately, unidentifiable issues have been causing havoc for less than a week now. I don't have any specific error messages to guide troubleshooting, so a diverse skill set is required - someone who can identify the issue and implement the required fix promptly. Ideal Skills and Experience: - Extensive knowledge in FreeScout Application and RunCloud environment - Proven troubleshooting and diagnostic experience - Exceptional skills in problem-solving, particularly for cloud-based applications - Experience in the resolution of varied software issues. The task, I believe, will need to be ...
Need someone to help in simple bug fixing error who has experience in android apps and knowledge about it Requirements are Coding skill Android knowledge
I need assistance in converting a PDF file to Word for the purpose of editing its content. Specifically, my focus lies on the conclusion section of the document, which requires careful handling due to the presence of complex charts. - Main task: Convert PDF to Word, while retaining original formatting - Important: Special attention to edit the conclusion part - Skills required: Proficient in Microsoft Word, conversion software, and chart interpretation. Your proficiency in understanding and handling similar conversion tasks and ability to edit complex charts will be critical in ensuring this project's completion to high standards.
