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 ( calories, protein, fat, carbohydrates, ...
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 tblNamesArray
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
Hi, I sell products on well known 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 [login to view URL] I have a product list (attached excel file) My code find the link of my product on hepsiburada
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
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 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 -
...programmers are very welcome. *** Only freelance programmers, please. *** Agencies, Companies, Teams, and the like please do NOT bid. Project description 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
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 [login to view URL]). I would like the entire list to be rid of terms that are contained in another file ([login to view 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 [login to view URL] is " SA". Therefore, a company name like "Robertet ...
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
I have done some macro VBA programs in excel. There are three macro program files which I am unable to load as there is a message "Cannot find project / library" which pops up every time I try to access the macros. I am prepared to pay the fees if this problem is solved for me. *Removed by Admin*
It involves generating projects with various characteristics, ranking the projects using several methods, buying projects using available money, and conti...process for five capital budgeting periods (years). At the end of the five years the wealth accumulated by the various ranking methods will be determined and compared. This is a VBA Excel project.
Hallo Vimal A., ich habe Ihr Profil gesehen und möchte Ihnen mein Projekt anbieten. Wir können alle Einzelheiten im Chat besprechen. Very simple VBA project, it is just about opening and formatting CSV file and create and update a Pivot table.
Hi, i need to retrieve eurusd exchange rate from a specific website into Excel (i need the exchange rate published at "2.00pm Frankfurt time" I was able to do it till recently but now i m blocked. Please help me to find a way to do it without being blocked. see attached file. thanks
Hello and thanks for reading my post. i need a macro that retrieve lines info under a certain condition from one sheet to another
...and a contact list. You will see that in cell A3 i have a dropdown list for contacts. when you select a different contact, the data changes. If it is possible, i need some VBA to help email this dashboard (the black area that is used only) to the email address shown on the contact list. However, i need the data to be unique to each person that it