file name

I need to copy data from an open workbook for which I do not know the name, into my workbook that contains the macro that finds this information. I need to know how to get the name of the workbook with the data. Is this possible? I've searched the Internet for two days now and can't find it...

Hi, My instrument spits out two text files of raw data. The analysis I need to perform is depended on which of the two files I'm looking at. The text files have the same filename however the 2nd file has (1) at the end. I can loop through half the files using sFile = Dir(sPath &...

I found a VBA code online to import data from CSV files and paste into the active Excel sheet. I already edited a few parts but can't get the last bit right. What it currently does: - Imports data (2nd row down) from all CSV files in same folder as main file (.xlsx) is stored - Pastes data in...

Hello to Anyone who can Please help, I need to Export to a PDF in the cell Names: 1. Path is cell names - "OneDriveFilePath, & "PCFilePath". 2. File Name is: "FileName". Thx. 4 any help!!! :confused::confused::confused:

Does anyone know how to take a list of file names and dump them into an excel spreadsheet as a file name per row? A lot of times I have a folder of 100 or so policies but I want to manage them with a spreadsheet (so I can tie date last reviewed, owner, etc to the policy name) - I wish to avoid...

Hi There, I was looking around but could not find a direct answer and I am unsure of the print functions and parameters in VBA. What I would like to do is print a range of cells, say A5:E40, to a pdf using Adope PDF. I would also like the name of the created pdf file to be that of a certain...

Hey guys , Here is what i would like to do . i have a folder that contains lots of sub folder with various different names and more subfolders within the subfolders What i would like to have is a script that looks in all these folders and firstly looks for the excel sheets , getting a name...

i have inherited an access tool that imports a file into its database, makes a series of changes, then in its final stages exports the file back into the folder it originally came from with changes. this all works fine. however, what i want it to do, is export the file, but rename it to reflect...

I would like to set up a spreadsheet that has links to other documents. I know how to create links, but I would like a link which contains a document location which can vary with a cell contents. for exam if the file names were Report wk42, report wk43, report wk44 etc. and the cell I wanted a...

Hi all, This is a weird and specific problem so I was having trouble finding anything on google. I have 6 modules that do reporting on a computer inventory database (xlsx format). The reports work great but I plan on handing this stuff out to others. I would like it to work without them having...

How can I return the path, file name, and date modified if a file exist in a specific location? Is it possible with a macro?

Hi all, I `m having a problem. And I cannot find a solution for it. I want to open an excel file with vba. The location is always the same. The file I want to open is built by , filename, date, random code, “.xlsx”. I want to open the file with the latest date. The problem is the random...

Hi all, I have the following code (to copy sheets to a new workbook and save) and I want to change it such that: 1) if the file name C:\abc.xlsx already exists, it will save as C:\abc-v2.xlsx; 2) if both the file name C:\abc.xlsx and C:\abc-v2.xlsx already exist, it will save as abc-v3.xlsx...

Hey everyone, I'm pretty new to VBA but I think it's a great tool for parsing data which is what I've been doing a lot at work lately. Utilizing Excel 2009, I am trying to look for a solution that will allow me to compare a column which contains a list of filenames i.e. "832423.wav" to a...

Is there a way to have a macro copy information from a seperate weekly data file into my main workbook when the file name changes every week? The main part of the excel data file name remains the same, but is updated with the week at the end of the file (i.e. last week: "Weekly Data 3-30-2012"...

Hi, I am new to all this Macro stuff, and I am really struggling with trying to get excel to open an image automatically and insert it into a particular place. I am using a program called Driveworks to create the excel sheet and it creates a link in a specified cell called "Jpeg" which is...

I have a macro that runs other macros contained in the same file. File name is ClientSupport.xlsm, and the macro is GetReports. The code is: Application.Run "ClientSupport.xlsm!GetReports" This works fine. My problem is that I want to change the file name at times, but I don't want to have...

Dear All, I am trying to create code that will take the name of the active file (csv, txt, xls, xlsx), concatenate the current date and time, and open Save As dialog box with a default folder. The below code does all that except finding the name of the active file. How can I pull just the...

I would like to have the file name update and print in a cell. I know how to get it to print in the header/footer area, but not in a cell. Thanks for your help.

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