folderpath

Hello every body, i hope that some of you guys are able to help me out. i have to get multiple excelfile into one file, but i want to make an inputbox, so that the user are able to choose between different folders. The code looks like this so far: Sub Samling() Dim FolderPath As String Dim...

Hi there, I'm a complete VBA novice, but have sorted out a macro that selects three different worksheets and creates a PDF of those three sheets and the Pivotcharts within them. Sub Scheme_YEAR() Dim myPath As String Dim FolderPath As String FolderPath = Application.ActiveWorkbook.Path myPath...

I am hoping someone can help me simplify this... I have multiple tabs each I have a separate macro calling for each tab to be written to a directory in a shared network location. I feel that this could be a lot cleaner... Also I need it to not run copy the file over if J4 is blank on any of...

Goodafternoon, Wehave had a lot of threads over the years for a macro that : Goes into a specific folder Opens a file in that folder Performs some code in that file Saves the file Closes the file Repeats 1-5 for each file in that folder I have trawled through this site as best I can...

Hi, i've been trying to create a macro that will look to all sub folders. sub folders have word documents and notepads, but i'll just be looking into notepad files. within the notepad, it will be looking for a certain word. Then if the word found in the notepad, it will populate the subfolder...

The following code does successfully loop through all of thesheets in the directory however it does not paste to the next open row in thedestination sheet and instead clobbers the data in the same rows Sub copydatafrommulttomaster() Dim folderpath As String, Filepath As String, filename AsString...

Hi all I'm really hoping somebody maybe able to advise as I've been racking my brains out on this. I'm working on a project where I need to merge multiple excel worksheets (to be supplied by different owners- but in a consistent format) into a single worksheet. I've made a fair amount of...

Hello I have this issue here and I need help : Sub pdfCreate () Dim FolderPath As String FolderPath = ThisWorkbook.Path & "\PDF FILES" ChDir ThisWorkbook.Path & "\PDF FILES" Sheet10.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Sheet10.Range("F4").Text, Quality:=xlQualityStandard, _...

I have a large number of documents saved in a folder. In Excel, I have written the name of one of the files in the active cell, including the extension. The code below opens Windows Explorer when the macro is run. I have the following issues: (A) Ideally Windows Explorer is opened in a...

Hi There, I am getting a runtime error on the following? It basically puts some data into a couple of tabs, then saves those two tabs as a pdf. Inputs new data and creates a pdf again in a loop. There are about 25 iterations of this required. But after somewhere between 5-7 I get a runtime...

Hi, below my Macro: Sub AllFiles() Dim folderPath As String Dim filename As String Dim wb As Workbook folderPath = "C:\Users\Dom\Desktop\Bob" If Right(folderPath, 1) <> "" Then folderPath = folderPath + "" filename = Dir(folderPath & "*.csv") Do While filename <> ""...

My goal here is to open files in a separate folder, run the macro in each file, close and save it. The macro in that workbook updates 15 power queries. The Code Completes The Loop and opens all files, changes the value in A1 and saves them. It however is not running the macro from the other...

Just wondering if there might be a better way for this to be written. I copied bits of code and did a record macro and put it all together to make it work for what i want but it takes a while for it to run. Any help would be appreciated. Sub AllPlayersList() Dim folderPath As String...

Hello there, I am trying to make a VBA code that copy specific sheets based on the selected cells and paste them into a new workbook. For example , if cell(2,3) = China , copy sheet 2 and sheet 3. Then create a new workbook named China that has sheet 2 and 3 in it. if Cell(2,3) = USA, copy...

Hi I have a workbook template ('master workbook') where I want to create new workbook from using one of Master workbook's worksheets. i.e. right clicking the tab called 'summary'(in Master workbook)> move or copy worksheet> create new workbook: I want to save the newly created workbook in...

So I have the following code which pulls 2 cells from the same closed workbook successfully and populates them into the relevant cells in the specified workbook. How would I continue this on and obtain values from another workbook please? Public Sub...