excel & vba 2013

Hi, I have made a code for reading a txt file and delete a set of lines in that file and save it in another location. Can you help me out in modifying the code for reading multiple files present in a particular folder and then do the process on all files and save those files with the same name...

I need to find search from a list of hyperlink in the column D and if the folder exist in the link then select the link as copy path directory so the macro can open the file and copy one of the sheet in it. I use the long way by repeating the code, how can it be done in the shorter way...

I already ask the user to key In ID and the cell will be select automatically. next is how to prevent the excel from closing when data is key in remotely in the selected column? Sub Enter_1() Dim data_1 As String Dim sCell As Variant Dim rslt As Integer Dim x As Integer Do...

Hello all, I have a task to read a bunch of notepad files and in each of the file, i need to delete the set of lines which are present in between the strings "dynamics" and "end dynamics" and also delete those two strings as well. The attached image shows the part which needs to be removed ...

I’m trying to generate 3 worksheets when the button is clicked in the Deal sheet. The first sheet is “PivotData” this is what you get when you filter the data in Deal sheet Second is “LoginRate” this is a Pivot table based on the PivotData sheet. Last is “Performance” it is also a pivot table...

I want a code to filter out the pivot table based on the array of values in the <code>array(ArrDateFilter)</code> for each pivot table in the sheet called analysis. For eg: If the array has 1/11/2016 and 1/12/2016 then Pivot field(visited_date) should filter both the values...

Hi guys! Anyone know how to compare the input time and current time in excel VBA ? This is my code Snippet time = "11:59:59 AM" If Format(TimeValue(Now)) <= time Then test = "Good morning!" Else test = "Good Afternoon!" End If This always returns 'Good Afternoon' and it is my...

Hello All, I created a macro that used to work for a previous project. Now that I have adapted it to a new project, when I run the macro, Excel keeps setting up the problem and the macro does not start running. The code is apparently correct so I was wondering if the problem is: 1. The problem...

Guys I need your help either vba code, excel formula or steps in creating my template. for instance i have workbook with 4 sheets(1,2,3,4) and every sheet(2,3,4) has 3 columns. Now i want to create in sheet1 a group of columns. For the first three columns i want a dropdown list say, s2,s3,s4...

Friends i have a .txt file which contains many columns of data and i want to import only the selected part of data from that .txt file. Is it possible to do that. Normally i first go in data tab in excel then i click on from text button to import the data of .txt file, but this imports all data...

I’m trying to create an attendance workbook with each sheet being the month, with multiple rows/column. I have created a drop down list to choose from on a different worksheet. What I need is the following; HVX and HVP can only be used if HV has been used in the cell before. If D is used then...

Hi I am a newbie to <acronym title="visual basic for applications">VBA</acronym> coding in Excel and this one is just too complex for me to get my head around so reaching out to this great forum I have had so much success with :smile: If you could help by providing some <acronym...

Hi I am a newbie to VBA coding in Excel and this one is just too complex for me to get my head around so reaching out to this great forum I have had so much success with :) If you could help by providing some VBA code that will do the following: Have a button that when clicked would create...

Hi friends I have a list of countries that I have put in drop down by data validation. Need to provide an option that once someone starts typing the countries should be filtered based on alphabet and provide drop down alert. Eg. If someone types 'A', all countries with alphabet A should be...

MrExcel: He usado la sintaxis Workbook... para formar una columna de datos en el libro en que tengo la macro, usando los numeros que se encuentran en una celda fija de varios libros con nombres consecutivos. PAra hacerlo, he tenido que abrir a la vez los 32 libros de origen. Cómo puedo...

I just installed the Microsoft Date and Time Picker Control 6.0 (SP6) onto my Excel 2013 (32 bit). However, when I place it on my worksheet, something strange happens. To place it I perform the following steps: Developer tab Insert ActiveEx more options Microsoft Date and Time Picker Control...

Dear Experts, Request you suggestion and guidance in building a EXCEL based tracker for capturing the team leaves and effort utilization/estimation. Below I have listed the functionalities, which I intend to include - Leave Calendar - 1) Person can select the day or days that he/she is...

Hey guys. This is giving me a lot of problems, and have for sometime now. Searched the web for a solution but was not able to find one. I recorded this macro, but vba will not play it. I want to make the axis of one of my graphs transparent. (I have an another graph behind it) The error that...

Dear All, From the web link : https://support.office.com/en-nz/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61 I have understood that the SHARED WORKBOOK feature in Excel, allows multiple user to read and write on a single EXCEL Workbook kept on a common...

I am having an issue with some of my vba code. I am trying to have two reports compare themselves. If there are differences it will highlight that cell red if its negative and green if its positive on sheet2. On the difference report (sheet3) it will show the difference value with its respected...