myfile

I'm in need of a bit of help. I am trying to run a Butterworth filter on a large number of separate files, then copy and paste into a different workbook select calculated values after filtering (Max, time to max, ...). I used this macro successfully once, but now need to apply a rolling average...

Hi All, I'm trying to add to this code below, where the code prompts the display: AND . Sub CreateWklyPDF() Dim wsA As Worksheet Dim wbA As Workbook Dim strTime As String Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On...

Hi I am trying to write a macro to save selected worksheets from the workbook to individual pdfs. but I only got the macro to work to print all the worksheets from the workbook including summary tab and notes tab. I only want to print the tabs that are employee statements. Each individual tab...

Hi, I have a macro which currently allows me to select a folder contain several files, perform a task(line deletion) on all the files and save each one in turn. This works great but the file type I need to save as is a text file and currently my file type is an .spe file. I've looked at many...

Hi all, I am struggling with a piece of code which allows me to bring an external application screen to the foreground and perform some sendkeys instructions on it. Can anyone help me with this? The code I have so far is: Sub WRun() Dim strTerminateThis As String Dim vFileName Dim...

I have pieced together the following code which fires without error, opening files and closing them, BUT it does not clear the range of cells M12:AB25 on each worksheet. Can someone help with what I am doing wrong Sub Make_New_Timesheets() Dim MyFolder As String, MyFile As String With...

Hi All, I am trying to loop through files in a folder and Copy the first sheet to a new workbook. I want the first sheet in each file to be it's own worksheet in a master workbook. I managed to figure out the looping part, but am stuck on copying the first sheet to a new workbook. Any help...

I have written code to open up all the files in C:\Sales Reports containing the text "OBS" when running the macro, nothing happens kindly amend my code so that all files containing text OBS for eg CT Sales Obsolesence Jan 2018, BT Sales Obsolesense for Jan 2018 etc is opened Sub...

I have a folder that contains 100 csv files. I need to delete the same columns from each of these files. I have tried several variations of the code below without success. I keep receiving a syntax error. I have tried everything I can find and keep striking out. Any help would be greatly...

I have this macro I made that converts the excel page to .pdf and then saves it to a folder I assigned. the macro works and the file is saved in the right folder but after the macro runs it displays the message "could not create PDF file" which is the message that is supposed to be displayed if...

Hello all, I am trying to create a macro, to do this: - macro will be placed on a new workbook, called "final". this workbook will have a lot of sheets "munchen", "wien", "paris" etc. - when run, the macro will find the newest file in a folder , will open the file, copy some data from every...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I am using this code to copy in information from one workbook to another. However, this code only copies the active sheet of the selected workbook. I need it to copy a specific...

hi , i have written the below code by reading some threads on Mr Excel . I am trying to transfer data from Multiple workbooks into a master excel workbook automatically using VBA. i have saved my excel sheets (.xlsb) in a folder and also a Master Sheet with name of Collated...

I have multiple .xml files in a folder and I need to place them in an Excel worksheet one on top of the other. So far with the code below, it works to extract the first file, but when trying to extract the next file, I get the error... Sub LoopThruFolder() Dim MyFile As String Dim...

I have modified the following code to change the value of a specific field and auto increment an invoice number for all the files in a user selected folder. The code works great and saves the changes to the .xlsx file but I would like to save as PDF at the same time. I have tried examples from...

I have a macro: Sub test() Dim myFile As String Dim YourFolderPath As Variant YourFolderPath = "\\ESCPTOVSPIFS003\Shares5\ESC\SSB2\Revenue Management\40 Elm Documentation\Bank Reconciliations" myFile = Application.GetOpenFilename("Text Files (*.txt),*.txt")...

Hi friends, I am using the excel for my company billing purpose as it is already coded with the macros of auto-invoice generating and will save in the specified name as in a folder....As the files in the folder consists of the data's about the company name , truck no,materials...

Hi there, I have a macro (AddNewPhoto) which allows me to select a photo and put it into my spreadsheet. The macro is triggered from a button on a userform. I have also got a macro which will launch the camera on my tablet: Sub launchCamera() Dim MyFile As String Dim Cmd As String MyFile =...

Hi All, I have probably easy question, but I stucked on it. I would like to open the workbook like this: Dim myfile as string myfile = Workbooks.Open(ThisWorkbook.Path & "\File.xls") myfile.open etc. What im doing wrong?

I am new to the VBA language and coding. I have a folder with 51 Excel files. In each file there are specific variables between cell J4 and cell R4, included, that I want to tranfer into an inclusive excel workbook. The code that I am using is the following: <code>Sub...