files

Hello, I have several excel files with the same structure, and these files' names being country names (Portugal, Spain, Greece, etc.). In a separate file (File Output) I would like to return the Cell F4 from Sheet 1 of all these files into column B. In File Output, I have the names of...

I am reading a bunch of text files in a folder through loop. Using possibly a command button, how can i halt the loop half way instead of waiting for it to complete before i can do some other things.

We have a system that creates files that are imported into Oracle. The files have the naming convention... Filename.0000 ... where the numbers are incremented with each export. So one file might be filename.4357 and the next file will be filename.4358 and so on. Ive managed to import the file...

I have used this to list files in folder, but now want to only list files with do not contain a worksheet "TEST" can anyone help please? To go one step further I would move the files which do not have worksheet TEST to a new subfolder "NO TEST" Thanks in advance *********** Sub List_Files()...

HI, I have multiple Excel files with same worksheet names. I want a macros to merge the worksheets with same file name into new Excel File. Example: File Name A >>> Worksheet names >>> Annex1.1, Annex1.2, Annex1.3, Annex1.4 and so on File Name B >>> Worksheet names >>> Annex1.1, Annex1.2...

I'm trying to attack a problem from a different angle. I posted last week about wanting to open two .xls files in my Downloads folder that begin with "report" but have a ever changing numerical sequence after. For example, report1564504574214 or report1564504538987. Then I depending on what was...

just moved from old laptop to new laptop : old laptop: memory : 8 gb , win 10 , office 2019 pro, 1000 hard disk 5400 , 4702HQ intel . new laptop: 16 gb, win 10 pro, office 2019 pro, 524 SSD , 9750H intel. all I got out of this is merely 15% faster excel on the opening, I got large excel...

This one is way beyond my reach, but I know I want to do it - so hoping it's something you can teach me. Working in Excel 2010, I have set up a macro that takes raw data files, puts them together into one continuous file, then sends that data to a chart file template. All that works fine, but...

Good afternoon, I have run into an issue I am in need of assistance with. I am importing data from 5 Excel spreadsheets into a sixth, however when it queries the first of the five files, it’s returning the data plus an infinite number of blank rows, up to the max and is not...

Hi all, I have a PDF with 20 pages and I want to split it into 20 different pages. I wonder if, appart from the first petition, could it be possible to rename those files that are going to be splitted, based on a list of names that should be in an Excel file. Any ideas? Thanks in advance for...

Good morning; I get multiple text files that need to be imported and parsed. I wanted to automate this function including allowing a user to navigate to the folder for the source files. Also, do not want to use VB since my company does not allow this. Any ideas? Thanks

In Excel 2010, if I want my Excel file to open in a new instance of Excel, (when I open an Excel file via Windows Explorer), I simply add this line to my code: Application.RemoteRequest = True In Excel 365, do Excel files automatically open in a separate instance of Excel? Thanks

Hello: I am building a macro that works with multiple other files. It is contained in the personal.xlsb file. However, when I refer to the worksheets in the other files, I'm able to use the Name property -- for example "New Sheet" -- without a problem. But when I try to use the CodeName property...

I am working on a project where I am creating 6 Excel files. Five will be used by individuals to input data, and the 6th will be a “Master,” where I will import data from the 5 files used by the individuals to the Master to aggregate and summarize the data. On the Master, I have a “Log” tab...

how can i get the file format of pptx, docx, xlsx files with vba without using their extension?

I try to compare two Excel files in Excel 2016 by using INQUIRE/Compare files ribbon buttons but can't get further then opening. I get a pretty scary message "Retrieving the COM class factory for component with CLSIF {00024500...} failed due to the following error> 80080005 server execution...

Hi all, long time no posting. I have a report that I need to split into 6 different files, saved in 6 different folders, and then email the new files to 6 different email addresses. I have managed to slit and save the files, but cant get the email part to work. It sends the first file, then...

Morning. I was wondering if its possible to rename a bunch of pdf files that reside all in the same folder ? Currently the files are just named like, 1.pdf 2.pdf 3.pdf All the files have a date modified next to them for viewing purposes. Can we run a macro that will rename these files & get...

Hello. When opening Excel files that contain links to other files, I often get a message in the lower right of my screen that says "Linking: (file name)" with a status bar (please see attached photo). This would not be a problem except that Excel seems to "pause" at this point for several...

Hello, I want to record a VBA that uses =index,(match),0)) formula into the same cell for multiple excel files. The files will be in .XLSX format and will =index,(match),0)) against a separate excel file. I want this function to work for a folder path containing multiple files Please let me...