| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want a macro that can open a worksheet in a closed workbook
unfortunately not to much information needed
-- BD3 "Lowkey" wrote: Is it possible to create a 4th workbook with a sheet containing the cells you only want updated so the user doesn't see the other sheets or cells you don't want them to, then link your updates to the 4th workbook? "bigdaddy3" wrote: can i do that with a macro as i am using 3 different workbooks with sheet tabs not showing and i dont want the whole workbook showing i just need to update some cell information -- BD3 "Chip Pearson" wrote: A worksheet must be contained within a workbook. There is no such thing as a sheet without a containing workbook. You must open the workbook and then go to the desired worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "bigdaddy3" wrote in message ... I would like to write a macro that will open a particular worksheet in a closed workbook that contains named sheets,when i use the application.open route with the path details, i can get the whole book to open but i want a particular sheet of that book. Can anyone help please -- BD3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| Open a closed workbook with VBA | Excel Programming | |||
| Open a closed workbook with VBA | Excel Programming | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| Determine if Workbook is Open or Closed | Excel Programming | |||
Threaded Mode
