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.
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
My idea is, that the user opens a empty Excel file (with macros) and has several options to generate different types of outputs. The VBA code should: - open a window to choose the csv file - read and clean data - sort data according to my specifications - generate output as new Excel files and PDF files The data is structured and comes with headers
I have attached an excel file and jpg file. The pic is a program I use that I would like to make a excel sheet do the same thing. I need to be able to sort each column by the value in that column. Example: make column I have ALH at the top I need to have a field that will push text into a selected cell. Let me know if you need any other clarification
Hello There is a free website that has data for thousands of files that I would like to mass copy into excel. There is also associated PDF files that can be downloaded but I would like to mass download them too. The site appears to have an easy to follow web address (I have a list of file numbers) which are the only changing parts to the web addresses. The web page layouts are all similar so i...
Hello and Happy Holidays :) My project consist of 2 seperate VBA tasks that require documentation. I ATTACH full description kindly review and let me know if interested. Our deadline is on 29 December! Thank you in advance :)
Possuímos uma ferramenta desenvolvida em Excel e Visual Basic for Applications (VBA) e desenvolvemos uma RFC dentro do SAP. O objetivo é conseguir fazer a ferramenta em Excel cadastrar dados especificos no SAP através do envio de parametros para a RFC. É esperado que o algoritmo a ser desenvolvido seja capaz de: - ler credenciais de acesso do SAP parametrizadas
Hi the project requires you to extract information from [เข้าสู่ระบบเพื่อดู URL] from every page and every advertisement...title 2) Address 3) Property Type 4) Rent 5) Bedroom 6) Details 7) Contact Name 8) Contact Number The data is to be extracted into excel/CSV format I strictly want the python/vba script. This is not a data copy and paste assignment
We would like to get a simple macro if you are familiar with VBA in excel. The base is an excel sheet with a few hundred-thousand building addresses. For each address, a link to a pdf exists. In this pdf, on page 1, multiple data need to be read out and put to the corresponding address line. On page two it should be counted how many "apartments" are
I have a spreadsheet to create labels for an ever changing inventory of lighting fixture samples. Iwant to be able to go immediately upon pressing a trigger (CTRL +SHFT=F) to the first empty row in the SAMPLES tab and start filling in the data. I then want it to autofill the 4 blank label templates on the Tag Template tab. I then want to print the
Hello, I need a VBA coder I need to generate and evaluate paths from the matrix. Technically, I need to generate all possible paths from source to the destination from a matrix. Once, all paths are generated, I need to evaluate all paths to choose a path which has the least impact. Input should be taken from excel sheet and output also should be
Profession: Designer Excel VBA code. write VBA code to adjust cell padding; top, bottom, left, right
I am in need of a tool/ process that I can use on an ongoing basis (preferably VBA in excel) to filter data from a PDF like the one attached, the filter needs to be by category and only show anything -5 or less or +5 or greater for QTY. I do have the ability to convert the PDF to word or excel formats with Nitro PDF. As you will see the word extraction
The task is to create a tool (GUI) using any of the following languages or their combination – Excel/VBA/R/Python/Java/Xml – that would scrape gas and electricity tariff prices from the sites like [เข้าสู่ระบบเพื่อดู URL], [เข้าสู่ระบบเพื่อดู URL] or GoCompare.com. Focus on [เข้าสู่ระบบเพื่อดู URL] for now, however the tool should be able to handle the other above-mention...
We are a furniture removal and transport business looking to have some vba programs done, things like a customer database, employee database with things like drop boxs to select names/products, graphs
I want to create a scoreboard that can be changed when using PowerPoint on an iPad and on a MAC. Not sure if macros / VBA will be the best way. But it needs to be able to go up and down by hundreds.
I would like someone to write a macro for me that can read an JSON file from a directory and parse the data into a readable worksheet. I will attach a file as I have many of them on my computer.
I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [เข้าสู่ระบบเพื่อดู URL](LookupValue, LookupRange
Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are
...number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces [Back-end] The ability to create multiple lists that contain three columns name
Boa tarde, O meu nome é Gil. Estou á procura de alguém que faça um ficheiro excel para controlo de produtos. As funções que gostava que tivesse, são: Tabela de produtos, inserção de produtos na tabela, remoção de produtos na tabela e consulta de produtos através de filtro.
Here is everything you need to understand in the video: [เข้าสู่ระบบเพื่อดู URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [เข้าสู่ระบบเพื่อดู URL] Let me know if you
Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.