Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
Hi,
Is there a way to utilize a bit of VBA code that will create a list of excel workbooks in a directory with all the corresponding worksheets in an adjacent column with the contents of a specific cell, say C1, next to that? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
On Wednesday, October 7, 2015 at 11:15:33 AM UTC-4, wrote:
Hi, Is there a way to utilize a bit of VBA code that will create a list of excel workbooks in a directory with all the corresponding worksheets in an adjacent column with the contents of a specific cell, say C1, next to that? Thanks in advance. I'm getting a runtime error '1004', it can't find the file |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
On Wednesday, October 7, 2015 at 11:15:33 AM UTC-4, wrote:
Hi, Is there a way to utilize a bit of VBA code that will create a list of excel workbooks in a directory with all the corresponding worksheets in an adjacent column with the contents of a specific cell, say C1, next to that? Thanks in advance. that was it! works perfectly now, thank you so much for your help. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
Claus,
Do you know you can do the same using ADO without having to open the Excel files? The file serves in ADO as the database, and its sheets serve as the database tables. Thus, filename is returned via Dir() and SQL for the list of table names. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
Hi Garry,
Am Wed, 07 Oct 2015 14:21:42 -0400 schrieb GS: Do you know you can do the same using ADO without having to open the Excel files? The file serves in ADO as the database, and its sheets serve as the database tables. Thus, filename is returned via Dir() and SQL for the list of table names. and how do I get a cell value? Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
Hi Garry,
Am Wed, 07 Oct 2015 14:21:42 -0400 schrieb GS: Do you know you can do the same using ADO without having to open the Excel files? The file serves in ADO as the database, and its sheets serve as the database tables. Thus, filename is returned via Dir() and SQL for the list of table names. and how do I get a cell value? Regards Claus B. You query the range. Here's an example tutorial by Rob Bovey, one of the authors of *Pro Excel Development*... http://www.appspro.com/conference/Da...rogramming.zip -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
Hi Garry,
Am Wed, 07 Oct 2015 14:40:59 -0400 schrieb GS: http://www.appspro.com/conference/Da...rogramming.zip thank you. I will look for the code tomorrow. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
list excel wookbooks and worksheets
Hi Garry,
Am Wed, 07 Oct 2015 14:21:42 -0400 schrieb GS: Do you know you can do the same using ADO without having to open the Excel files? The file serves in ADO as the database, and its sheets serve as the database tables. Thus, filename is returned via Dir() and SQL for the list of table names. and how do I get a cell value? Regards Claus B. If the cell has a defined name it doesn't need to be at a specific address. For example, if the workbooks contain quotes/estimates of various numbers of items, the SubTotal, Tax, and Total can be anywhere on the sheet. You can use the defined name in the ADO query as the range ref when the address will be unknown... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Wookbooks | Excel Programming | |||
Problem w/Sharing Wookbooks | Excel Discussion (Misc queries) | |||
How do I make normal view my default in excel 2007 wookbooks? | Setting up and Configuration of Excel | |||
adding wookbooks together | Excel Discussion (Misc queries) | |||
Compare and Merge Wookbooks | Excel Worksheet Functions |