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...

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...

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...

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...