file name

Hi there, Every time I change the file name I have to update this part of the Code. is there a way to make it dynamic and get the file name? Windows("Template_File open.v5.1.xlsm").Activate

I'm sorry if this is a duplicate post. I looked around but was unable to find an answer for my problem. I'm attempting to use a drop-down data validation menu to change my source file in a formula. For example: cell B1 contains a formula linking to a cell in another workbook...

I can run a pull for files I've names in a folder using the following Macros: ' ELC ' Open the ELC Audit Workbook and Copy into buffer Workbooks.Open Filename:=ActiveWorkbook.Path & "\2011 - RCM - ELC Tests Plant.xls" Sheets("Testing Summary").Select Cells.Select Selection.Copy...

I am trying to open a spreadsheet and read from that sheet except I am encountering a "subscript out of range" error on the Set whatBook = Workbooks(myFile) portion of what you see below. I figure that is because I am trying to reference the full path and not the file name, so how do I get the...

Hello! Maybe this is easy, but I don't know how to search for it. I have some code that goes looking for a specific filename in a specific format based on some user input. example: 555_Part_01.01.11_Test.csv The user would enter "555", "Part", and "Test" - but...

Hello, I’m not certain how to word this, but here is my attempt: I have a template in an excel worksheet that needs to be saved using a thousand plus plan names which are listed in another excel sheet under column c. basically i want to run a macro that will pull the name out of column c (on...

Could someone please help with the following: I have a master excel worksheet (Spare Parts requisition.xls)that consists of only one sheet. I would like to save a copy of this sheet, retaining this worksheet as the master copy but creating a new file from it after the user has added the data...

I have an Excel 2003 workbook that, once the user is finished with, prompts the user to save the updated workbook. I used the Application.Dialogs(xlDialogSaveAs).Show command to prompt the user for the file name, however, I want the "default" save to folder to be the one in which the current...

Hello everybody! I was wondering if I could get some help with some VBA code. I'm using Excel 2003 and am a complete novice to VBA, thus the request. For a work project, I'm trying to take some data from a laboratory instrument (as a .txt file), parse it, massage it, and sort it using Excel...

Hi not shaw what I am doing wrong here, but please can someone help. I am working in a file with lots of sheets, one of the sheets I need to save as a txt file and then carry on working in the original file. Its working to save the file but after it closes the copy file, it returns to a open...

I found the code below on an earlier post from 2002, but it did not give me the full path, including subfolders and file name. It just gave me the files in that particular folder and did not include the subfolders, etc. How do you change it so that I get the full path? I want to use it for an...

I have a procedure that performs certain tasks on multiple Excel files. At the moment my procedure is set up to select each file name from a cell, perform the task, move on to next cell for the next file name etc. Is there any way to create an array of file names and loop through them...