open a file

' To load work book based on cell value ' Real Estate Books Dim varCellvalueReal As String 'Filename:=Sheets("Sheet1").Range("A2").Value & "\" & Sheets("Sheet2").Range("A2").Value) varCellvalueReal = Workbook(Filename:=Sheets("Sheet7").Range("D3").Value) ' & "\" &...

Hello! I have a query for you all. I have a spreadsheet that lists an attachment number amongst other things. I also have a directory that has all of the attachment files and those file names match the attachment number from the spreadsheet. I want to be able to click on a link or button and...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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