| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO HELP
I have to collect data from a named range e.g. "IssueQty" from more than 50
files to a worksheet. File name is 1000, 1001 etc... Is it possible without opening the workbook. ThanksInAdvance KK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MACRO HELP
Hi Kishor,
See Ron de Bruin's extensive range of sample code at: http://www.rondebruin.nl/tips.htm See particularly: http://www.rondebruin.nl/ado.htm --- Regards, Norman "Kishor" wrote in message ... I have to collect data from a named range e.g. "IssueQty" from more than 50 files to a worksheet. File name is 1000, 1001 etc... Is it possible without opening the workbook. ThanksInAdvance KK |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MACRO HELP
I update the page yesterday
-- Regards Ron De Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Kishor, See Ron de Bruin's extensive range of sample code at: http://www.rondebruin.nl/tips.htm See particularly: http://www.rondebruin.nl/ado.htm --- Regards, Norman "Kishor" wrote in message ... I have to collect data from a named range e.g. "IssueQty" from more than 50 files to a worksheet. File name is 1000, 1001 etc... Is it possible without opening the workbook. ThanksInAdvance KK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
