file

Hello guys, I really need help solving this, it would save me tons of hours. I will explain what I need to do. I have about 400 txt files that look like this: I did some notes with red text: And I have to format this data so that it looks like this: Like I said I have 400 text files which I...

i was needing something that would count file's list their names then their path then the modification date- however; the VBA i am looking at does not work it is failing at the first line and saying compile error: user defined type not defined was hoping someone could help or if they have...

The code below just loops through files and then sends them. But the MSGBox keeps appearing after I`ve send the Email? And the code will not end? Also it produces a email for each file type all file types if finds needs all be in the same Email. Sub Send_Email(EmailTo As String, EmailCC As...

With VBA i need to open a drawing part from user form. I have all the paths and part numbers correct but can`t seem to hyperlink to the drawing part. It just goes to the message rather than open the drawing. Private Sub Open_Part_Click() Dim SourcePath As String Dim SubPath As String...

Hi Team, following scenario: I have a source folder, containing PDF files. Location would look like: Z:\aaaa\bbb\ccccc\2022\ddddddd\eeeeeee\ffffff\this_is_the_folder_containing_all_the_pdfs\*.pdf The naming convention for the pdf files, is Account number_Invoice number: 123456_654321.pdf A...

Hi all, I have a .xlsm excel template with quite some macros and a toolbar in it. It e.g. executes some macros on opening & closing. It is working fine for about 95% of the users, but 5% of the users do every now and then bump into "problems found with file yourfile.xlsm, would you like to...

Guys can anyone have macro to end the selected file from pop up. 1.File should not pop up after executing

I want to merge files "Data" which are in "select input folder"button and "select output folder"button into one file Both the files "Data" Should Merge When I click Execute button Is there any macro to dd?please help me out

I am trying to open a new workbook in VBA. I have pasted the relevant part of my code below. I'm new to VBA so bare with me :) I have tried various .open formats, but each time I get the same run time error. The file I am trying to open is a Excel 97-2003 file (contains macros). Any help would...

Good Morning how would I go about reading a text file and scan for values? If found return the header line. the text file has a header on line line (Test1) the second line has all the IP values between each group is a blank line the text file looks like this? (test.txt)...

Hello, I have a folder (let's say E:\Test ) that contains files created daily that have the name yyyy-mm-dd_test.xlsx I have another excel on a different folder that gathers the info on the files from E:\Test, putting it into tables. The problem is, I need to delete the files in E:\Test that...

Create a list of all files in a given folder which are more than 50KB in size - display the list in excel

I'm looking for some help. I started trying to use excel for this project yesterday. I originally scripted a batch file to run this operation. The batch works in a small and limited environment. I tried the batch in a live folder and it was a complete failure with files being multiplied and...

Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...

Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...

Hi Guys and Gals I have a problem that is out of my expertise I have some VBA working fine doing what it needs however the end goal is to copy a file form a network drive to a local drive, however, the local machine i need this on does have excel installed to fire the VBA form task scheduler...

In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark) Name Mark Class Grade John 50 Post Graduate A Peter 50 Preschool A Andera 100 Nursery S In the another Workbook B, is the fixed Existing report...

I am processing over Excel files in Python, and opening it as a part of it. I suspect my code doesn't execute fully because it doesn't recognize warning messages In my VBA code I use the following: Application.EnableEvents = False Application.ScreenUpdating = False But I am not sure how I...

Hello everyone, This thread is related and inspired on an old one: Force users to save as .xlsm or xltm only. In any case, I tried to replicate the code for XLSM and PDF format only. No luck. Although the two options are available, the PDF one didn't produce any good file. I would like to...

I just created a custom list in an Excel file that I am using for a Slicer and pivot table filter. I emailed the file to another person and the custom list did not transfer with the file? How can I make sure that the custom list stays in the file?