Word macro vbaงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
2 document to Translate from English to Thai 1. 930 word 2. 717 word ไฟล์ส่งให้อีกทีนะคะ
I need assistance with a data entry project where handwritten documents need to be accurately typed into Microsoft Word. Key Requirements: - Data entry: The task primarily involves typing data from handwritten documents into Microsoft Word. Accuracy is crucial. - Time efficiency: The project has a deadline, so the freelancer should be able to complete the task within the given timeframe. - Formatting: The final data needs to be well-structured and presented in a clean manner. Ideal Skills: - Proficiency in Microsoft Word. - Excellent typing speed and accuracy. - Previous experience in data entry, especially with handwritten documents, would be a plus. - Attention to detail and ability to maintain formatting consistency. This project is perfect for someone who is me...
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...
As we chatted about: I have a large Word document (57 pages / 8,046 words) that requires a meticulous conversion to HTML. It's imperative that this conversion maintains the document's original presentation. Key aspects for this project include: - The HTML output must mimic the original Word document's structuring and formatting. - Special attention has to be given to making it match exactly to the Word document. This includes font type, size and spacing. note there are images as well to be included. - It will need to be mobile friendly as such. - An excellent understanding of HTML, CSS and Microsoft Word is vital. - Strong experience in converting documents from Word to HTML is desired. Applicants should be proficient in work...
I have a Word document that needs comprehensive editing, including correcting typos, ensuring consistency of fonts, font sizes, and styles, re-formatting structure, and modernizing images and layout. Additionally, I'm looking for a professional who can update the branding of the document. Key Responsibilities: - Correcting typos and grammatical errors throughout the document - Ensuring consistency of fonts, font sizes, and styles - Reformatting the document structure for better readability and flow - Modernizing images and layout to give a fresh, updated look - Creating new branding guidelines and applying them to the document Ideal Skills & Experience: - Proven experience in comprehensive editing, copy editing, and document formatting - Strong understanding of branding ...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
I need a proficient Microsoft Word expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's crucial th...
I'm in need of a professional who can perfectly format my 100-page Word document. The document requires: - Adjusting the page layout - Ensuring consistent and appealing font styles and sizes are used throughout - Ensuring all tables are well-formatted and visually appealing In your application, please focus on showcasing your experience in Word document formatting. I don't need any graphics or images inserted into the document, just a clean and consistent format.
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
tenho um trabalho com 40 paginas, grande parte em figuras e tabelas que preciso converter de word para latex...já tenho um modelo da ufpr.
PDF File converted to MS WORD File more than 300 pages Need ASAP
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I'm in need of a professional who can re-write Arabic text from screenshots into a Word document while maintaining the original layout. Key Requirements: - Your main task will be formatting the text, and ensuring it matches the original layout. - The text you'll be working with is roughly 500 to 1000 words in length. Please note that this project will involve working with an Arabic text, so excellent Arabic language skills are a must. In addition, proficiency in Word is necessary in order to accurately replicate the original layout.
I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content - Strong communication skills to understan...
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
I'm looking to set up a Google Word document with basic editing and formatting options and collaboration capabilities for a small team of less than 5 people. Key requirements include: - Basic editing and formatting options: This involves simple text formatting and the ability to create lists. - Collaboration and sharing capabilities: The document should allow for easy sharing with my team and enable simultaneous editing by multiple users. Given the scale of the team and the simple level of formatting required, I'm looking for a freelancer who is experienced with Google Word documents. It's important for the freelancer to ensure smooth collaboration and user-friendly interface. A good understanding of document sharing settings would also be a plus.
I'm looking for a talented game developer to create a captivating word search game for mobile platforms, specifically iOS and Android. This game is intended to be highly detailed and animated, so experience with creating visually engaging mobile games is a huge plus. Key Requirements: - Development for Mobile Platforms: The game should be compatible with both iOS and Android, ensuring a wide audience reach. - Visual Excellence: The game is expected to have highly detailed and animated graphics. A strong portfolio showcasing similar work would be highly beneficial. Optional Requirements: - Social Features: While I'm open to the idea of incorporating social features within the game such as leaderboards, player profiles, or in-game chat, this is not a strict requirement. ...
I need a macro tool that can automatically send predefined messages to Telegram. I would like to implement the ability to send messages to Telegram groups without using Telegram bot. MOST IMPORTANT WITHOUT BOT It must be developed in Python. Key Requirements: - The tool should be designed to work on Windows operating systems. - It should be triggered by a specific keyboard shortcut. - The ability to send both text and media messages is essential. Ideal Skills: - Proficiency in Windows macro tools development - Experience with Telegram API - Strong understanding of media file handling in macro tools Please bid if you have the relevant experience and skills for this project.
I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
More details: Is this project for business or personal use? For an existing business What is the main objective of your SEO campaign? Increase website traffic Which type of SEO do you need? On-page SEO, Off-page SEO, Technical SEO Target to achieve SERP position 1 for company's Keywords
I am in search of an experienced professional to craft a concise and engaging company profile for my business. The profile should be in a Word document format and should be between 1-5 pages in length. I specifically want to highlight the following: - Company History: A succinct yet informative overview of our journey, achievements, and milestones. - Products/Services: Detailed descriptions of our offerings, emphasizing their unique features and value propositions. The ideal freelancer for this job should have a good grasp of business language and a proven track record of creating effective company profiles. Excellent writing and Word formatting skills are also essential. Previous experience in my industry will be an added advantage.
I am seeking a proficient resume writer experienced in creating professional, eye-catching resumes, specifically targeted towards a regulatory role. I have over a decade's worth of relevant experience for the prospective role(s) I will be applying for. Following are the specifics: - Drafting a Word document - Accentuating my experience of over 10 years in customer relations and regulatory roles - Presenting a compelling case for my candidacy for an environmental compliance officer role. The ideal professional for this task would be someone with proven experience crafting professional managerial resumes, with a keen eye for detail and impressive design skills. Excellent command over language and significant understanding of the corporate managerial world would put you at the...
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
I have a Microsoft Word document that needs to be converted into a PDF. This is a straightforward task. However, I need the final PDF to have a custom layout design. Key Requirements: - Convert Microsoft Word document to PDF - Implement a custom layout design in the PDF Ideal Skills: - Proficiency in Microsoft Word and PDF conversion software - Experience in graphic design or document formatting - Attention to detail and adherence to the provided layout design Please let me know your experience with similar projects and how you would approach this task.
I'm in need of an individual with a strong academic background in accounting. The project will involve outsourcing analysis and interpretation. This is specifically for a graduate level academic project. Key requirements include: - Strong understanding of accounting principles - Experience and knowledge in outsourcing analysis - Previous experience in academic writing, specifically in accounting - Ability to deliver high-quality, graduate-level analysis Please include any relevant experience and samples of your previous work in your proposal.
I have a medium-sized data entry project which requires entering between 100 to 1000 entries. The data to be entered is primarily textual in nature. This project involves: - Entering textual data into a specific format Ideal Freelancer: - Attention to detail - Proficiency in data entry - Fast and Reliable - Experience with medium-sized data entry projects
I have a PDF document that I need converted to a Word document. After the conversion, I'll need you to add three pages of purely textual content to the document. Additionally, I want you to create a petition document for signatures. The petition should be designed for manual signing, not digital. Key Responsibilities: - Convert a PDF document into a Word document. - Add three textual pages to the converted document. - Create a petition document for manual signatures. Ideal Freelancer: - Should have experience with document conversion and editing. - Ability to design a petition document. - Familiarity with creating documents for manual signatures. - Good communication skills to ensure the job satisfies my requirements.
...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...
Hi Nasima, about a year ago you delivered a ver simple logo for a company named Eduna. I'm restarting that project and I need a proposal template (a word document that i can use to deliver proposal) with a nice header and footer related to events planning , wedding planning , table decoration, etc.
I'm in need of someone with excellent Word and contemporary design skills to type an attractive, clean-cut, and professional 2-page resume. Key project requirements include: - Utilizing a modern design style while maintaining professionalism - Including sections to outline my Work Experience, Education, and Skills - Overall tone and style of the resume should exude professionalism. Ideal freelancer should have a great eye for modern design aesthetics and possess strong Word formatting skills. Prior experience in modern professional resume creation is preferable. Please include samples of your previous work in your bid.
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
I have a Word document that contains some text which needs to be copied to a specific location. The text is to be copied from a Word document, so you must be proficient in working with Word documents. Specifically you should be able to: - Open and extract text from a word document - Have a basic understanding of formatting in Word - Be able to handle document errors or formatting issues The text is going to be pasted to a specific location so you should have: - Good attention to detail - Precision in copying and pasting text - Ability to follow instructions accurately This is a simple project that requires precision and attention to detail. You must be able to follow instructions carefully.
I have a Microsoft Word document that needs to be converted into a PDF. This is a straightforward task. However, I need the final PDF to have a custom layout design. Key Requirements: - Convert Microsoft Word document to PDF - Implement a custom layout design in the PDF Ideal Skills: - Proficiency in Microsoft Word and PDF conversion software - Experience in graphic design or document formatting - Attention to detail and adherence to the provided layout design Please let me know your experience with similar projects and how you would approach this task.
I'm in need of a skilled freelancer to convert a PDF document to a Word file. The primary purpose of this conversion is to enable content editing within the Word document. The PDF in question is straightforward in layout, containing simple text without complex elements like images or tables. Your job will be to ensure this text is accurately transcribed to a Word file while preserving the original formatting.
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...
I'm seeking an admin familiar with Word 2019. - Update over 10 documents: I have numerous documents which need logo replacement and formatting. - Footer Addition: Your job will also include adding a footer with a numbering system to each document. Ideal candidate should have: - Proficient in Word 2019 - Experience in document formatting - Basic graphic design knowledge - Attention to detail.
I have a 5 page contract in PDF format that I need transferred to Word. It's important that the text is transferred exactly as it appears in the PDF. The Word document should be editable, so I can make any necessary changes in the future. Ideal skill set for this job includes: - Proficiency in PDF and Word processing - Attention to detail to accurately capture the original formatting - Strong understanding of Microsoft Word's functionalities Please ensure your bid reflects your experience in similar projects and your ability to meet the requirements.
I am in need of a professional to convert a set of 6-10 PDF files into Word. Key Requirements: - Timely Delivery: There is a specific deadline for this task. - Accuracy: Ensure that the content is transferred accurately without any loss or errors. - Formatting Preservation: Maintain the original formatting of the documents. This project would be ideal for someone experienced in document conversion and proficient in both PDF and Word. If you have experience in data entry, this could also be a beneficial skill to bring to this job.
I need a professional to convert my 1-page Word document into a .dotx file. This form needs to be minimalistic and easy to fill out. Key Requirements: - Convert an already laid out Word document into a .dotx file. - Include content control fields for a date picker, checkboxes, and empty text fields. - Design the form in a minimalistic and professional manner. Ideal Skills and Experience: - Proficient in Microsoft Word and creating fillable forms. - Knowledge of .dotx file format. - Experience with content control functions in Word. - Ability to design simple and professional forms. - Attention to detail to ensure the form is user-friendly. Please provide examples of similar work in your proposal.
I have less than 50 PDF documents that I need converted into Word. The PDFs are more than just plain text, they contain images and tables. It is important to keep the original formatting as it is in the PDFs. Key requirements include: - Converting less than 50 PDF documents into Word - Handling PDFs that contain both text and images/tables - Keeping the original formatting of the content Ideal freelancer: - Proficient in data entry and familiar with PDF to Word conversion - Able to maintain the original formatting - Detail-oriented to avoid missing any elements of the PDFs. Please bid if you are confident you can deliver the work with high quality and accuracy.
I need a skilled editor to handle a 11-20 page document. Mostly, indentation formatting. Very simple, I just need this document to be clean, organized and professional looking.
I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Work Phase: This is a custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and unders...
...expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with real estate or property development would be a plus, but not essential. Please provide e...
