Very simple requirements: 1) create excel vba code that will open a text file (e.g. [se connecter pour voir l'URL]) 2) code will then do the following: 3) look for person's name in the line (e.g. Dr. FirstName Last Name) 4) remove the firstname and leave only Dr. LastName) 5) save text file without any further edits [se connecter pour voir l'URL] - SHOWS YOU THE INPUT FILE (...
Can anyone write a script to automate data update/upload to ms project from ms excel. I have standard forms and need to update the project data through outlook inbox or by any other means.
I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly
Olá, Trabalho com varejo e atacado, venda de roupa feminina. Estou precisando de uma planilha em excel VBA, para otimizar meus processos de vendas e demonstrativos. Vi na internet muitas planilhas muito semelhantes a que eu preciso, precisando somente de algumas pequenas alterações, mas infelizmente quem as vende não faz alterações. a seguir as i...
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
Hi, I receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it man...receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it manually. I would like to have a little VBA code that does it for me.
...will take my order that gets placed in Whmcs IPTV portal /Xtreme codes and automaticly create the login and password for Xtreme codes and then send the customer thier activation login and password email so they can use my IPTV Service. I'm currently only reselling IPTV so I don't have access to this Automated feature that create this account login password
I'm looking for a list of 250 dentists across the following five zip codes ( 19118, 19119, 19138, 19144, 19143 ) Included in the list I need phone number, email address, website, for each office.
I would like to add data into Google Sheet from Solidworks. I'm using SolidWorks to make techn...data to Google Sheet and store files in Google Drive. I would like to have work done in two steps: 1. Populate new row in Google Sheet with data sent from Solidworks Macro (VBA, C#) 2. Save files to Google Drive and make link to the files in Google Sheet