files

Hi I am looking for a VBA code to rename file names from column (a) to the new name in column (b) The original files are located in sub folders within a main folder so the VBA code would need to search in sub folders to replace the name. If anyone can help that would be amazing

I have inherited a process which has a template workbook with Macro buttons so users can move to specific sheets. The template has been used to create approx 700 files. I have been making some amendments to the template, which has included changing one of the worksheet names - this means one...

I am trying to figure out how to continuously pull data from multiple excel files, but not allow excel/query to change manually edited values back to source values Example: I have June, July, August files. I pull these files from folder Sample data is <colgroup><col width="64" span="4"...

I will place the vba code in sanju.xlsm my all files are located in same place Sheet name can be anything in both the files Open the file and If cells of column C of sanju.csv matches with sheet2 cells of column C of sanju.xlsx then delete that complete row close and save the file

Hi guys, I have 83 excel files and each file contains two sheet name "Missing with contact details" & "Re-registered or registered". I need to only count the data that is available in both sheet, how can i do that when there are different 83 excel files? need a quick response pls. thanks

Everything works as is BUT Right now I open each file hyperlinked in Column A select cells C18 to O18 of that file and drag right from Column C to Column O of ActiveWorkOrders file. =[AWOF10428.xlsX]Sheet1!$C$18:$O$18 The files hyperlinked in Column A are files people can update using...

Hi all, I'm hoping someone has come across this and has a fix for me :) I'm extracting data from several files, each file has the same structure and I'm pulling multiple tables (but not stored as tables) from 20+ sheets in each. While all source files are closed the execution takes roughly...

Currently i am manually updating my email code evertyime I cahnge the attached files I am needing to send. So i was wondering, hoc can i attache all files in a folder automatically to an email? Line 1 is an example of teh attachement code, lin two is what ai was thinkiong of but does not...

Hello, files with the extension on the specified date need automatic deletion. .csv.pdf.xla.xlam.xls.xls.xlsb.xlsm.xlsx can you help me? ****** id="cke_pastebin" style="position: absolute; top: 72px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">can you help me</body>

I have a folder with many excel files. Many of these files have embedded zip files which contain an excel file. I want to get to the excel file in the zipped file and save it to a folder so that I can then read from that file. How can i do this?

There are multiple pdf files in a folder. Please help me with VBA code which will loop through all the PDF file and save with a password. I have Acrobat distiller installed in my system.

Looking for some help to make this code suit my needs. Goal is to list the number of files in several folders. The folder names are listed in column C and always hosted under "C:\Users\diego\test". The number of files should be displayed in column K. Below code works, but it ignores folders...

Good day, i'm creating a macro that splits a master file into over 30 files, each of those files needs to have a macro that shows/hide columns for some of the sheets on them. i'm not able to figure out a way to add this code to each new file If ActiveSheet.Columns("B:D").Hidden = True Then...

Hi all, I have been searching for a code to print files from a company server (shared folder) but I can't get any working. On the userform I would like to have two comboboxes and a listbox. The first combobox would be populated by subfolders within a folder named "Projects" (which is saved on...

Hello to anyone. I'm trying to find a solution (a vba) that open all excel files inside a folder, then search IN ALL WORKSHEETS of each excel file for "40;" and replace it with "48;" , then save and close files. I found the following vba in microsoft support website, but it doesn't work for me...

Please, what's the fastest code that can resave (perhaps through loop) all the files in a folder and its subfolders and it will maintain the folder and subfolders structure in their destination?

I have about 400 files in an old template. The data in each file needs to go into a new template. Most of the cells between the 2 templates don't match (cell B7 in old template may go to cell C14 in new template, even in a different tab sometimes). ... I really don't want to do it manually 1 by...

Hello - I am hitting the common INDIRECT snag where a #REF error is generated if the file is not open - and I have to use an INDIRECT because there are a great number of dynamic variables in the file paths in question. I am hoping the fix here is to have excel open all the files in question...

For several excel files, when i open them, the file quickly cycles through every visible tab.This does not happen for all files, but most of them. In addition, some files have macros while others do not. I sent one of the files I was experiencing this issue on to a coworker, and she opened the...

Hello, I have been working on a project where I have one file querying data from a set of other files, all found in one folder. I've gotten the query to function as expected, however I have seen a pattern of data from the source files being lost. I don't know if this is an issue in the files...