folder macro vba open

  1. J

    how to open the directory window and then stop ?

    Hi, I want my macro to perform some actions, and the last one is to open a specific folder in which I then can choose a file to open. I don't want the macro to open the file, because I want to choose the file that the macro is going to open. How can I guide the macro to open the correct file...
  2. P

    Place Picture in Cell In Excel 2003 Automatically From folder and become Part of Excel file.

    <tbody> I have an excel sheet where column A has a list of product codes. I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column B beside their respective codes. If possible, I would...
  3. R

    Open file in two different folders

    Hey guys! I already have a code that can open a file in some folder. But i need it to open not only one folder, but two. I cant set (mydir) to open two folders, because i got an error! the code follows below: Sub GetMostRecentFile() Dim FileSys As FileSystemObject Dim objFile As File Dim...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top