open a file

  1. A

    Copy and Paste data from one workbook to another from specified cell

    I have to prepare a macro for tickets. I have workbook (Test100). User open this workbook. If in column F in this workbook, user gonna change value (doen's matter what is the change, it can be just typping "x" inside the cell), macro should: a) open new workbook (Test02) in specified location...
  2. A

    VBA to copy data from files on a list and paste to specific sheet

    Hi and Happy New Year I'm trying to create a macro with the purpose as follows: Open a specific file based on a path in a list (Path, coloum B), copy data in the file from an area (A1:AO5000), paste it to a specific sheet in the Masterfile, sheetname comes from SheetName, coloum A, same row as...
  3. Z

    How to make changes in the target file if the vba codes are in a different file

    My code is written in my macro workbook. I have to work on a different file every time with the same steps. So ideally I need a macro in a macro file and my target files will be different. Below is a code I have in my macro file. Sub EEBalanceSummary() On Error Resume Next Dim FilePath As...
  4. S

    Macro won't open excel files in specified directory. HELP!

    Hello everyone, I need some help with the macro below. I have everything working properly except the last part which is supposed to combine the saved excel attachments. Instead of combining theses attachments, Excel just opens a blank workbook. It seems like the macro isn't seeing any of the...
  5. D

    Opening PDF & JPG files with USERFORM VBA

    Hi I have googled my heart out over the last couple of days and tried 100's of different things but nothing is working so I am hoping one of you fine people can help. I have created a Database with a user form. I need to be able to open the files which names I have pointed out on the left hand...
  6. J

    VBA Copy and Paste Code with filename

    Hey All! I have my trusty old glorified copy and paste code but I am looking to link the line that has my Workbook name to a cell in one of my sheets. Can't seem to figure it out. Sub GrabIndEquity() 'Update Data Workbooks.Open Filename:= _ "T:\FILE1\FILE2\FILE3\FILE4\FILE5\DATABASE...
  7. M

    VBA to open Excel workbook from Sharepoint site and by pass "Open" requests

    Hi, The code below opens a workbook on our sharepoint site. The "Application.EnableEvents = False" bypasses the "Open / Cancel" request that appears at the bottom of the IE 11 but then the Downloads Box appears where you need to click open. How can you open the workbook and suppress the various...
  8. P

    Prevent Popup Window when Opening Azure RMS Protected Files

    Hi all, I'm currently working on a project to run through a list of files on a network drive and report the SQL connections and VBA Modules within each file. I am running into an issue where a file is protected using Azure RMS and I do not have access to the file - I am presented with a popup...
  9. P

    Workbooks.Open in VBA - Getting Password Popup Window

    I have the below code, which I will use to open a file. I will then gather data about the file and report back in a master workbook. My issue comes when I am trying to open a file which has a password: The first Workbooks.Open method presents me with a pop-up window, which I expect, although I...
  10. U

    Can I use Excel VBA Dialog box to display files starting Day*.xml so that my user can choose file to open

    In Excel, the following VBA code does not work properly. dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls") It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...
  11. S

    Open worksheets and run macro in a specified folder

    Dears, I am looking for macro command to open all worksheets in a specified folder and run certain commands save and close file.
  12. R

    Dynamic Workbook path

    Hello everyone The purpose of what I'm trying to build is to get the price at a certain location and at a certain week. For now my code is: Sub Price() price_path = Worksheets("Settings").Cells(1, 11).Value 'Workbooks.Open(price_path & Columns(50).Select...
  13. C

    VBA: Open A Workbook With Constant Path But Different File Name

    Hi everyone, I'm having an issue with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial...
  14. M

    VBA loop to open workbooks, copy and paste data

    Hi, I'm hoping I can get some helping with adding VBA code to my workbook that will merge data from multiple "detail" workbooks to one consolidation workbook. I have a list of file paths, names and sheet names in my consolidation workbook. I would like the macro to follow the first "detail"...
  15. M

    Excel VBA Copy and Paste Code Error

    Hi I'm trying to write a code that will copy data from one workbook and paste it to another. I'm inexperienced with coding, so I copied a code I found online. I tired to add some lines that would allow the user to choose any workbook to copy from. Once I added these lines I got this error...
  16. B

    VBA to Open an excel file using Inputs

    I'm trying to get this code to open a file for me: Sub openfile() Dim A As sting Dim B As String A = Application.InputBox("type value of A here:") B = Application.InputBox("type value of B here:") Workbooks.Open Filename:= _ "D:\Users\" & A & "\Documents\" & B & ".xlsx" End Sub...
  17. A

    Help on VBA to open specific file from the given location

    Hi All, Please let me know if below is possible in VBA code. I have provided the macro below and few edits(if possible) are required in it. So the first step of the VBA is to open the provided code file. What I need is – - I need one button in the excel file, so when I click on this button...
  18. L

    VBA Open most recent file LIKE in directory

    I've been at this for hours with google sending me to obsolete and older code that no longer works for office 2013. *sigh :mad: Ok, so I have a simple request. I need to look in Dir$("P:\path"), find most recent file of "Internal-EOM-201*" & ".xlsx", open it and define it for later reference...
  19. B

    Open new doc, collect data and save as separate file while remaining linked to original

    Hoping someone can advise me. Firstly for some advice. Can I do this in excel. Secondly: how do I go about it. This is for collecting data for a non-profit org. I have a "Client Analysis" spreadsheet that collects data. 1. I would like the Carers to be able to click on a client name, this...
  20. P

    Opening a File with a Variable as a Filepath and Filename

    I have some code which will create and save a new file in to a folder named after the value in cell A1, and also name the file after the value in cell A1 (e.g. C:\Folders\test\test.xlsm, where "test" is the value in A1). This is if the file does not already exist, so I have set this code up as...

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