Vba emailnotify projectPekerjaan

I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should include ...

...Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. Expected Deliverables: • A practical and intuitive Excel-based tool that allows: • Budget planning and tracking based on WBS, tasks, and activities. • Monitoring expenses against the budget. • Generating clear and customizable reports directly in Excel. • Comprehensive documentation explaining the tool’s functionality and usage. Selection Criteria: • Proven experience creating advanced Excel tool...

Option Explicit Type Authvalinterval Lower_Val As String * 40 Upper_Val As String * 40 End Type Type AUTHVALINTERVAL_TAB wert(1 To 10) As Authvalinterval End Type Type AUTHFIELD_VALS fieldname As String * 10 fieldvals As AUTHVALINTERVAL_TAB End Type Type AUTHORIZATION_TAB AUTHORIZATION(1 To 10) As AUTHFIELD_VALS End Type Type AUTHORIZATION_FOR_OBJECT xuobject As String * 10 AUTHORIZATIONS As AUTHORIZATION_TAB End Type Global IT_ROLE_AUTHS(1 To 100) As AUTHORIZATION_FOR_OBJECT Global sapSystem As Object Global sapFuBa As Object Global sapLogon As Object Global sapConn As Object Global sapReturn As Object Sub RolleAnlegen() Dim wert As Object Dim rolle As Object Dim sapObjekt As Object If InitConnection Then Se...

I'm in need of a proficient Excel VBA developer to create a high-performance data logger for me. The primary function of this tool is to log data from a wireless barcode scanner, record weight, and convert that weight into quantity. Key Requirements: - The logger must access conversion data from a sheet that could have over 200k lines. - A more efficient version is needed compared to an existing sample I have. The current version is sluggish due to file size. - It should support multiple users on a local network, compiling all results into a single sheet without missing any lines. - The project has a fixed budget, which is not based on hourly rates. Ideal Skills and Experience: - Extensive experience with Excel and VBA, particularly in creating userforms. - Prev...

I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...

Excel VBA Macro for Data Capture & Email **Job Title:** Excel VBA Developer Needed for Automated Screenshot and Email Generation Task **Description:** We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks: 1. **Country-Based Data Selection**: - Read a country name selected in one sheet (e.g., "CountrySelection" sheet). - Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed. 2. **Dynamic Data Range Capture**: - Identify the relevant row and its associated columns dynamically. - Capture this data as a screenshot or export it as an image. 3. **Email Integration**: - Embed the screenshot/image into the body of an em...

I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...

I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant. Key Requirements: - Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1. - The macro should prompt for confirmation before updating Tab 2. - All fields in Tab 1 should be completed before the update. - The macro should not overwrite existing rows in Tab 2. Ideal Skills: - Proficient in VBA programming. - Excellent understanding of Excel macros. - Able to create intuitive and user-friendly macros. This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the macro. Please in...

I'm looking for a skilled Python developer to create a script in PyCharm for me. The script needs to load a CSV file with specific headings: Brand, Product Name, Price, EAN/UPC/ASIN. Key Requirements: - The s...Output: - The final report should include: Brand, Product Name, Price, and Number of Bought Items. Ideal Skills and Experience: - Proficient in Python and familiar with PyCharm. - Prior experience with web scraping, particularly from Amazon, is a big plus. - Understanding of CSV file handling in Python. - Ability to deliver a clean, well-documented script. Issues i have faced while doing this in VBA: - amazon dont like more than 50 pings to their website - i made it stop once it get the error screen - sometimes no item identified , so i just skipped it as its not pr...

I want to list a product using sp-api in VBA. You must have your own credentials for development

I'm looking for an experienced Excel VBA developer to create a macro that will help me automate repetitive tasks, specifically report generation and data consolidation from my inventory data. Key aspects of the project: - The macro should be able to automate the generation of reports from the data - It should also assist in consolidating data efficiently - The macro will primarily be working with inventory data, so understanding of this type of data will be beneficial Ideal skills for this project include: - Proficiency in Excel and experience in creating macros - Strong understanding of inventory data - Ability to automate tasks efficiently - Experience in report generation and data consolidation

I'm seeking a highly skilled Excel professional to help me with an Arabic Excel file. The project primarily involves: - Automating tasks with VBA: I want to streamline our processes, so your VBA expertise will be key to helping us work more efficiently. - Data cleaning and transformation with Power Query: The data we have is not entirely clean, so your experience with Power Query will be vital in preparing our data for analysis. This Excel file is primarily for business use, so a strong understanding of inventory data is beneficial. The ideal candidate will be fluent in Arabic and have extensive experience working with Excel, Power Query, and VBA.

I'm in need of a professional who can help debug our existing VBA program that interfaces with our internal Excel database. The original creator of the program has passed away, and we're currently trying to get it to work without any expertise in VBA. Ideal skills and experience for the job include: - Proficiency in VBA and Excel - Experience in debugging and troubleshooting complex programs - Ability to explain technical concepts in a simple, understandable way - Patience and understanding working with a team with limited technical knowledge

create analysis in power bi and VBA for a company the analysis will include report for weak point and strengths needed to improve prefomance

### Description: I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements: 1. **Interactive Scatterplot Chart:** - The scatterplot chart should display on a publicly accessible webpage. - Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically. 2. **Multi-User Support:** - Multiple users should be able to access the "Graph" sheet simultaneously. - Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions. 3. **B...

I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.

Tenho ums sitema proprio utilizando apenas a linguem vba e o banco de dados acces, atualmente emito nfce e nfe atraves do site do sebrae, mas quero automatizar utilizando apenas o vba e o openssl para a assintura digital para conseguir automatizar o processo. entao o que estou tentando fazer éutilizar um modelo de xml , editando os dados e adicionando os dados de mais itens conforme necessario, assinado digitamente atraves do openssl (isso eu ja tenho pronto, ja consegui estrair os dados e as sub que fazem este processo), falta a estruturação do xml e validação junto a asefaz.

In Microsoft Access database, I need some VBA to attach 3 forms to 3 SQL queries that already exist. I've started the forms, but they are not complete. Each query requires input from the user. I want the input to be captured on one form with the input fields required. On click of the button causes an Event that triggers the SQL with using the data input from the form. Key Requirements: - User Input: dropdown menus, checkboxes, and text fields. - Dropdown Menus: 3 or more dropdown predefined. - Event Triggering: SQL query using the data input from the form. Skills and Experience: - VBA - Microsoft Access - User-friendly forms - SQL (not required, but could be helpful)

Busco un profesional con experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Personalizaci...

I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.

I need an expert in Excel VBA to create a tool for me. Requirements: - Import specific row fields from a CSV file. I need to import Names and Addresses, Product IDs and Descriptions, Dates and Amounts, and other general things. - The import should be triggered by a menu option in the Excel toolbar. - There should be a print button to print the new sheet with the imported contents. Ideal Skills: - Proficiency in Excel VBA. - Experience with CSV file manipulation in Excel. - Ability to create custom toolbar options in Excel.

I'm seeking a professional with extensive experience in MS Access to assist me in creating a robust database. Ideal Skills: - Proficiency in MS Access - Experience in database design and creation - Strong understanding with data analysis, query building This is an urgent task, please bid if you are available to support immediately. Communication in English is must.

I need an Excel macro developed that can extract digital signatures from multiple PDF files and record them in an Excel file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the sign...file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the signer’s name and the time and date of the signature - The data should be organized in Excel with one row per document, and all signatures from that document in separate columns. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Experience with PDF data extraction - Strong attention to detail to ensure accurat...

...PowerPoint, and VBA programming. My goal is to create a PowerPoint macro that automatically generates a slide for each participant of a course, inserting their name and course date from an Excel file. Project Details: - Software: The project will be conducted using Microsoft 365. - Data Source: The macro will pull data from an Excel file, specifically participant names and course dates. - Template: I have a specific PowerPoint template for the slides; the freelancer will be provided with this template. Key Requirements: - Advanced knowledge of Microsoft 365, particularly PowerPoint and Excel. - Proficiency in creating and implementing macros. - Experience with VBA programming. - Ability to work with provided templates. Please note, my focus is on the func...

Highlight cell based on instruction sheet.

I have an Excel macro that needs updating. It currently processes text strings and I need it to add zeros to the beginning of each string to even out their lengths. Ideal skills for this project include: - Proficiency in Excel, particularly with macros - Strong programming skills, preferably in VBA - Experience with data manipulation, specifically with text strings Please bid if you have the relevant experience and can complete this project in a timely manner.

I need a VBA script that pulls historical stock data and option data from Google Finance into Excel. Requirements: - Historical stock data should include Adjusted Close prices. - Option data should include: Strike price and expiry date, Volume and open interest, Implied volatility. Ideal Skills: - Proficiency in VBA - Experience with data extraction from Google Finance - Knowledge of stock and option data parameters Please provide examples of similar projects you've completed. Thank you!

As discussed, VBA and form .

I'm seeking a professional with extensive experience in ERP development and Excel to create a standalone, Excel-based ER...ERP system for my business. The system needs to manage three key areas: - Inventory Management - Financial Accounting - Human Resources Key requirements: - The ERP system will be standalone and does not need to integrate with existing software. - User access control should be basic, with only Admin and User roles. Ideal skills for this project include: - Proficiency in Excel, particularly with advanced features like macros, pivot tables, and VBA. - Experience in developing standalone software. - Knowledge of ERP systems and their functionality. - Understanding of basic User Access Control systems. Please provide examples of similar proj...

I've developed a VBA template that needs thorough usability testing and improvements. The testing should focus on the user interface design, ease of navigation, and error handling. Additionally, I would like a review of the VBA codes to enhance code efficiency and debug any issues. I will message you on more details.

Employee Uniform Ordering System Objective: Create a system for employees to order uniforms and an admin dashboard for managing orders. Deliverables: 1. Order Form (Google Forms/Excel) with dropdowns for uniforms and sizes. 2. Admin Dashboard (Google Sheets/Excel) with order summaries and charts. 3. Aushang Design with QR code Skills Required: • Google Forms/Sheets or Excel with VBA • Data Visualization • UI/UX Design • Graphic Design

Creating a reporting template in Excel with VBA

I'm looking for a VBA expert who can help me with data analysis and reporting using Excel. The main focus will be on data visualization. The ideal freelancer should be able to: - Automate tasks in Excel using VBA - Create custom functions or tools tailored to my data analysis needs - Design and implement effective data visualizations The data will primarily be sourced from Excel spreadsheets. Previous experience with data visualization in Excel is crucial, as is a strong understanding of VBA. It is a secret code game for family fun, not for resale. I will provide 11 lines of letters maximum 400 in each line. Lines 1 to 11. I need a dialogue box with. A multiplier selection box whereby I can put in a number from 1-400 coinciding with the letter in each cell fo...

Tôi muốn thiết lập 1 bảng lãi suất tham chiếu theo lãi suất có sẵn, theo công thức của bên tôi. Nhờ các bạn lập giúp tôi và dạy tôi cách lập.

I need a VBA expert to create a Word/VBA/macro which turns selections in a Word document into dynamic hyperlinks. Background - Valid links start wit-h [aA] followed by numeral's A1683123/ A1686786  A916753 A916753 more text A916753 more text - VBA convert a to A - Anchor:=r1, Address:= _ "url:objective://id:" + RTrim() + "@", SubAddress _ :="", ScreenTip:="", TextToDisplay:=RTrim() - The issue is, in word, sometimes double clicking "A916753" will select "A916753 ". The hyperlink cannot contain the space. The hyperlink and display text, must only contain the valid text "A916753". Below is code that doesn't really work: Dim r1 As Range Dim str1 As String Dim ...

I need a skilled Excel VBA programmer to enhance my current Excel workbook with new macros. The primary aim of these macros is to automate data entry tasks, specifically dealing with text data. Your responsibilities will include: - Modifying existing macros or creating new ones to facilitate the automation of data entry - Ensuring the macros can handle various forms of text data effectively Ideal candidates should have: - Proficient experience in Excel and VBA programming - Previous experience in creating or modifying macros for data entry purposes - Excellent understanding of handling text data within Excel Please provide examples of similar projects you've worked on, and your approach to tackling this task.

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

necesito obtener datos a diferentes hojas de excel desde la base de datos en msql de mi pagina web, tengo avances que funcionan hasta cierto punto, necesitan ajustes para lograr lo esperado.

Description: I need VBA and Excel automation expertise to integrate a new productivity KPI into an existing report. The POS vs. Opportunity report already contains automated VBA scripts and formulas, so this task requires enhancing the functionality without disrupting the existing structure. Project Overview: Integrate a Productivity KPI: Track registrations completed per team member and calculate registrations per hour. Data Source: Supervisors maintain a separate daily registrations report (Excel). Goal: Combine this KPI seamlessly into the current POS vs. Opportunity sheet. Requirements: Add columns for Registrations Completed, Hours Worked, and the calculated Productivity (Reg/hr). Maintain the current VBA automation and ensure no int...

I'm seeking an Excel professional to update an old worksheet. The task involves: - Adju...Optimizing existing formulas to improve performance - Generating visualization charts for better data representation - Automating routine tasks using VBA or macros - Updating cell formatting for consistency and readability - Linking to external data sources for real-time updates Ideal candidates should possess: - Proficient Excel skills - Experience with custom formulas - Strong data entry and correction abilities The task should be quick for an expert. The new data entries will be provided by me. Please include bar and line charts for the data visualizations. Include automation or macro integration as part of the updates. The deadline for this project is "no deadline."...

I'm in need of a skilled programmer who can create an Excel VBA plug-in for me. The primary function of this plug-in will be to detect user actions within Excel and display selected messages on the top corner of the screen. Ideal skills and experience for the job include: - Proficiency in Excel VBA programming - Experience in developing Excel plug-ins - Knowledge of creating and linking macros to buttons Please only apply if you can deliver a high-quality, efficient solution.

I'm in need of a macro for Outlook that can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should...can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should be moved to a specific folder. - All file types from the email attachments should be downloaded. Ideal Skills and Experience: - Proficiency in creating macros for Outlook. - Familiarity with VBA (Visual Basic for Applications). - Previous experience with email automation tasks. - Attention to detail to ensure all attachments ...

I need a VBA script that can extract specific data from my Outlook emails into an Excel spreadsheet. The data to be extracted includes the sender, subject, received date, received time, whether it's a new or follow-up mail, and if it's a follow-up, when the first revert on that mail was and when the last received mail was. Key Requirements: - The script should filter emails based on a specified date range. - The script should be able to extract data from both new and follow-up emails. Ideal Skills: - Proficiency in VBA programming. - Experience with Outlook automation. - Strong understanding of Excel. Please provide examples of similar projects you've completed in your proposal. The script should be run on a daily basis. The extracted data should be appende...

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...professional with extensive experience in Excel and VBA programming to create two specific macros in my Excel 365 file. Task 1: - The first macro needs to process data by removing all spaces and special characters, while also converting all letters to lower case. It’s crucial that this macro retains leading zeros. For instance, the value '075 667 854' should be reformatted as '075667854'. - Furthermore, this data needs to be formatted as text. Task 2: - The second macro should identify numbers that appear in more than one cell in column A. - These repeated numbers should be placed in column B, with numbers that occur more than once being separated by a comma and a space. Ideal candidates for this project should have: - Proficiency in Excel ...

I'm looking for a seasoned Excel developer to create a macro that can sort and filter mixed data (both numeric and text) effectively. The macro should be able to fetch data from another spreadsheet. Ideal Skills: - Proficient in Excel VBA - Experience with data sorting and filtering - Ability to create efficient macros for repetitive tasks Definition: I have an Excel spreadsheet with Columns A-C, which can be seen in the Example.png. In the current format, the part level doesn't exist, so I created and colorized Columns J-M manually to show my need. But I want a macro to do this format automaticity

...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...

...with extracting production data from a plain text email into a custom structured Excel file. The ideal freelancer for this project should have: - Proficiency in Excel - Attention to detail - Experience with data extraction and organization. - Experience with scripting languages like Python or VBA. Please ensure you can work to a custom structure before bidding. The data volume is small and manageable. The Excel file needs to be updated with new data from emails weekly. The emails containing production data will be from an Outlook account. The data extraction process should be fully automated to update the Excel file weekly. The preferred method for automation is a VBA macro. The Excel file requires special formatting for certain fields. Special formatting include...