Protect vba code excel dllงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
พอดีผมเปิดขายโปรแกรมๆหนึ่งในต่างประเทศให้คนกลุ่มเล็กๆ แต่มีบางกลุ่มพยายาม Crack ไฟล์ผม ซึ่งผมรู้สึกว่าตอนนี้โปรแกรมของผมมีระบบเช่าโปรแกรมที่ไม่ดีพอ เนื่องจากเป็นการเช็คสตริงธรรมดาในphp ผมอยากได้ระบบเช่าโปรที่ดีกว่านี้ มีความปลอดภัยมากขึ้น ไม่ต้องมีหน้าเว็บ เพราะเป็นการเช่ากับผมโดยตรง อีกอย่างครับ ผมฉีด Dll โดยการใช้ SetWindowsHookEx มีวิธีการซ่อน Module หลังจากฉีดไปแล้วมั้ยครับ ผมอยากให้โปรแกรมปลอดภัยมากที่สุด เข้าใจครับว่าไม่มีวิธีไหนที่กันได้ 100% แต่ผมอยากให้โปรแกรมผมปลอดภัยมากที่สุด
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี Source code เกมส์อยู่แล้ว ซึ่งซื้อมาจาก Unity assert store แนว MMORPG (Offline) Link !/content/15552 มี Demo ให้ทดลองเล่นอยู่ครับ โดยความต้องการของผมมีดังนี้ครับ 1. สามารถมองเห็นความเคลื่อนไหวของตัวละครในเกมส์ของผู้อื่นได้ (Animation network) เช่น เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Firstly, I want to know if what I am asking can actually be created in Excel 365. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in t...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...
...validation and quality checks to identify and rectify anomalies. Documentation: * Create documentation for data conversion processes, including data dictionaries, flowcharts, and technical specifications. Testing and Validation: * Plan and execute data conversion testing, including unit testing, integration testing, and user acceptance testing. Data Security: * Implement data security measures to protect sensitive and confidential information. * Ensure compliance with data privacy regulations and company policies. Job Requirements: * Bachelor's degree in Computer Science, Information Systems, or a related field. * 8+ years of industry experience, with at least 2 years in Oracle Cloud Fusion projects. * Proven experience as a Data Conversion Developer with a focus on Oracle E...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We're looking for a competent native English writer or editor to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with revising a trial article (paid).
I have an Excel sheet that requires daily data analysis using statistical methods. Key requirements: - Daily updates: The data in the Excel sheet will need to be analyzed using statistical methods and techniques on a daily basis. - Statistical Analysis: The main focus of the analysis will be on statistical methods. You'll be required to utilize various statistical tools to interpret the data and provide insights.
...distribution of BTC funds, allowing users to connect their wallets, initiate automatic payments, and convert funds into USDT or other cryptocurrencies. **Project Details:** - Develop a Crypto Host platform with robust support for Bitcoin (BTC) transactions, including wallet integration, automatic payment setup, and currency conversion functionalities. - Implement advanced security measures to protect users' BTC funds and personal information, ensuring compliance with industry best practices and regulatory requirements. - Design a user-friendly interface that enables seamless navigation, account management, and transaction tracking for users of all experience levels. - Integrate with external APIs and services for real-time exchange rate data, liquidity provision, and transa...
I need a Python code developed for vehicle route optimization. - The code should include 3 algorithms for route optimization. - Successful freelancers should include past work in the application. Ideal Skills: - Proficiency in Python - Experience in developing route optimization algorithms - Strong background in data analysis, web scraping, and machine learning, as these functionalities will be required in the project.
I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic das...
I am looking for a detail-oriented professional to assist me in transcribing text data from Word Documents into an Excel sheet in alphabetical order. Specifically, you will be: - Handling text data from Word Documents - Accurately typing this data into an Excel sheet - Organizing this data alphabetically to aid in easy referencing Experience with data entry and a strong grasp of Microsoft Word and Excel is mandatory. I expect high attention to detail to ensure accuracy in data transcription and organization. Please submit your proposals detailing your relevant experience.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
...the website is mobile-friendly and responsive across various devices and screen sizes. 8. **User Management**: - Implement a user management system allowing users to register, login, and manage their profiles. - Provide account management features such as password reset, email verification, and profile editing. 9. **Security Measures**: - Implement robust security measures to protect user data, prevent unauthorized access, and secure transactions. - Utilize encryption protocols, secure authentication methods, and best practices in web security. 10. **Performance Optimization**: - Optimize website performance to ensure fast loading times and smooth user experience. - Minimize HTTP requests, optimize images, and utilize caching techniques to impro...
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...
I'm in need of an Excel expert who can help me perform basic arithmetic operations for financial calculations. The purpose of the sheet is to analyze simple financial data, so you should have a good understanding of basic financial concepts. Key requirements: - Perform basic arithmetic operations in Excel for financial data. - Create standard tables and charts to present the analyzed data in a clear and comprehensible manner. The ideal freelancer for this job will: - Have a strong background in Excel, particularly in handling financial data. - Be able to create visual representations of data using standard tables and charts. - Be able to efficiently and accurately perform basic arithmetic operations in Excel.
Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...
I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided numerical data, organized in a tabular format.
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
...hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantageous.
For this crucial ...Key Responsibilities: - As I've got an EC2 server in place, I am seeking to fortify the security measures associated with it. - Although I've not finalized the specific measures, your expertise and suggestions in IAM, Security Groups, or Network Access Control Lists (NACLs) would be greatly appreciated. - Emphasis on ‘Advanced Security Setup’ – a step beyond basic security – to comprehensively protect server's integrity. Ideal Skills: - Proven experience in AWS server security, specifically EC2. - Proficiency with IAM, Security Groups, NACLs. - In-depth AWS server security acumen. I'm excited to collaborate with a security-savvy AWS developer to take my EC2 server's security to the next level. Note: Only App...
...homeowners and businesses. The ideal candidate would be proficient in market research with experience in the specific industry, customer profiling, and an understanding of energy appliances. Knowledge of the local market is crucial. Your insights will shape our market strategy, so accuracy and attention to detail are paramount. Deliverables: Comprehensive report with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project....
I'm looking for a skilled PHP developer to create a code editor plugin. The plugin should replicate the functionality of the Shopify code editor, offering Syntax Highlighting, Auto Complete, Error Detection, and supporting both HTML/CSS and PHP languages (PHP support is optional). The plugin is intended to be a standalone component, not embedded or replacing any existing editor. the editor should include a file search (to search through templates) - similar to shopify but as well as searching filenems it shoudl also search in contents The editor shoudl work with a master theme/child theme style system such that when a template is modified its auto-copied to the child theme Key requirements: - Develop a code editor plugin similar to Shopify's - Implement Sy...
