...needs to do a search and replace. File name 0001-hello [login to view URL] >SC00001WHT-SC01-hello [login to view URL] File that I needs to be processed can be from a txt file or csv,excel etc. I got a list of before/after names, the program needs to search for before (ie. 0001) and replace it with after (SC00001WHT-SC01) File that I would give you: OLD
Hi Zoltan N., I noticed your profile and would like to offer you my project. 01 VBA macro that logs changes in a column in existing excel file each time an existing macro is run. The VBA code has been written, but is not working properly. 02 In the 'logsheet' push the 'old' values together with a timestamp in a column to the right sid...
Macro to Manipulate Data in a MS-Word Table This is a request for a macro to run on Microsoft Word and to make some changes to a table and to the cells within the table. You will need experience in writing MS-Word macros and table management. PowerPoint can export a Word document which contains images of the PPT slides in a table. The table
We have an excel macro that copies data from one worksheet then creates a pivot table on said data. For some reason, as the quantity of data has increased, some of the data being copied is lost. I know which row the data stops at. It seems some of the VBA or Formula's are incorrect. The data seems to stop at SheetA: Row: 13880
I am trying to create an algorithmic excel trade sheet based on multiple, optional criteria. The user will have many optional fields to fill out. The vba code will need to go look up values in different places depending on which tables the user selects. And this code will need to run over multiple cells. See the attached image. The user will
write me an VBA Code which fires a mysql query as a pass through query in ACCESS 2007. # background information Access checks the query if it is sql well formend. After you switch to pass through query you can also fire mysql queries to an externals server. I need a vba code what i could only do in the frontend A Mysql Query is for example is INSERT
... I have a fully functioning daily database app which was created in Excel VBA but unfortunately is running too slow so I want a replica of that daily sales database built in Java. The new Java app must be able to run on a Mac and Windows. All the functionality and layout of the VBA app must be carried over to the new app. What does the existing app
Hi, I'm looking to find someone who can help me on the coding of an Excel VBA Multithread web scraping project involving multiple URL's, each containing multiple tables. Here's a link to the type of URL's used: [login to view URL] The full workbook will need
Hello, I am new to Excel, and trying to write code for VBA, but just found myself spending whole day on it and running in to error all the time. I attached Utilization new template file, and what I am trying to do is: 1)A-Asset Inventory WorkSheet - Cell D3 I created a dropdown validation for "All, Owned and Rental". I need to insert a button "Hide/Show
I need the VBA code for Microsoft Excel which enables me to generate customised e-certificates in pdf format with customised file names. Include one face-to-face meeting to explain the code and how to use the document. Example: [login to view URL]
This is the Macro Im having trouble with. It adds the name and address and a job number to the file name. I am getting a save failed msg and a Run-time error 1004 Sub SvFile() [login to view URL] Filename:= _ "Z:Black Forest Hardwood FloorsBLACK FOREST HARDWOODS" & Range("FORMULAS!b26") & " Contracts" & Range("FORMULAS!A62&q...