1. S

    Update Values Window constantly popping up; NamedRange not working?

    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...
  2. tzcoding

    VBA Macro to Export Data from Excel Spreadsheet to CSV

    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...
  3. D

    Add folder picker replacing file path

    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...
  4. X

    Get file address without opening the file?

    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...
  5. D

    VBA to create a folder name with the date for Monday and Friday separated by a hyphen?

    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...
  6. G

    ChDir path problem

    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...
  7. Q

    PDF Created from VBA Button won't open

    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...
  8. P

    VBA loop with wildcard in Sheet name

    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...
  9. G

    Copy Multiple sheets to new workbook

    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...
  10. H

    VBA Saving excel with some constrains

    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...
  11. J

    Reference another workbook with entire filepath

    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?
  12. L

    Excel power query

    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...
  13. F

    Copy sheet in filepath and paste into another sheet in another workbook

    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...
  14. B

    Macro not pulling the correct data - Help!

    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...
  15. B

    Running VBA on hidden worksheets

    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...
  16. K

    Move sheet

    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...
  17. M

    Tweak to speed-up macro

    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...
  18. J

    Using filepaths in VBA code - files located on DropBox

    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...
  19. A

    Run a Macro for multple spreadsheets at once

    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...
  20. B

    Help with VBA ....Please

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back