Create a VBA application in Excel to help automate the business or organisational process you have decided to address, which must: 1. Have a graphical user interface within Excel such that a person who is familiar with Excel, but has no knowledge of VBA, can successfully operate your VBA application. 2. Demonstrate the key programming skills e...
I need a script making which will import a CSV into excel and then put the data into an easily readable, print format pick list in HTML. Check the attached file and take a good look a the first sheet. If you've actually looked at the document, read everything and have put a realistic, and informed bid, then start your proposal with the words 'No Placeholder'
...saving of quotes - system generated and user entered values - Maintenance of data used by the quote - customers, names, products etc - Lock DB if already in use to prevent loss of / overwriting of data - Admin access to modify data with audit of changes - Ability to feed quote data into a separate quotation (also excel) document Require performance on this
I am looking to automate a major part of my business using excel VBA’s Here are the major aspects of my order Order Intake -customer personal information (name , address, contact info. Etc ) -Customer membership type ( small, medium, large) -Customer preferences (select from the list) -Customer comments/notes Recipe Intake -Nutritioonal information
I have an access db that we need to port the roughly 10 lines of code over to Java. So the Java app would connect to an access database and instead of executing the VBA syntax below, once the Java app connects to the Access database JAVA code will be executed to perform the task below. These are the lines of code - Dim tblNamesArray As Variant tblNamesA...
need to code an automatic Web Form Filler (3 Different Forms, but same information will be used) using excel vba. please contact me to send you the forms, login details and the explanation video of the project.
I need a VBA script that can strip out pages of a pdf. Needs to be able to read each page and then strip out certain content pages. Page contains xxxx1 is good The very next page is good all following pages until they are different than xxxx1 (let's say xxxx4) are deleted. Sometimes the deleted pages will be 2 or 3, sometimes 64, it just depends
Create economic graphics from an xls spreadsheet using VBA Script in our predefined design template 33 Countries and regions 2 languages 9 graphics each, English and German As .png graphics, 1200 pixels wide screen-optimized For the years 1990-2023 individualizers - filename - title - Axis Description - Different delimiters "." and "," as used in
I have 3 files that really need to be tidied up and have a better user interface etc to make my life a lot easier. One is to keep track of staff clothing issues the other one to track weekly staff overtime and the 3rd is to track staff absence over a year
I am looking for a freelancer who can support me in updating an existing excel spreadsheet. The objective is to calculate the following from existing data: Revenue per resources and Gross Profit
...connection. If they are not friends; but their friends are friends to each other, then they have a 3rd degree connection and it goes like this. There are 10 people in a bus. Write a VBA code that finds the largest group in which all people have a connection with each other (any level connection, not necessarily to be friends) in a given 10x10 matrix. There should
...internet site in Turkey. I sometimes need some codes and I try to write it. I use VBA with MS Access. Now I need to convert a VBA code to PHP format. What can my excel VBA code do: I sell my product on [log masuk untuk melihat URL] I have a product list (attached excel file) My code find the link of my product on [log masuk untuk melihat URL] Example...
Hi there! I have an Excel File with integrated macros. The macros work, but I would like to have a progress bar, which shows the progress while the macro is running, so the user can approximate the time. The macro start by clicking on an button.
I want to call a function in a dynamic library coded in C++ from VBA in Excel for Mac 2016. Regardless of where I place the .dylib file, VBA does not find it. I understand it is due to restrictions to access files in certain locations (macOS sandboxing). I've tried various solutions I found online but not results. I placed the .dylib file in directories
Hola, Me dedico al marketing digital y necesito crear una hoja de Excel o Excel VBA para controlar el flujo de trabajo del Keyword research y los Brieings para redactores para la producción de contenidos escritos para web. A continuación expongo lo que necesito, me gustaría contratar a un profesional que me ayude a mejorar mi flujo de trabajo asesor&aacut...
I have a product list with variations. I need a script that removes Products with only one variation. Basically its a Father and Childs List, some fathers only have one child, that child needs to be removed then. Pretty simple.
We are looking for an excel VBA expert with strong client management skills to work out of our client location in Mumbai for about 2 months. The consultant must have 4+ years of experience, past experience with a consulting firm will be preferred.
Hi, I need a VBA excel script that can generate me all possible variations from 3 attributes(variables). For instance, I have a product that has 40 Barrel colors, 40 handle colors and 7 logo colors. I need a script that loops out all possible variations out of that in a excel spreadsheet (see uploaded image file).
I have 60,000 street addresses in a spreadsheet all in one city . I need a VBA Code to return the ZIP code for each address . The code should query USPS since they have a free webtool to look up address info .
I need the Python or VBA expert for multiple jobs. Please bid if you are expert
I need the Python or VBA expert for multiple jobs. Please bid if you are expert
I have a table in my Access 2016 database that holds data that has comma separated lists in two of the fields like this Name....Item Qty....Item Name..... Joe. 1, 3, 4, 5. Bat, Hat, Ball, Glove Plus way more.... I am in need of a way to take the Quantity and the Name and add them together so that I can have the data output like this 1 - Bat 3
I have a table in my Access 2016 database that holds data that has comma separated lists in two of the fields like this Name....Item Qty....Item Name..... Joe. 1, 3, 4, 5. Bat, Hat, Ball, Glove Plus way more.... I am in need of a way to take the Quantity and the Name and add them together so that I can have the data output like this 1 -
...I wrote several tools in VBA for Excel. Users select input data and the tools produce numerical tables and charts. These tools should now be ported to Python, making sure: - both versions produce the same results - the output will be an Excel file - there is a simple online interface where to manage it all The Excel file attached to this post
I need you to develop some software for me. I would like this software to be developed in vba.
Hello, we need a VBA for Word 2016. The aim is to create a coloured register at the right hand side of the page. It shall insert a RectangleShape per Page for several pages on the very right border. The Rectangle position and filling colour should vary depending on "Sections" (not the actual Sections from Word / VBA but the sections I specify using
I have a file with list of company names (File to [log masuk untuk melihat URL]). I would like the entire list to be rid of terms that are contained in another file ([log masuk untuk melihat URL]). Pls note that those terms are case-sensitive and they may contain space before or after the alphabets. For example, one of the terms in [log masuk untuk melihat URL] is " SA". Therefore, a com...
Am looking for a VBA expert who could develop excel checklist based on manually selected checkpoints. For example if user selects certain checkpoints related checklists should be popped up in the next sheet
Adapting the supplied VBA code description, identify and list the pairs contained in 3 RNA designs within an excel spreadsheet (see attached excel file for complete description and supplied VBA code/outline in Tab4). Milestone will be the return of excel file that successfully creates these 3 lists.
...company and we need to work our data better, I am looknig to take a dump of data from our system on a daily basis and this will be saved on our cloud server say at 6.30am, then a VBA Macro will take that data and using another spreadsheet, this will add some columns and some new values to these new columns, with the guidance of the other spreadsheet. this
Hi All, When using outlook with multiple email accounts, is it possible to change which email account (the non default account) the emails are sent from automatically via VBA code when a new message is composed. I understand that by changing the default account this would allow the "From" account to be what I need, however I am required to keep the