...(sometimes hyperlink can be broken) of a PDF document. I need a macro that can open that hyperlink and save PDF document with specific name as per email subject (i.e. [url removed, login to view]). Once download is completed macro should mark that email as read. Macro should work within excel as I want to keep track of all files downloaded in a single
This project is for two Excel Macros: This will be run daily/weekly The first Macro will convert a web scrape .csv file to another .csv file. It will always remain the same, format/template, however, the data in the file will always be different. The output of this Macro will be used in the next macro project.
I have excel sheet which contains some data points and I need Freelancer to create a VBA Macro code to transfer required details into PDF Files as per the Conditions given, so basically write a Macro which can take details from excel and write it down to PDF as per instructions. Do not bid if you can't do it, lowest bid will be accepted!
I have a spreadsheet with a lot of data which will be shared with many users. I would like th...example, all rows with cells in column A that have contents "hide", will be automatically hidden. It is critical that the macro works for excel users in both Mac and PC. Is this possible? Quote me a price. I will have more excel work after this....
There are very large input files (1 billion characters) that will need to be read into a workspace that only has 4GB of memory. then write and manage output files with counts and strings from the input. Further guidelines available upon requests.
*** DO NOT APPLY IF YOU ARE NOT IN SYDNEY *** A client needs to get a Excel Macro writer to modify a current Excel Spreadsheet or possible create and customise it to the clients requirement. This will require an initial onsite meeting with the client in Brookvale - Sydney This could lead to more regular work Please do not apply if you cannot
I would like to have a macro loop written in VBA that does two things... 1) Updates filters on 8 different sheets every hour 2) Saves the workbook file every night at midnight with the file name [url removed, login to view] and then clears the data to start over again. I already have this workbook set-up and working properly, it gathers data from an arduino board
...panel will be recorded. Finally, analysis for all the three cases would be done to identify the changes in the power output of the PV from the PV plots so as to determine the effects of uniform and non-uniform shading on power output of a PV. Efficiency of the PV model for each case and fill factor for each case will be determined. The values of interest
Modify a VBA script I already have that works just like this, but works for another website. ([url removed, login to view]). With a modified VBA Macro script then I can execute to do data mining of this website: [url removed, login to view] That I will run by pin value in a column on
I need to send Mail with Outlook by using Excel VBA Macros. The first step will be to convert the source data into pivottable by using Excel VBA Macro. The pivotable shall be presented just like in the attached file that you will get later. Masure the pivotable can be cleared so all data are deleted. Second step will be send each relevant filtered
For the link below i need the following data: Categories Sub-Categories Items + Price Item options + Price [url removed, login to view] Please only accept project if you can achieve all data. I dont need part data. Thanks
I would like to automate download of a File from a webpage: [url removed, login to view] Select "Show History" and Click the CSV-symbol Observe that there is no direct link. You will have to find "name" and "click" for element, and execute the build Command. I think its easy if You know where to look.
...of information through an input form (let's call it Form A) in Excel. The information supplied on Form A is compiled in an Excel table, containing the fields of the input form. Then, when an operator needs to address a certain request, there is Form B, which reads information from the Excel table and displays it, with the operator being able to change
Java program which uses Jena to edit RDF files and output SPARQL queries, project requirements if interested.
...attached image for the way the spreadsheet looks. Essentially, I need a macro that will allow me to enter the columns I want to have copied and combined into 2 lists, one with the words that begin with consonant sounds, and another with words that begin with vowel sounds. To do this, the macro will simply start by sorting all of the words that begin with A
From time to time I will collect some production orders from my customers, then I will have to copy and paste some info from the POs to an Excel format. I am looking for some help to do it automatically (VBA?).
Hi Freelancers I have attached a spreadsheet showing data I would like scraped from the internet in relation to stoc...Should be able to update for future dates, and different stock codes if I add more. But basically, I want to be able to roll this analysis over each week with the click of a macro. I'm happy to chat if that's helpful also.