ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can i open a folder or file (https://www.excelbanter.com/excel-programming/315503-how-can-i-open-folder-file.html)

ΒΟΥΛΓΑΡΑΚΗΣ ΓΙΩΡΓΟΣ ΒΟΡΑΣ

How can i open a folder or file
 
Hi guys

I have two questions

1. Please somebody tells me how can i open from Excel a folder or file which
has pictures or images (jpg format), and copy/paste any picture to a cell in
the active sheet?

2. Also how can i force the cursor to go to the right cell range in where i
want to enter data by pressing the enter key?

For example from cell A1 by pressing enter i want to go to C3.

Thanks in advance

GreekMan



Bob Phillips[_6_]

How can i open a folder or file
 
On point 2, see http://www.xldynamic.com/source/xld.xlFAQ0008.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ΒΟΥΛΓΑΡΑΚΗΣ ΓΙΩΡΓΟΣ ΒΟΡΑΣ" wrote in message
...
Hi guys

I have two questions

1. Please somebody tells me how can i open from Excel a folder or file

which
has pictures or images (jpg format), and copy/paste any picture to a cell

in
the active sheet?

2. Also how can i force the cursor to go to the right cell range in where

i
want to enter data by pressing the enter key?

For example from cell A1 by pressing enter i want to go to C3.

Thanks in advance

GreekMan





Markus L

How can i open a folder or file
 
ΒΟΥΛΓΑΡΑΚΗΣ ΓΙΩΡΓΟΣ ΒΟΡΑΣ wrote:
1. Please somebody tells me how can i open from Excel a folder or
file which has pictures or images (jpg format), and copy/paste any
picture to a cell in the active sheet?


See online help on Application.GetOpenFilename




All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com