files

I have a query that retrieves information from multiple excel files in a folder The problem I am running into is that those files have formulas that depend on the current date Seemingly, when power query retrieves the data, it doesn't allow the formulas to update first This results in incorrect...

I have a code that creates a pdf and saves it in the folder where the workbook is saved. I have a sub folder PDF FILES. Is there a way to save to the PDF folder without using a full patch like c:\user\workbook\pdf files? Below is the code I have so far. Any help would be greatly appreciated...

Hello All, I'm new in the macro space and I'm pretty sure this question has been asked before. But I have multiple worksheets (12 in total). That need to all be gathered in a single sheet. Now, I'm able to consolidate the files it's just that my problem is that the placing of each sheet is...

I have a local .aspx file that I generated by downloading from an HTML web page (the browser extension saves it as .aspx...not entirely sure why.) It contains a few hundred tables that I want to import into Excel, but my googling suggested that only Excel versions 2010 and later have a native...

Hello All, So I currently am trying to open from VBA, an output file of a macro recordercalled tinytask. I am able to sue theshell function to open the macro recorder itself using the below: Sub TinyTaskCallExample() DimstrProgramName As String Dim strArgumentAs String...

I'm trying to combine files in PQ that have an extra row above the headers. How would I combine these files by deleting Row1 and promoting Row2 as headers? <tbody> Count 5 ID Action Date 11111 INP 18-Oct 22222 INP 19-Oct 33333 INP 20-Oct 44444 CLOSED 21-Oct 55555 INP 22-Oct...

Hi guys, i got a VBA code working for extracting data about files in a specific folder. i would like to know if its possible for me to get data from multiple folders? i would like to add the data from these to my list below. The list below contains data from the folder in the VBA code you can...

Hi everyone, thanks for the help on previous questions and the continued support. I have written some VBA to export some invoice to load in to sage but now need to combine the days exports in to one sheet to upload. Each export contains a sheet with a header row (A1:AI1) then a list of lines...

I've put the following code together to copy specific files from one folder to another based on a list contained in a spreradsheet. There are 2 problems which I'd appreaciatte some help with 1 the kill instuction doesn't work and 2 the code is copying all of the files, not the ones...

The file in question is created by me (let's call it "File X"). It is located in my company's Shared drive - where all my files are kept. Another company (from Europe) sent us a file to fill out for them. When opened, it had a bunch of links to sites and sources that we don't have access to...

Hello, just curious if anyone else is having issues with VBA on a Mac that saves files in a box folder? I have a file that defines the file location and saves down copies of some sheets within that workbook to a folder titled "Output" in the same folder location. Currently the code looks like...

Hi I've got some code that imports multiple files into one single file. However, each file that is imported is put into a separate tab in the single file. I would prefer to have append the data from the multiple files, instead of having it on separate tabs. Does anyone know how to modify...

Hi The code below is to print each workbook's name. If I have 5 then it will msgbox these 5 files names. I want to improve this code so it can print all the name in one shot (not 5 msgboxs or whatever the number of the files). Is that possible? Thank you so much. Sub wb_names() 'to find...

I've got 2 files, one with a sheet linked to the other so that they are the same sheet. The sheet linking to the other one is "Forecast - 8 - Output - 2020-23.xlsb" On sheet Constants, the formula in cell M22 is ='[Forecast - 1 - Assumptions - 2020-23.xlsb]Constants'!M22 That file is open. The...

Hello, I've been using this macro for months without issue but today I keep getting the same error. What the macro is doing is opening csv files and saving them as xlsx files. I have highlighted in Blue where the error occurs. I'm not sure how to fix... any help/guidance is much appreciated...

I have a report that allows users to make individual files for their reps. However there are a couple of macro assigned buttons on the tabs that are used to make new files. The code teavels with the transfer because I have it in the sheet area and not in a module. However the button...

Hello Friends, I am using the below code to open folder 1 Sub OpenFolder()Dim str_folder As String str_folder = "C:\Users\i ' M\Desktop\Folder 1" Call Shell("explorer.exe " & str_folder, vbNormalFocus) Copy End Sub I want to open folder 1 > copy all files from this folder to folder 2...

Hi, I am trying to store the files by using getfolder but even there are 6 different types of files my object only store four of them. The only thing I can notice as difference is that the files that are ignored have very long file name. As you may see in the link below, count is indicates...

Hello - I'm looking for help with this Permissions error. The Scenario: We are sent hundreds of .txt files emailed to us in .zip format which must each be converted to an Excel. The .zip files can contain any number of .txt files, and each .txt file can contain any number of columns. All data...

What I have: A bunch of CSV files with data. Say 300k rows each one. CSV files: if opened directly, they're in the wrong encoding and characters don't show up as they should. There's no option to select which encoding to use or which should be the default for all files? What also doesn't...