Although this is predominatley a Power Query Question, the criteria are obtained from an Excel Sheet and the output placed on 1 Excel sheet.
I have some PQ code (Windows Excel 2016) that will load a single pre-specified CVS file into Excel as follows:
Dear All ,
I need your valuable helps.
I will create a program that will check other folder/file updating.
For example ,
I have a master list with macro and ;
X folder with x file . x file is x_v01
Y folder with y file . y file is y_01
When anybody create new x_v02 file under x folder...
I am very new to VBA and have been learning as I go on a work project. One of the things that was requested was to have a search bar to find other files of a similar problem solving event.
What I want to be able to do to have a vba program that opens file explorer and searches by tags. but all...
I'm trying to rename all files in a folder based on values in the file and then save them in a user selected folder.
Below is what I have so far. It is able to rename and save the file but I have to select the save folder through each loop.
Is there a way to select the destination...
I want to do something rather large, but I am very inexperienced in VBA and would really appreciate some assistance. Please note that I want to do a bunch of things, but if you can just help me with one of them, it would be immensely appreciated!! - Wishlist: @Fluff ? :)
I noticed something odd today and I don't know if this is new or if I just never encountered this before.
I have 3 files in a folder and imported from the folder into Power Query.
2 of the files have 2 columns, 1 file has 3 columns.
Power Query imported just the first 2 columns from each...
I have a folder with files where I need one sheet from every file pasted into a master workbook. I have tried this with PowerQuery, but believe there are too many files for it to process.
My files are saved at the path: "C:\Users\user1\Desktop\Combine Files"
There are approx 100 files...
Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the previous day's data. To make it more complicated each day's file has two tabs that i need to import but I'm assuming the code below will do this...
Hi - hoping someone better than me can help with a slight adjustment to the below code. I think its easy for someone with the skills.
So it currently opens all the files in a picked folder and renames the sheet to Sheet1, so long as there's only one sheet.
Problem is I have a combination of...
I need a VBA code to copy all files from a folder located at From Path to a folder located at To Path but only those files which are new or have a modification date other than the files which already exists in To Path.
CASE # 1
There are 25 files in the folder...
i have 5 files for 5 regions
each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis )
i merged it by my PQ File file then i use PQ also to Merge it all in one file
that is mean i use PQ 5 times for 5 files
then i use it again to merge it all in one file
I have started a new job which is heavily excel driven, I have encountered a few laptop issues with speed but mainly excel files failing as it "does not have enough resources" to complete the actions - so I have to close down Excel, re-boot etc etc
When I look at the spec of my laptop it is...
Since I upgraded to Excel 2019, my existing macros will not run - they have worked for years on older Excel versions and they DO run normally on my Excel 2019 installation at the office.
I use icons on the ribbon but when I click one, I get the message "Excel cannot load tow files with the same...
I'm on Windows 10. When I'm working in Excel occasionally my screen starts flashing for about 1 minute (no pattern to when or why it happens ... it just randomly starts). During this time I can't click into any Excel cells or do anything in Excel. The other applications on my computer work fine...
I'd like to run code which opens a folder and only shows two specific file types (binary and xlsx files).
I've got the code below, but it only shows xlsx files when run.
Does anyone know why binary files are not shown, as well?
Dim fd As Office.FileDialog...
I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this?
I tried the following macro but it doesn't work:
For Each cnct In ThisWorkbook.Connections
I am reading some articles and they say importing data from database/.csv files to excel the time usually converted to text and therefore I need to use timevalue() and other functions or formula to convert the time to a value. I tried to google to find such files/examples but could not find...
Hello. I'm publishing some reports as .htm files, and I faced issue with relative/absolute path of output .htm files.
Let's say, workbook is located in folder "Publish" at desktop. I want to publish .htm files in that same folder where workbook is located. Attached is layout of dialog for...