Excel vba read text file line by line työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Your task is to design automated solvers for the shift and Vigen`ere ciphers. You must use C as the underlying programming language, in order to get prepared for the following assignments. Each solver should be completely automated, i.e., upon reading a text file containing the target ciphertext (given as command-line argument), it should print the encryption key and the decrypted plaintext without any user interaction. Test your code on the following ciphertexts, and answer these questions: (a) What is the key of the cipher? (b) What is the decrypted plaintext? Ciphertext 1 (shift cipher) ODKBFAXASKBDQEQZFEMPURRUOGXFKZAFRAGZPUZZADYMXMOMPQYUOPUEOUBXUZQEFTQZQQPRADFTQBDABQDUZFQDM OFUAZARODKBFASDMBTKMZPODKBFMZMXKEUEFTUEMDUEQEAGFARFTQRMOFFTMFUZFTQMNEQZOQARDQMXOAYYGZUOMF UAZEDQC...
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
fsssggaaaayyyyyyyyaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaauuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
fsssggaaaayyyyyyyyaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaauuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help
...and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the Excel...
We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...
I'm in need of a knowledgeable Linux and AWS expert to assist me with various tasks related to command-line operations, system administration issues, and application support using AEM admin console. Key Requirements: - Strong command-line skills: You should be proficient in using the Linux command line for a variety of tasks. - System Administration: Experience in Linux system administration is essential, as I need assistance with file management, user management, and package management. - AWS Services: Familiarity with AWS services, particularly the AEM admin console, is a must. The ideal candidate for this role should possess a deep understanding of Linux, system administration, and AWS services to provide timely and effective job support.
I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes
I am in need of an experienced individual to help with data collection for my business. Unfortunately, I didn't complete the form, but here's a more detailed overview of what I need: - I require a variety of data to be gathered, which may include customer information, product details, and sales information. Having a background in managing these types of data will be essential. - The purpose behind this data collection process is to strengthen my business strategies. Your ability to interpret data and draw actionable insights from it will be crucial in this project. - The method of data collection may vary. It could involve online surveys, in-person interviews, social media monitoring, or even a combination of these. Therefore, your experience with diverse data collection metho...
I'm seeking a talented data scientist specializing in ship engine assembly to analyze key parameters and offer process insights. Key Parameters and Metrics: - **Efficiency:** Analyze the efficiency of our ship engine assembly processes. - **Performance:** Look into the performance metrics of the assembly line. - **Reliability**: Assess the reliability of our ship engine assembly. Process Insights: - **Workflow Optimization:** Provide insights and recommendations on how we can optimize our workflow for better efficiency and productivity. - Collect datasets for llmRAG and embedding vector database - You should choose the models for llms and RAG and frameworks Ideal Skills: - Proven experience in data science, particularly in the manufacturing industry with a focus on ship en...
Pdf to word file typing i wan a professional typer to do this
German Recording project We have a project, that needs Native German speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 8$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
France French Recording Project We have a project, that needs Native France French speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
I'm looking for a professional to help me modify text and images in an AI file. I need someone to do this RIGHT NOW, If you have the time now to sharescreen and get it done in 30 mins or so. PING me or else don't bother please. I already have the AI file ( restaurant Menu )
I need a professional who can convert a 1-10 page PDF document into a fully editable Word file. The main purpose of this conversion is to be able to easily edit and update the contents of the document as needed. Key requirements: - Conversion of a 1-10 page PDF file into an editable Word document. - Retaining the formatting of the original PDF to ensure the Word file looks professional. - Including images from the PDF into the Word document, maintaining their quality and positioning. Ideal skills and experience for this project: - Strong experience with PDF to Word conversions. - Proficiency in Microsoft Word and a good eye for detail to ensure the final Word file is accurate and retains the formatting of the PDF. - Experience with handling images in Word docu...
I'm seeking a talented UX/UI designer with a strong portfolio of clean and professional designs, specifically for both desktop and mobile platforms. Key Responsibilities: - Create user-centric, intuitive designs that deliver a seamless experience on both desktop and mobile. - Ensure a clean and professional look and feel, in line with my preference. - Understand and interpret the project requirements to create visually appealing designs. Ideal Skills and Experience: - Proven experience with UX/UI design for both desktop and mobile. - A strong portfolio that showcases clean and professional designs. - Familiarity with creating user-centric designs. - Ability to interpret project requirements and translate them into visually appealing designs.
I am looking for an expert to build a text-to-speech converter specifically for the Hindi language. This project doesn't require different voice options for males and females. What the project entails: - Hindi language support only (written and spoken) - Text-to-speech functionality with a female voice (“Girl Voice”) Ideal skills for this job: - Experience in voice recognition technology - Fluency in Hindi language - Previous work with text-to-speech converters.
I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.
I'm seeking a skilled and creative logo designer to help create a unique and captivating logo for my business. The logo should incorporate the below criteria: - Usage of bold and vibrant colors to ensure the logo stands out and grabs attention. - Both text and image should be utilized in the design, creating a seamless integration and balance between the two. Ideal skills and experience: - Proven experience in logo design with a strong portfolio showcasing previous work. - Proficiency in graphic design software. - An understanding of color theory and a knack for employing bold, vibrant colors effectively. - Creative flair, originality, and a strong visual sense. Please note, I didn't specify a style preference. As a result, freelancers should feel free to apply the...
I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and...
...recordings "Bossa Antigua" by Paul Desmond. The tracks contain 4 instruments. Proficiency in audio editing, specifically with separating layers and isolating sounds, is preferred. Here are the specifics: - Deliverable: Isolated instrument soundtracks - Expertise needed: Audio editing, sound isolation - Input format: WAV - Number of instruments to be isolated: 4 (Keys, ALTO SAXOPHONE, Drums, Bass) - Clear understanding of different instrument sounds is highly desirable This project requires the ability to distinguish between sounds and isolate them individually. It is essential to preserve the sound quality while separating the instruments from the audio layers. A good ear for detail and purity of sound is important. The deliverable MUST PRESENT a clear accompaniment ...
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this iss...database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL -> PHPMyAdmin. Here, you can directly view and edit the data in your tables and ensure that all date and time values are correctly formatted. I also may have more work as well. I want to also Improve on my site design and features. But I need to get this Issue Resolved fast. It is making my site go off line. So I first only want to get a Quote to fix this proble...
Project Description: We are see...Provided upon project commencement Style: To be in line with our existing brand guidelines (bright, engaging, informative) Offer on Card Design Size: 10.5 cm width x 14.8 cm height Reference: Reference in attached Photo as well Details to Include: Name, position, contact information, and logo Deliverables: Final designs in PDF format Open files in Adobe Illustrator or Photoshop format Skills Required: Proficiency in Adobe Creative Suite, especially Illustrator and Photoshop Experience in brochure and business card design Ability to translate brand identity into visual design Excellent communication skills and responsiveness Budget: Exactly as stated on the job here. Deadline: First draft within 2 days of project commencement Final deliverable...
...corporate website and company profile for my business. Here are some key details to consider: Company Profile Elements: - I'll provide the content, but I need a designer who can expertly lay it out and create a visually appealing profile. - The profile should include sections on our company history, product/service descriptions, and team bios. - The designer will need to ensure the design is in line with a professional and corporate aesthetic, incorporating a clean and sophisticated look. Web Design: - The website design should mirror the company profile in terms of style and theme. - It should be user-friendly, engaging, and optimized for mobile viewing. - The designer will need to have a keen eye for detail and be able to create a seamless user experience. Ideal skills ...
necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I have a large volume of both text and numeric data that I need inputted into Microsoft Excel. Here's what I need: - Accurate entry of the text and numeric data - Scaled to handle a large quantity of data - Flawless use of Microsoft Excel for data entry Ideal candidates will be detail-oriented, proficient in Excel, and able to handle a large volume of data. Proven data entry experience would highly be beneficial for this task.
...skilled graphic designer to create a visually engaging poster for printing. Here are some key details to be aware of: - Size: I'm considering printing the poster as A4, A3, or A2. I'm open to suggestions based on what will best suit the design (please feel free to advise on this). - Design: I would like the poster to be a combination of text and images. I will provide the images for use, so the task will involve the placement of these images alongside the text content. I'm looking for a design that's not only aesthetically pleasing but also effectively communicates the message. Ideal skills and experience for this task include: - Proficiency in graphic design and layout software - Previous experience in poster design - Ability to create visually app...
I have a PES embroidery file that I need to be modified. The current stitch in the design is not appropriate for the jumper I need to embroider. I require a satin stitch to be applied. Additionally, I need this design to be resized for medium jumpers, up to 6x10 inches. The urgency of this project is high, as I need the modified file within 24 hours. Ideal Skills: - Proficiency in embroidery file formats, specifically PES - Excellent working knowledge of satin stitch - Experience in resizing embroidery files accurately - Ability to work under tight deadlines
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm looking for a skilled video graphics designer to create an animated text video for social media. The purpose of this video is to inform viewers about a topic in a visually engaging way. Key Requirements: - Create animated text that is visually appealing and easy to follow - The video should be optimized for viewing on social media platforms - The theme of the video should be geared towards being informative Ideal Candidate: - Proficient in video editing and motion graphics - Experienced in designing for social media platforms - Creative and able to translate information into engaging visuals - Punctual and able to meet deadlines If you have experience in this field and can deliver innovative animated text videos, please get in touch with your portfolio. Yo...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
I require a talented freelancer to construct a text-based logo, along with an engaging introduction focused on emphasizing my company's mission and values. Additionally, I'm looking for the concept and design of formal business attire. Requirements: - Aesthetic and definitive text-based logo design. - Draft an introduction with captivation, mirroring our mission and values. - Original and professional designs for formal business attire. Ideal Skills: - Extensive experience with logo design and typography. - Excellent written communication for the introduction. - Creativity and expertise in formal attire design. - Understanding of the apparel industry's current trends. - Proactive, innovative and deadline-oriented. And providing the type of logo we nee...
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should ...
I'm seeking a PowerPoint expert to create a persuasive presentation aimed at business professionals. The structure should be in line with a board level presentation. Key Project Details: - Objective: The main goal of the presentation is to persuade the board of should be engaging, convincing, and impactful. - Target Audience: The presentation is specifically designed for top excutives. Hence, it should be tailored to their level of understanding and interests. - Structure: The presentation should follow a board level format, ensuring that it is comprehensive, insightful, and valuable. Ideal Freelancer Skills: - Proficiency in PowerPoint: The freelancer should be well-versed in creating compelling PowerPoint presentations. - Understanding of Persuasion: A good grasp of persu...
I need the following arrangement transcribed for SA choir plus piano: The attached pdf should be helpful to copy for the piano accompaniment and the melody line.
I'm seeking to upgrade my existing 6.2 kW solar system. I need assistance with redesigning the system by adding four new panels. Additionally, I require the completion of the one-line diagram and approval from both a structural engineer and an electrical engineer.