filepath

I've got the below setup, trying to have a filepath reference the workbook name listed in CurrentIndia, highlighted below. I've named the range officially CurrentIndia in NameManager: But everytime I edit the formula or re-confirm it, the Update Values window pops up everytime, and I have to...

Situation: Here is what i have working now. The VBA code will save a copy of the current sheet as an archive file in .CSV format. I'm able to assigned it to a button and it will do it on a sheet by sheet basses. This means what ever sheet the button is assigned to it will export that sheet and...

Hello all I have tried and failed to find a solution so have resorted to asking for help. I am trying to swap out the fso.getfolder file path for Application.FileDialog(msoFileDialogFolderPicker) which will determine the file path of the files i want to copy I hope this make sense - very very...

Hi I know it is possible to open a file with using wildcards, but is it possible to get the full address/filename using wildcards without opening the file? eg opening using wildcards: FilePath=FolderPath & "*DUB*" Workbooks.Open FilePath And I know you can get full address/name with...

Hi Folks, I have found a great macro which allows you to check for the existence of folders in a file-path matching: Year, Month and Day (i.e., creating the folder if it doesn't exist). For instance, if the FilePath starts: C:\Temp Time Sheets\ it checks for C:\Temp Time Sheets\2019\ C:\Temp...

I have been using a macro successfully for sometime now, but I have just bought a new machine and I am running W10 and 365 E3 and now the macro will not see the path of the file The files are all stored in the cloud (Office 365, OneDrive for Business) but are also synced with File Explorer When...

I've got this code below which creates a PDF document. The error message appears saying I'm unable to open the document because: it is either not a supported file type or because the file has been damaged VBA Code: Private Sub Command273_Click() Dim wdApp As Word.Application, wdDoc As...

Hi All, I'm pretty new to VBA, this is my also my first time posting on here. Hoping somebody can help me tweak my code; The code loops through all the files in a folder to copy data from a sheet called ("P&L 2019 - UK GAAP") into one workbook. The issue that I'm having is that, a couple of...

Hi everyone, Here i am trying to copy multiple worksheets to new workbook and below is my code Option Explicit Sub Save_File() Application.EnableEvents = False Dim FlName As String Dim FilePath As String Dim newfilename As String FlName = "Copy" FilePath = Cells(2, "K").Value...

Dear All, I have seen the great value of this website I'm not really experience with VBAbut relaying too much on MREXCEL i'm adding a code to for a button on the excel so when you click on it It should openthe saving as box with a specific name reading form a cell I found the acode but my...

Hi All: I am trying to write a formula to reference cell A1 in this workbook. I am using the entire filepath in hopes of being able to access the data without the other workbook being open. C:\Users\Username\Documents\Report\[Test Workbook.xlsx]Sheet1 Any suggestions?

HI all, I've generated a query from a folder containing dozens of workbooks. I'm using table 1 from each workbook, in the query editor I have all my data including the source workbook, but I want to add the filepath to each row. How to I add an extra column with the filepath inside the...

Hi I have a workbook with a filepath that has another workbook with a sheet i need to copy and paste. So Workbook “A123” has filepath in cell D42 and I need to open that filepath and copy the specific sheet called “Master Sheet” and paste it into another sheet in workbook A123 called “Allocation...

Hi Guys, I hope you can help with the below macro. It runs well as long as Sheet1 is visible (Ideally I'd like it to work even when sheet1 is hidden) however I've also now noticed that it's actually pulling the data from the last tabbed saved in the workbook rather than referencing Sheet1. So...

Hi All, I currently run this macro on multiple documents in a folder. What I'd like to do is hide the worksheet - Sheet1 but still allow the macro to run. Can anyone help with the below to allow the macro to extract the data from sheet1 whilst the worksheet remains hidden Many thanks, Paul...

I am trying to move a sheet from activeworkbook to a file that is stored in a folder. Any help is greatly appreciated, I have attached the code that i am currently trying to use. I feel that i am over thinking this. Sub move_sheet() 'Move the active sheet to the end of named Workbook...

Hello, I am using a macro to rename all my file in a folder with a specific cell value, the macro also rename the sheetname with the same cell value. It works fine for what I need, the only drawback is that the macro is sometime terribly slow. 1) Could someone give me some tweak to speed-up a...

Hello and thanks for considering an issue I'm bringing up. First off - this is relevant only to files stored on DropBox or, very likely, other cloud storage platforms. And only due to the files being accessed on different computers. The problem appears to be that Excel typically uses absolute...

I'm wondering if there is an easy Visual Basic program that can do this: I have multiple spreadsheets (any where from 1 to 300 on any given day). For each of these spreadsheets I need to run the same Macro and then save the result in a specific folder. Is there a way to do this in a batch where...

Hi guys, I was hoping you can help. I have the below VBA macro running in a master file (named ZMasterFile). The idea is I have this file in a folder where up to 100 excel workbooks are stored and I use it to extract some data from each of the workbooks and collate on the ZMasterFile. It is...