Job description: Excel based Visual Basics developer / Macro expert. Quickly adapts to the Iterative and incremental development methodology as well as handle new requirements. Every milestone undergoes Requirements Analysis, Implementation of User requirements, Pilot Implementation and deliver.
...of an app, software are simple macro, that can- Scan a youtube account and the information usually found on the ABOUT page is then copied into an excel Document. I would also like EVERY video's title, published date, comment count, copied onto a new line in the excel spread sheet. For each youtube page that an excel line is created for a SCREENSHOT
create an interactive excel macro to pull specific data from a O365 sharepoint list update the columns in the list with dynamic data, and download attachments of specific list items with prepended column information.
i have xls wanted it open in excel file with groups and with sub totals and with design
Hello, i have excel sheet with macros (buttons with macro attached to each of them see the screenshot: [ログインしてURLを表示] ) I have files in .txt or .xls with raw data. When i click on the button with macro attached to it in my excel sheet it allows me to upload this raw file with data (transactions) and what the macro does is removes
Tiny job. I have an Excel spreadsheet with a bunch of Buttons (Form Controls) and each one is attached to a VBA macro. Problem is I now have 760 buttons which is getting a bit hard to manage. I see there is another Form Control called Combo, which I have set up with all 760 stock codes listed in it. What I don’t know how to do is to link these codes
I need a 3D model of something. Topic- analogous mechanical and electrical systems I have a macro file in ansys mechanical apdl which is half filled. I want to complete that file and export it to ltspice and convert the mechanical model into electrical model. Can you please help me with it.
Have a simple rest API call that needs to be made from a ...from a VBA script in Access. Need to also schedule running a Macro on a regular basis in windows server after the API call is working. I have already written all of the VBA and Macro code, just need help with the part that calls a website API, and scheduling windows to run the access macro.
We have an excel file that we use to keep track of all of our in progress orders for a specific customer. We are supposed to share the status of our orders with that customer on a daily basis. We had a macro set up to strip some of the fields and information, and re-arrange some of the fields then save the output to a specified folder as a .csv.
Hello, we need a basic macro written which 1. copies worksheets 1 to 12 to a new workbook 2. exclude any other sheets 3. save as a *.xlsx (non macro workbook) 4. new workbook name must be the same name as the orginal but in *.xlsx format. have attached sample file
...develop a Macro to ease PDF Invoice generation. We have the data in a Google Spreadsheet. The data records are inserted in Rows in one Sheet and the invoice template is in another Sheet from the same workbook. Please see link below [ログインしてURLを表示] The Macro should receive
Hi, We have a small VBA data scraping script which takes data from nowgoal.com. Script currently scrapes betting odds (example page: [ログインしてURLを表示]) - we need a minor fix (shouldn't take more than 5-10 minutes) which will allow to also scrape kick-off dates for football games we scrape Thanks, Daniel
Need to automate data entry of member info into organization's registration portal. I'm not familiar with VBA but roughly it would do this: find open IE (or whatever browser you like) window with "organization name" if A2 = male, select option 1, else select option 2 if A3 = white, select option 1, else if A4 = asian, select option 2, ...etc. first name = A5, last name = A6, e...
I need a macro expert to help me create a workbook that will populate three spreadsheets based on the inputs from two other spreadsheets. Essentially I need the rows in each spreadsheet to be populated based on the number of boxes in spreadsheet 1. I will explain the project to you in more detail after you bid. When placing your bid please comment
Add buttons to: 1. Save As (name in particular text field). 2. Clear form. 3. Create 6x area polygon and fill with different colour and opacity etc. - and display area value as small text in polygon. 4. Create 6x freehand drawing styles with different colour & thickness. also to lock & password protect template.
Will pay $30. Need a simple macro written. Should take less than five minutes. Need macro to copy name of font from prior cell, move one font down, paste name of new font on following line. I'm trying to get a list of all fonts in Word where it shows them in this document. You can see I've done 1 through 75 manually....
Simple excel macro which use Bittrex exchanges API. Base code in here: [ログインしてURLを表示] you will find everything what you need in there. In the app we need few parameters: -API Key - StopLoss % - CurrencyPair - Price Check Interval in Seconds Macro need to do Trailing Stop-Loss which is for example: For example, a user buys 1
Create pdf template. Macro/tool buttons on pdf to edit: 1) draw with different "pens". 2) create coloured polygons calculating and displaying area. 3) button to clear. 4) button to save as. 5) button to export all entered fields to excel/csv. Already have a template made up but needs re-doing with correct formatting and functionality.
Please read and bid exactly what you would like for this project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i ...
Réalisation d'une macro qui 1- enregistre une feuille courante avec un nom structuré et un path 2- Effacer les zones saisies 3 - mettre à jour le n° de pièce suivant 4- Enregistrer le classeur
Hi We have a small scraping macro written in VBA which takes [ログインしてURLを表示] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [ログインしてURLを表示]) However there are some minor issues with this macro. One of them is scraping data when betting market was
I want someone to scrap data automatically from the given financial websites using EXCEL Macro. Then apply some formulas to calculate some desired output. The macro should be fast to bring the output. Use the graphs Below are some websites for your reference [ログインしてURLを表示] [ログインしてURLを表示] https://www
I need an outlook macro which will convert current events to HTML format. The current formats are rich text and text.
...Marina 01. Each Submission document will be in a different file with different file name. So macro should prompt user to encode the site code and it should prompt user to select the particular file and run the process. If it doesnt match with the user input then macro should notify to the user. (Related charts and tables should be automatically updated)
we have one Excel Macro in 2003 need to upgrade macro ,
We have a s...and we are looking to customise a costing excel sheet with certain formula's which can calculate package cost and print the package in word or note file. We have designed an excel sheet ourself but want to rebuild the excel sheet with more functionality added. Need a expert in excel who can rebuild the excel sheet as per our requirement.
I have a Python script which basically runs an Excel macro, but it is giving me a Runtime Error 1004. the macro basically refreshes Bloomberg formulas in the sheet. The macro runs fine within Excel but gives the above error when calling from Python.
We have a suspect macro document and need to understand what will happen when it is opened on windows 7 or 10 with Office 2010. Apply only if you have such system available to test and can do it very shortly after the bid is awarded. Your participation is to: 1) download malwarebytes freeware and run it to verify you have clean system 2) open the attachment
I need someone who can create a macro which will find duplicated events in Outlook calendar. The macro must search by these parameters: - Start - End - Length of event - Attachment - Body text - If name includes "Copy :"