Installshield vbaJobs
I need advance excel and excel vba teacher
Modification of ‘Business Plan template ’ provided to allow for the following functionality: On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.
Modification of ‘Business Plan template ’ provided to allow for the following functionality: On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.
I have a handful of excel projects, ranging from intermediate to advanced skill sets required. They include creating formulas / functions, and using VBA to develop automations with the click of a button. If everything goes well with the first project, then I’ll send you more work ongoing — possibly every week. Please include any samples or relevant work in your response that shows your experience with excel, thanks.
There are 3 tiny Issues in Ms Word File VBA Coding; 1. There is a Signature Section, which is misaligned in a text box and in order to align it, I have to click inside Text Box and run a Macro specially made for it. But I need that it should be done without clicking manually in each signature Text box and running macro separately for each Signature Section. 2. There are 3- 6 extra spaces in different places in document between words, that needs to be removed through VBA. 3. As I convert my Ms Excel file to PDF & then to Ms Word File, Paragraphs/sections where Page breaks occurs in Ms Excel File, when converted to Ms Word gets divided and gets captiavted in Text Boxes. There has to be a VBA code in Ms Word to bring them out of text Box and make them one paragraph/s...
Hi Hafiz Umair N., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Copy paste variable down 10 rows, leave a space and loop thru data set doing the same, with the next variable until the last variable (note: the last variable is not defined and there can be as many variables possible). I have attached excel sheet showing the desired output.
VBA code based MIS For India's largest public sector bank - we are looking at a smart VBA developer who can create Excel based dashboard to analyze data, and share the outcomes through Outlook email.
we have a table and we require a macro which will provide output with specific format, not much difficult the only dynamic parameter is the data. Outpt and Input format attached
Please watch this video: Need an excel macro to send email with PDF attachment. The macro must send emails via outlook. I have an excel sheet with names and email addresses. The macro must send emails to each of these emails, with the name and content provided by me including a PDF attachment, at the click of a button. >>>>>> If you want to win this project, start your proposal with: "I can write the macro to send email using outlook for $___(fixed price) within ___ hours."
Please watch this video: >>>>>>>>>> If you understand the requirements, please write in your proposal: "I can write the macro to send email using outlook for $___ within ___ hours." Any proposal who bid without watching the video or without the above phrase will be ignored! Need an excel macro to send email with PDF attachment. The macro must send emails via outlook. I have an excel sheet with names and email addresses. The macro must send emails to each of these emails, with the name and content provided by me including a PDF attachment, at the click of a button. >>>>>> If you want to win this project, start your proposal with: "I can write the macro to send email using outlook for $___ within ___ hours."
I want to create a Excel VBA code for Outlook, in which I can share a new mail to my clients one by one single time and after 3-4 days I want to send them a follow up email in the same thread so that they can see that I’ve already shared them a mail couple days ago. If I get the revert on my first mail that would be great but if not then I have to send them a follow up email in the same email thread/loop. To cite an example today 10/07 I’ve shared a fresh mail to a new client and on 10/10. I want to share a follow up mail in the same email thread/loop with my company details in attachment along with my signature which contains a company logo as well.
I need to share the bulk mails from excel through outlook which contains signature with logo. Also once first mail shared if we get the revert from the mail then we’ll remove that email from the list and if we’ll not get the revert then again need to send a mail but that mail need to go with in the email thread/loop not a fresh new email with signature and loop.
I need a Freelancer who has good knowledge of excel VBA macros, to scrape some additional data from a sports website and add it to some addition columns in my workbook. The data will be live soccer matches including the scores for the home team and the away team and continue to refresh the data periodically. It will also include the decimal odds for the home, draw, away, over under goals and both teams to score. I have attached a screenshot of the current excel workbook and the soccer website oddsportal. I will send the file to the chosen freelancer.
Please create an Excel VBA to automate do the following work. Enter date data in excel cell A1.(ex:20220722,the year should be 2022-1911=111) Go to an url() and choose the Year and Month and select the bottom option.(See image 1.)(image B2 should be A1) Download the specified date csv file which is entered before at step 1.(cell A1).(See image 2.)NOTE：If cell A1 is empty, download the newest csv file in the url. Copy and paste the specified range data to excel cell B2.(See the specified range at image 3. and image 4.) There's no need to save the downloaded csv file after passing the data.(Do not create any new tab to scrape the data)
We need excel and VBA programming expert for generating the automatic Project Bill of material along with costing, We have prepared the RFQ in details, need to discuss one to one for better understanding
I need Excel VBA expart with advanced skill and attractive presentation also Note:- Only bid serious with experience of Excel proposal please shate previous work experience .thank you
I want a tool made in VBA, lets connect and discusss the details. Email me if interested.
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
Boa tarde, Pretende-se obter um ficheiro de registo de vendas relativo a cada cliente, com gestão de stocks de entrada e saída conforme cada encomenda, bem como o controlo do fluxo de caixa, registo de clientes e outras situações. Um ficheiro simples prático para ser usado como base de dados e controlo de gestão de vendas.
I am using a VBA script and running a rule through Microsoft outlook to save email attachments to a folder locally on my PC. I need a new VBA script to do as follows. When the attachment is saved to the target folder the file name need's to be changed and increment by 1 each time. e.g Email attachment is named "file" and when saves to target folder is incremented by 1. E.g "file1" "file2" "file3"
There are 3 files that currently work together to filter data and produce results. "v3Updated current " - Initial filter file. Results are produced in cells "EN195:FA2658" "" - Indicates which filters from the "v3Updated current " to filter "aapl " - Results from cells "EN195:FA2658" of the "v3Updated current " file are pasted to this file. Instead of pasting all of the results from "EN95:FA2658", I would like to be able to filter the results based on a secondary filter found in cells "EN4" ("TYPE"), "EO4" ("COND"), and "EP4" ("OCCUR") - total of 3 filters to be added. These 3 filters correspond to the same columns in the "EN195:FA2658"...
i have two excel files. one is product pricelist table. second is the excel table where i copy-paste the prices from first excel file. after i copy the price into the 2nd excel file's table, i will drag and highlight whole table & right-click copy. afterwards, i will paste that whole data into my e-commerce system, so the system will generate readable price by itself. now i want easier automation for the process i do (copy-paste price to another excel table). i want a loadable macro in my 1st excel file, so whenever i highlight the rows of price in excel file 1, and right-click copy, it will automatically re-formats the data into a table and apply it on my clipboard. so i can direct paste into e-commerce system.
I need Modification on My Excel VBA Program
fix the issue as i have made every changes that is needed. Only i am not able to fix the error as the data is not pulling the candidate sheet
Write a VBA macro to clear the specific sheet range, and protect specific ranges.
Database sheet, either in excel VBA of access
I wanted a excel expert who can create an excel using VBA which can create or genrate appointment letters (200) and then crating a pdf and then mailing it to respective manager
I got variable row lengths with any numbers between 1 and 45 Eg 9 numbers in row 1, 12 numbers in row2 10 numbers in row 3 and so on. The number of rows vary as well could be any number of rows in a sheet. Each line must be crossed with all the lines in the sheet eg 10 lines will result in 45 crossed rows. The result of each crossed two rows must count the common numbers and only if the count in the duplicate numbers is 5 or 6 the those duplicate 5 or 6 numbers must be output on a new sheet. If the number of results is more than 500000 the results must continue to cells away from the first row result.
I want to create daily reports for my organisation. I have a table that contains data based on date. I am trying to create a report that fetches data from the table based on a single input of date. Just to give a little background, I have a manufacturing concern where I need to keep track of production at different locations.
Benutzen eine Applikation, die aus einem Access Frontend und einem Backend aus einer AccessDB bestand. Das Backend wurde nun auf ein SQL Server verschoben, dadurch funktioniert aber ein VBA Skript nicht mehr. Ich denke, dass liegt daran, dass eine SQL Datenbank anders angesteuert werden muss, als eine Access Datenbank. Ich bräuchte daher jemanden, der das umschreiben kann. Das Skript ist nur sehr kurz und macht nichts anderes als einen Datensatz von einer Tabelle in eine andere zu kopieren, sowie Felder wieder zu leeren.
I am looking for an excel vba expert. Small task
A MS Access database (table relationship design, forms, macros/vba) with functioning logic (but no nice formatting needed): - Activities tracking (activity description, internal-contributors, external-contributors, external-companies) - Activities can have multiple "internal-contributors" and multiple "external-contributors" - "external contributors" work for "external-companies" - Database user can create/edit activities and add/remove multiple "internal-contributors" and multiple "external-contributors" - Database user can also create/edit activities and add/remove multiple "internal-contributors" and multiple "external-companies" (without specifying which "external-contributors"). - Database...
...not found by using the EAN Code, the scraper should try using the Manufacturer Code. In case the information is not found by using the EAN Code and the EAN Code starts with "0", the scraper should try using the EAN Code without "0", if it still doesn't work, use Manufacturer Code. The price scraper should be able to run from Excel or Google Sheets and managed by an user with intermediate Excel VBA experience. The user should be able to update the product database (add/eliminate products and update their information), webpages, and understand how to change the code in case new webpages were added. The program should be runned manually by the user, who can choose to run the program for a single webpage, a group or all the webpages. The collected informati...
VBA Project Revisions/Updates Customized for my computer Excel, Outlook, and Word versions, add my digital signature, debugs fixed, add spell/grammar check, allow preview and spelling/grammar checks to be completed before sending, add DocuSign or AdobeSign for confirmed receipt of the document, and available space to enter data increased to unlimited. Request for recommendations for a smoother transaction. Create a form that collects the data needed for the excel document. Entering the information from side to side can be challenging. Design: Would like to improve the look of the Word RN Progress Note to deliver a medical report feel; it is a very fill-in-the-blank type of look.
I require to simply copy entire data of 5 sheets to new workbook and rename the workbook as per a cell reference, post which to save to a location as per a cell location specified
I need VBA Developer from Ahmedabad, Gujarat for a few projects who have knowledge of SAP integration.
I am looking to create an app that i can load onto a kiosk which allows me to update a spreadsheet stored on my Microsoft OneDrive. I have created sample UI just for reference on how I require the app to look. I have also included a sample dataset Screen 1 - I would require an on screen number pad for the user to fill out the work order. Once the work...is displayed for their stage then the user can either "accept" the changes or "decline" the changes. If "accepted" then a message appears saying "Update Recorded". If "declined" then it goes back to screen 1. Users should not be able to edit any previously entered data. Let me know which way you think would be the best way to get this done. I have looked into android apps as well as cr...
Looking for an expert in VBA to fix the macro file. Thanks,
■ Details of the request Automatic Image Insertion Macro of Excel files using VBA ■ Development details I need a macro that will automatically insert images. Image files and Excel are available for reference. I would like you to develop a macro file that can automatically create a sheet, copy values, insert images regarding the original files. The attached PowerPoint file for the instructions.
Nowgoal website recently changed to javascrip. So downloading two tables stopped working. This should be a very easy fix as it just need to download two tables into two excel tabs. The Macro to fix it is in !importlivetable_TG (button: import live table) The job of the macro is do scrape two tabels (Left and Right) from nowgoal based on the ID on G1 in the "hcap" tab (InputWWW field) , in the current example You can see the result of the scraper in "fix2-csaping " and how they should be displayed. The left table is being scraped into hcap and the right table into goals tab, the middle table is not being used, the right table goes into "goals" tab.
Phase 2 Implementation of KSA Simplified Tax Invoice as per ZATCA / Fatoorah Specifications Description: We are successfully using Phase 1 Simplified Tax Invoice. We need Phase 2 Implementation as per ZATCA / Fatoorah Specifications. We need an expert how can implement a valid table structure to generate XML file using MS Access and VBA, REST api integration to submit it with complete tracking history etc as per ZATCA Standards. Late on we may need a web solution too.
I am looking for someone proficient at VBA to create some VBA code to convert excel files into a new template which is in CSV format. The task will not take more than an hour or two. I have a whole bunch of excel files with data in a certain standard template. For each file I need existing data reformatted into a new template and also one other file creatred with specfic data in to - for data entry purposes.
Hi Hossein K., I need help soon als possible for VBA in Excel to create a sheet. Thanks for helping me!
Hi Shaun K., II need help soon als possible for VBA in Excel to create a sheet. Thanks for helping me!
