path

Hi all, have a box with a button next to it, the idea is, user clicks the button which opens the directory where the Mailing Lists are stored, then the user selects the Mailing List and it stores the path + filename as "facml" I then want the box to fill in *just the file name* Here's my code...

I have a workbook that creates pivot tables and charts from data that changes weekly. The data is downloaded from a customer database and exported into its own Excel spreadsheet. I am trying to copy data from that spreadsheet into a worksheet in my pivot table workbook. The name and location...

I am new to macros and VBA. I built a macro by scraping a few bits of code I found online so this may look a bit messy but it is very close to working for me. My macro basically takes a column in excel and pastes it into a new workbook in order to save it as a .msg file (opens in notepad as the...

Hi All, How with VBA to get folder path if you know folder name only ? For example if you know that somewhere in computer there is a folder named “Invoices_2019” Thank you in advance

Hi all, I would very much appreciate your help with the following: Description of problem: I have 1 tab in my Workbook ('File Names List') which has a list file names and the corresponding path listed. File Names are listed in Col. A starting row 3 and File Path are listed in Col,B also...

Hi all, I have a macro that will open an email template that contains two images as attachments. when putting the images on my local drive the macro runs perfectly. I'm looking to add the images to a shared drive so multiple users can run the macro but when i try adding the new path i'm getting...

I get error 1004 on this Unable to get the insert property of the Pictures class i searched all forums to get a solution butno luck funny thing is it worked well and sudenly it doesn't work anymore Sub AddPicture() Dim img As Object Dim Path As String Path =...

Is there a way to check if a file is open but without the path, in other words, if I have a file text.xlsm, how do i check if it is open without needing the full path like c:/text.xlsm, just test.xlsm?

Hi all, i'm new to vba work and i'm looking for an help! Question: In x path, on daily basis my team member saves the folders with loan number and today's date ex (7894561023 6-1-2019). they can be more than 25 or some times none on single day. so i want to copy the based on latest date...

Hi everyone, Here i am trying to send multiple attachments at one shot but as i compiled and check its exiting at the point of attachment at the send time Any one suggest me with what changes i should do???? Here is my code Sub Mail() Dim myApp As Outlook.Application, mymail As...

Hello all I am having trouble with a code to let the user set a path in VBA Right now I have Dim filePathRop_Gamma As Variant filePathRop_Gamma = ThisWorkbook.Worksheets("Setup Tab").Range("K4").Value 'user supplied path 'code to open the file Workbooks.OpenText Filename:=filePathRop_Gamma...

All - Beginning coder attempting to write macro to attach to a CommandButton to store a selected file path (folder or file from MS File Explorer) into a specific cell "B2". Currently having issues with the code below: Sub GetFilePath2() Dim filename As String filename =...

Hi, I am trying to copy into an excel file the data stored into two different excel files. I am doing this process in a very repetitive way and I would like to automatize most of it. The macro basically have to: 1) Ask me which is the file A. 2) Ask me which is the file B. 3) Copy some values...

Hi. I am looking for a way to open a work book that is in a constantly named folder but the name may alter. i.e. Roof V4.1.xlsm but a later version could be Roof V5.6.xlsm The path to the folder won't change, just the file name. I have tried to make it a string so I can use a wild card but it...

I have code that accesses a file that exists in SharePoint. I am referencing the path as a network path (ie. \\sp5463.xxxxx.net@xxx\xxxxxx\sites\etc) On a fresh reboot of a system, a user will opening the workbook that runs the code will receive an access error, because the system thinks the...

Hi - is there a simple way of knowing where the Table range is looking at if the file path is long and the file path is not in the same file - when I click in I cant see and then the file path stats changing Thanks

How do I write a formula to insert a hyperlink to the folder that the file is in, and still show the full path name?

I have a userform code that open file lists. I need the following help in perfecting it. 1) the code for the search box to automatically search as soon as i type 2) the path called 'PathLabel', the code to get folder path 3) the code that changes the file list each time I change the folder path...

I want to move several UDFs from one module in one of my add-ins to another module in the same add-in. I created the new module and moved the code, but now all of the calls to those UDFs get a Name error. From what I have read, this is an addressing problem in that the calls have an invisible...

I am trying to have the file name, be made automatic as we save it I would like this file to be named: "Meriden Online 04-23-2019" When finished I keep getting a save as method failed error here is what I have so far Dim Path As String Dim filename As String...