| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Several files open from workbook, how to do that?
I have to open several files from sheet, but I don,t know how to do that. If
I make a link, I can open just one file... Another way is to do macro or program, and give the names of files that shoud be opened, but how... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Several files open from workbook, how to do that?
Hi,
File, Open then select all the files you want to open (use Ctrl+click to select multiple files) and click Open. Are you opening the same files each time? If you want a macro, try recording it. Tools, Macro, Record New Macro.... If this helps, please click the Yes button Cheers, Shane Devenshire "artzuka" wrote in message ... I have to open several files from sheet, but I don,t know how to do that. If I make a link, I can open just one file... Another way is to do macro or program, and give the names of files that shoud be opened, but how... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Several files open from workbook, how to do that?
Simplest way is probably to just record yourself.
Go to Tools, Macro, record. Pick any name you want. A tiny toolbar should appear with a stop button visible. While its recording, open up all the files you'll want opened. When you're done, press the stop button. Use the Drawing toolbar to draw any shape you want. Right-click on the shape, assign macro. Pick the macro you just recorded. Now whenever you click the picture, your files will open. Ta-da! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "artzuka" wrote: I have to open several files from sheet, but I don,t know how to do that. If I make a link, I can open just one file... Another way is to do macro or program, and give the names of files that shoud be opened, but how... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Several files open from workbook, how to do that?
thanks, that's works!!!!!!
"Luke M" kirjoitti: Simplest way is probably to just record yourself. Go to Tools, Macro, record. Pick any name you want. A tiny toolbar should appear with a stop button visible. While its recording, open up all the files you'll want opened. When you're done, press the stop button. Use the Drawing toolbar to draw any shape you want. Right-click on the shape, assign macro. Pick the macro you just recorded. Now whenever you click the picture, your files will open. Ta-da! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "artzuka" wrote: I have to open several files from sheet, but I don,t know how to do that. If I make a link, I can open just one file... Another way is to do macro or program, and give the names of files that shoud be opened, but how... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| how do I toggle between 2 open excel files and leave both open | Excel Discussion (Misc queries) | |||
| How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
| Open multiple files into multiple worksheets of the same workbook | Excel Discussion (Misc queries) | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Linear Mode
