files

I have a macro button that opens up an excel template file, calculates it, saves it to a new location, copies all of the cells & pastes values, and then saves the file again. This is done for about 15 files. My issue is that sometimes when I run the macro button I will find one or two or three...

I have two data files, containing very different material, but both of length 45,737 KB. I am running on a 64bit version. Now that seems to be rather too big a coincidence. I know file sizes are not meant to be limited, but I am concerned in case there is some restriction in fact. This is...

Ok, So I've done my best to try and figure this out for myself but I havent gotten anywhere. Ive even searched around on here to find a thread with a similar problem that I have and havent quite found what I was looking for, ... though I did find better ways to do other things that I didnt know...

Hello. I need help converting the below macro to be used in MACs. Any help would be appreciated!! Sub MergeExcelFiles() Dim fnameList, fnameCurFile As Variant Dim countFiles, countSheets As Integer Dim wksCurSheet As Worksheet Dim wbkCurBook, wbkSrcBook As Workbook...

Hi - any idea how to vlookup or sumif or ... from multiple .csv files into one master file? The master and .csv files would be saved in the same location, and the filename of each .csv would be stored in a cell in the master file. The .csv files would not be open when the master is open (and...

Hello, wondering if someone can help me write a macro to find and replace all instances of "$C$214" with "$C$216". A few more details... - I need to replace these values in the range E50:WG51 on worksheet "Monthly CF" - The "Monthly CF" file is not the only worksheet in the file - There are...

I have two files that are linked to each other. File 1 contains formulas that links to the data in File 2. File 2 contains data in Tables and the formulas reflect these table names. These files are saved on a shared drive. let's say i create copies of both these files and try linking them...

Hello, unfortunately I have a client that insists on using Macs. The Macro I am using below is returning a 1004 error for Method 'GetOpenFileame'_Application' failed when using a Mac only. Is there any way to correct to have it work on both Mac and PC? Sub MergeExcelFiles() Dim...

Hi all, I have a macro that copies different excel workbooks into one workbook, except they all have their own sheet. When the files get copied into the one big file and get their own sheets, the sheet names are Sheet 1, Sheet 1 (2), Sheet 1 (3), etc.... I need help writing a macro that then...

So I have certain formulas (in range) in one excel file, and I need to copy-paste them into other excel files grouped in folders. I wonder if it is possible to do it with VB coding or any other methods ? Formula range is simple and looks something like this: <tbody> =A6 =I9 =AZ3 =O12 =L1...

Hi All, I'm after a program that will loop through all folders and files in a directory regardless of what file type they are that are less than a specific size lets say 15GB and move them to a folder that it creates on the desktop called the less than 15gb and the date and then go through the...

Hi there, I wondering if there is somebody out there who can help me with a macro to move files. I have a Excel list of files which have the full path and filename in column A, which has been obtain from a Windows search. What I am trying to do is move these files form there various folder...

All, My administrative department has a bunch of Excel files with links to other Excel files in a variety of network folders. They want (need) to move the files to a new server. I'm thinking that if they move to the new server, all of the links will be severed and they'll need to re-link them...

I need to compare (2) columns , in Excel, and highlight the unique cells -- BUT -- performing a simple name comparison will NOT work. I need to find a way, in VBA and/or Conditional Formatting, to find partial name similarities and ignore those as being unique. The following examples are...

Hi Excel gurus. I have an automated process that, among a whole lot of other things, at one point, long story short, it opens some files from a network, copies the content from them and closes them again. This process was working no issues in a local machine where the network servers were...

In Excel, the following VBA code does not work properly. dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls") It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...

I have to delete this file But there is a condition Kill "C:\Users\WolfieeeStyle\Desktop\1.xls" Kill "C:\Users\WolfieeeStyle\Desktop\2.xls" Kill "C:\Users\WolfieeeStyle\Desktop\3.xls" If there is kill.xlsb in this path C:\Users\WolfieeeStyle\Desktop then only kill all that files and if it is...

my files are located in C:\Users\WolfieeeStyle\Desktop\Files i have to move 4 to 5 files(it can be more than this) from here C:\Users\WolfieeeStyle\Desktop\Files to C:\Users\WolfieeeStyle\Desktop condition-check wheather my files are located in C:\Users\WolfieeeStyle\Desktop\Files if yes then...

Hey guys, I have an excel file that I need to create 4 separate files from. In column A I have either "Clean" or "Not Clean" and in column B I have either "NFL", "MLS", or "REMOVE". What I need is a macro that will create 4 files : Clean & NFL, Not Clean & NFL, Clean & MLS, Not Clean & MLS. I...

Hi There, I'm looking for macro that would read all text files from a specified folder (not subfolders). The code should loop through all text files and complete 2 columns with filename and file content column a: filename column b: file content I tried to start with a simple code below ... but...