fnum

Hello, I have a macro that one of you kind people helped me create. The Macro is used to compile a specific cell value in all files in a folder, and list the values on a new sheet. It works great and I use it all the time. The problem is that all of the references (folder path, sheet...

Hello, I'm a mid-level VBA user and so I've searched and modified the following code to loop through 5 files, each with a "Master" tab. It's worked for months now, but threw an overflow error today on the highlighted piece of code. It's odd because it's crashing between rows 82729 and 132711...

Dear All, I want to send email with attachment using VBA.i am using this code sending an email using excel through outlook,its working but there is any possibility to insert a schedule time to deliver mail.here is the code. i want to deliver mail on a particular time that is provided by my...

I'm getting the "Compile Error: Method or data member not found" error on the following line of code on my co-workers computer but I have no issues on my computer. We are running the same version of Excel (2016 on a MAC), any idea what the issue could be? Error on mybook.Close...

Hi Friends, I need to update a common value i.e. "123456" in Cell H1 of Worksheet name "Index" of all excel files which are stored in a folder. The folder also has sub folders. I tried using below macro, however it is not updating files in folder and sub folder Sub Example() Dim MyPath...

Hi, I'm trying to complete a macro which I've borrowed from another forum, essentially I'm trying to copy merge data from a number of different workbooks (The first sheet only) all contained within the same folder. I was the Macro to copy all rows which contain data from A2 down to V2000. I...

I have the following macro which increases/decreases material pricing from one "Master Key" to multiple files (pricing templates) in an "/Update/" folder. This macro worked fine for Excel 2011 but when we moved to Excel 2016 it is asking permission to open a folder and I can't select the folder...

I'm running into an issue where I can't use VBA to open a file to inject new data unless the filename is shorter than I believe 28 characters. Is there a workaround for this? Below is my code for reference. Sub FactorChange_Price() Dim MyPath As String, FilesInPath As String Dim...

Using Mac Excel 2011 btw which is why you see a ":" instead of a "/". I'm trying to take the data from a batch of files in a subfolder called "Old" which is located in the directory below my template file. Copy and paste the data from those files into my active workbook which is a new template...

I have code that is supposed to add price changes to current price values for all workbooks in a certain file location but I am having trouble getting it to work. Sorry, am a VBA noob. Here is the code: The BOLDED is the line that is giving me issues. Sub FactorChange_Price() Dim MyPath...

Hi all, while running the below VB i am facing with the Error " Compile error: Sub or Function not defined" and when i click on okay it highlights the line marked in yellow below. Please assist, thanks in advance. Regards Debraj Patra Sub MergeAllWorkbooks() Dim MyPath As String...

Dear All , I am using this code for outlook,but i want to email by gmail. -- Sub Button1_Click() email End Sub Public Function email() Dim fnum As Integer Dim lnum As Integer lnum = 20 Dim tt1 As String Dim tt2 As String For fnum = 1 To lnum tt1 = "b" & fnum tt2 = "a" & fnum tt3 = "c"...

I have worksheets that added to a folder daily, and I would like to run the following code every day to add the sheet's data to the master worksheet's data. My problem is that instead of adding to the existing data on the worksheet titled "MuniReg" it overwrites the data, I believe I have...

Hello, I am trying to copy specific rows from multiple workbooks into a summary spreadsheet. Thus far, I've been able to figure out how to merge specific rows from all workbooks into the summary file, but cannot seem to figure out how to merge multiple rows (non-consecutive) into the summary...

Hi all, I have a listing of approximately 150 workbooks where I'd like to combine a set of rows (non-consecutive rows) from each workbook into a new summary workbook. I'm able to combine consecutive rows, but when I try to separate the rows needed, thus far I am only able to merge in the first...

Hi, I have a folder with many workbooks, they have the same number of sheets, one of the sheets is named "Bank" and is protected I want replace "Bank" sheet with a sheet in an active workbook named "BG", but the copy code is not working. This is my code : Sub Example() Dim MyPath As...

I use the following code to loop through all the excel files in a folder and bold the header and then subtotal the results. The issue is the number of columns varies as this is a daily report and I am unsure how to change the TotalList:=Array(4, 35) to a variable that will find the number of...

Dear all, I have a VBA code which allows me to update cell formula in all folder's file but the formula returns "TRUE" instead of value PS: the same formula works manually. This is my code : Sub Example() Dim MyPath As String, FilesInPath As String Dim MyFiles() As String, Fnum As Long...

I have the following script in my spreadsheet that loops through a folder and then applies bolding and subtotals to each spreadsheet within the folder. With the reports containing information by day, the number of columns to subtotal will be different each day. I am wondering if there is a way...