Show The Name Of Opened Workbooks In The List Box

Jun 3, 2009

I want to show the name of opened workbooks in the list box, but the following code does not work.

for example, I opened 'a1.xls' and 'a2.xls'. The listbox of 'main.xls' should show their file name.

View 2 Replies


ADVERTISEMENT

List Sheet Names From Opened Workbooks

Dec 2, 2006

This code loops through all columns in all sheets in all workbooks of a specified directory.

My copy paste to column C in "Loop Folder" works well thanks to this forum especially wigi

I want to paste the file name once in Column A and have it repeat for each new file opened. My code only does this for the first one as I simply can not fathom the coding

In column B I'd like to paste the sheet name once as they get opened.
I am struggling here as well on Sheets.Name coding ....

View 9 Replies View Related

Switching Between Opened Workbooks

May 9, 2007

I have 3 workbooks open, the main WB has my command button + code in it, and the other 2 were opened up using the existing code in my main workbook.

Using general code e.g( Thisworkbook, activeworkbook, workbooks(1)), how can I activate one out of the 3?

I know the main workbook can be accessed using "thisworkbook", but when I activate it, I can't activate one of the others in my next line of code using activeworkbook.activate, or workbooks(1).activate.

View 9 Replies View Related

Code To Run When Workbook Is Opened And Copy Values From Other Workbooks In It?

Feb 19, 2014

I want the code to run when we open excel workbook "TEST" and it should open up all the workbooks one by one in the folder J:ABC and copy cells C2 and C4 values in the A and B columns of TEST workbook.

e.g There are 5 workbooks in the folder J:ABC so when the TEST workbook is opened then the code should run and open 1st workbook and copy values in cells C2 and C4 to it and close the workbook.

The code should run as below:

1st workbook:

C2 value will go in Test workbook B1
C4 value will go in Test workbook A1

Close 1st workbook

2nd workbook:

C2 value will go in Test workbook B2
C4 value will go in Test workbook A2

close 2nd workbook.

3rd workbook:

C2 value will go in Test workbook B3
C4 value will go in Test workbook A3

close 3rd workbook.

and so on It will be going to next rows in A and B columns.

View 2 Replies View Related

Highlight Last Opened File In List

Jul 26, 2007

For a project I need to develop excel spreadsheet that will contain two columns. First column will contain list of sale items. Other column will contain hyperlink to the items image as pdf file stored on hard drive somewhere. My requirement is to highlight row containing sale item, whoes pdf file is modified/updated since the last time user has opened the spreadsheet.

View 8 Replies View Related

Compare And Show Changes Between Two Workbooks

Jun 16, 2012

Comparing two workbooks. At first the workbooks were quite stable and didn't have no new entries or deletion of old entries so I initially used vlookup to give me what I needed and later found some basic VBA on the internet which did what I required quicker.

The workbooks have now changed slightly where each month new deliverables are added and old ones are deleted. This results in the entries of the two workbooks not aligning in the same rows/cells therefore when I run the vba it highlights 90% of the workbook as its just comparing cells against each other.

Each entry within the workbook has a unique identification number so I can still use VLookup for these however this doesn't allow me to see the new deliverables which have been added of the old deliverables deleted.

View 3 Replies View Related

Data Validation List Automatically Show The First Item In The List Rather Than Showing Blank

Jun 20, 2008

I can't seem to find a way to make a data validation list automatically show the first item in the list rather than showing blank.

View 10 Replies View Related

List All Linked Workbooks

Jul 14, 2009

I am redesigning a file with a list of too many links to simply list by hand, so I was hoping there was an Excel shortcut or some handy code that would help me generate a list of all workbooks linked to this one file.

View 9 Replies View Related

How To Create List Of Excel Workbooks

Nov 27, 2013

make a list of all Excel Workbooks in specific folder(My Documents). And once clicked, it will open the file immediately.

View 10 Replies View Related

Create List Of Open Workbooks

Dec 10, 2009

create a list of all open workbooks? I've found various examples of code that will do this in a Message Box, but what I am after is for them to be listed actually in the worksheet (let's say in column AA).

View 5 Replies View Related

Get Data From List Of CLOSED Workbooks Using VBA

Aug 4, 2009

I have one Master Sheet that fetches information off of 30 other workbooks. The data is uniform accross all workbooks.

As of right now, I have code written that will update the master, but ONLY if the other workbooks are open.

Is it possbile to get the same data off of closed workbooks?

Here's what I'm using now:

Code:

Sub Master()
Windows("Master.xls").Activate
Dim Reps As Integer
Reps = Range("Reps").Column
Dim LastColumn As Long
LastColumn = Cells(1, Columns.Count).End(xlToLeft).Column

[code]....

Variable "List" is the list of Workbook names that I'm using.

The code "Windows(List).Activate" is what I'm using to get the data from the other workbooks, but this only works when the workbooks are open.What can I replace this code with?

View 7 Replies View Related

Looping A Macro Through A List Of Workbooks

Oct 3, 2007

I have a macro that will go into a workbook and copy all applications from a given date onto a master workbook. I have another workbook that has a list of around 20 workbooks and i want the macro to go into each one, and copy over the data onto the master workbook. I have the code to copy it over but i can't get it to loop thru the list of 20 workbooks.

View 9 Replies View Related

List Cells From Other Workbooks In Folder

Nov 21, 2007

I am having a bit of trouble with something i am trying to do in my Excel workbook (which we will call the home workbook). Basically what the home workbook does is opens a number of different Excel workbooks that are located in a certain directory. It then finds the first blank cell in on the worksheet "Data Import" ...the cell adress is stored in a variable called found. I need to utilize the values that are in certain cells of the workbooks that the home workbook is opening, but I keep getting a 'subscript out of range' error. I am almost positive it has something to do with accessing the other workbooks. Here is the code I've come up with (well parts of it that are relevant):

Dim found As Range
Dim strFile As String
Dim strPath As String

strPath = "C:directoryPath" 'amend directory as appropriate
strFile = Dir(strPath & "*.xls") ' amend extension as appropriate
Do While strFile <> ""

View 5 Replies View Related

List Same Cell From Workbooks In Folder

Mar 25, 2008

I have two hundred workbooks in a folder located at "C:ozgrid". I'm trying to extract the information in cell B9 in each of these workbooks and input them into a new workbook starting in cell A1 and continue on down through cell A200. Each workbook name begins with "Summary" and has the format of "Summary XXXXXX.xls".

View 2 Replies View Related

How To Create New Workbooks Based On Validation List

Feb 22, 2012

Every two weeks: During Payroll, we have a list of managers and specific employees under that manager.

The managers name is in Column A and they repeat.

Normally we filter that manager, copy and paste the data into a new Workbook, save it, and send the info out to that manager. We do not want other managers to see the information provided to the specific manager.

This is a long tedious process as there are close to 30 managers.

1. Is there a way to run a macro (presumably based on a validation list) to filter, copy the worksheet into a new workbook for each of the 30+ managers?

2. Is there a way to save each with a specific name like "Payroll Feb11 - Manager Name.xlsx"

View 9 Replies View Related

Show Data From List?

May 16, 2014

Question number 2 today! :D

So, ive got a big list with loads of Data on it, there are 3 groups, each with diffrent teams on. Teams and groups are chosen with a data validation list as people move around here.

Is there any way make a second table that only shows data from a set group/team?

So for example.

Group A - Five Teams
Group B - Four Teams
Group C - One Team

I could use a dropdown on a second table that would only show group B and its four Teams.

View 11 Replies View Related

How To Show Values ​​in The List

Feb 14, 2014

I have the following situation: I have some values ​​in column A. other values ​​in column B. I want to be able to display a list using the values ​​in column A and values ​​in column B. A1-> B1, etc.. Attach file: Book2.xlsx

View 5 Replies View Related

List Files/Workbooks With Full Path & File Name

Sep 6, 2006

I do a search on my directory for all *.xls files each month which produces a list some 11,000+ lines long. Attached is a very small sample.

I then import this into Excel see tab Raw Data

What I want to produce is a list shown on tab Finished Data, so that I can then sort etc.

Has someone already done this before and got the code, or can someone point me in the right direction on how to arrive at the finished data?

View 9 Replies View Related

Create Multiple Workbooks With Names Based On List

Sep 2, 2007

I have some very tedious work to do in Excel:

table looks like following:
DepID name function
S1 a YY
S1 b XX
S1 c ww
S2 d oo
S3 e ii
S3 f ll
S4 t mm
. . . . . .. . . .
. . . . . .. . . .
. . . . . .. . . .

S7999 u ee
S7999 w aa

My task is to create new folders for each department according to DepID, which means if there are 7999 departments, I have to create 7999 folders, any VBA code can do this?

View 9 Replies View Related

Create New Workbooks From Filtered List Then Autofit Columns

Jan 16, 2008

I used the code below to successfully create workbooks from the filtered list using the below code provided on this forum (see link below). The only problem is that I want the resulting columns to fit to width.

Looping Through A Range - Use Result As Criteria In A Filter

View 9 Replies View Related

Drop Down List To Show Worksheet

Mar 19, 2009

I have a Workbook with a dropdownlist on it. The dropdown list has some names on it each name will be a refference to another sheet, ie when name Collins Jim is clicked on the drop down list the Jim Collins sheet will appear. I have attached a sample sheet to show you waht i mean.

View 4 Replies View Related

How To Use Dropdown List To Show Price

Dec 31, 2012

I have a price list with type & price, I want do a drop down list for type (this is solve), so when i select list at type, the cell I want it show price.

View 2 Replies View Related

Show Pop-up List Of Sheet Names

May 12, 2007

when i open a xls, i would like to Display the Vertical Menu Of Worksheets (at the bottom left of the tab names)

--this worksheet has many sheets and i find this an easy way to navigate...

(also, how can i write a macro--for a user shortcut--to display this--currently, i hover my mouse pointer over the bottom left tab navigation object and right click to bring up the vertical display of sheet names...)

View 9 Replies View Related

Filter List To Only Show Uniques

Feb 20, 2008

I have a list with many duplicate names in it, from which I only wanted 1 instance of each name, to be placed in another sheet. So, I recorded a macro that selects, from the sheet called "Data", column E (the column with the relevant list), copy/paste's it into sheet 3 in column A, selects the new column, and runs an Advanced Filter command on it, to identify and display all the unique names in it in the same place. It ran just fine when I recorded it. But then, when I deleted the data created by the macro and tried to re-run it, I got random data. I found that whenever I click on a different cell, it provides a different output. I only want it to select Column E, and copy paste that, not other random columns depending on which cell is currently selected. This is my

Sub Fetch_Unique_Names()
Sheets("Data").Select
ActiveCell.Range("A1").Select
ActiveCell.Range("E1:E2200").Select
Selection.Copy
Sheets("Sheet1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveCell.Range("A1:A2176").AdvancedFilter Action:=xlFilterInPlace, Unique _
:=True
End Sub

View 4 Replies View Related

Show List Dependent On A Cell Content?

Jul 31, 2014

I'm trying to create a form where you can select names from a list dependant on what depot has been selected

On Sheet 1 along the first row are names of depots, under each of these are a list of names (number of name varies)

On Sheet 2, C2 is a data validation list, with source being =Sheet1!A4:E4

Is it possible to make C3 show a list of the names that's dependant on what's selected in C2

View 2 Replies View Related

Make A Drop Down List Show The Picture

Jan 2, 2007

I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).

Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?

The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.

View 14 Replies View Related

Excel VBA Combobox Doesn't Show List

Jul 24, 2014

I created a user form in which i have a combo box. The combo box has the list

apple
orange
mango

So the combo box shows up the list only when something is typed on it ex:dot(.). i want to show the list by clicking on the down arrow of the combo.

View 1 Replies View Related

Show List Of Items Without Close Time

Nov 9, 2012

I have a spreadsheet which shows information based on what a person has picked and how long it took them to pick.

What I now want to show is an extract which will show - in a separate area - what shift & person still has not completed the pick (completed time section remains blank) together with the type of product they are picking plus the 'operation number'.

My current spreadsheet is as follows;

[IMG]C:Documents and Settingschristine.lawsonDesktop[/IMG]

Table shows as follows:

SHIFT
PRODUCT TYPE
MSN
OP NBR
PICKER NAME
DATE PICKED
START TIME
COMPLETED TIME
OVERALL TIME TAKEN
AVG LINES PER HR

BLUE
T&F
4
001
FRED
6/11/12
17:55
18:40
00:45:00
4

[Code] ........

As you will see from the attached picture/table there are 2 lines which do not have 'completed' times shown. It is lines, such as these that I need to be able to show in a separate area.

View 8 Replies View Related

Show Sheets Names In A Drop Down List

Aug 25, 2007

Can a macro be provided to show the list of sheet names in a drop down list at cell B2?

View 9 Replies View Related

Data Validation List Can We Show Colors

Dec 9, 2008

in a data validation list can we show colors,assume the following list as a data validation list

Item #
Orange =50
Apple =60
Banana=56
Mango = 40

in this list i want to give colors (as shown) to these two items

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved