My macro prompts to selected a picture then rotates and sizes to the selected merged cell. The issue I am having is when I am prompted to select a picture it always starts in my documents folder. The pictures I use are saved in the same folder as their corrisponding excel document. How can I get it to begin the prompt starting in the folder my excel file is saved in? I am using excel 2010 on windows 7. My code is listed below. Any help is appreciated thank you.
The code I use to prompt for a picture is listed below
Sub ROTATE_INSERT_PICTURE()
Dim myPicture As String, myRange As Range
myPicture = Application.GetOpenFilename _
("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", _
, "Select Picture to Import")
The code I use to prompt for a picture is listed below
Sub ROTATE_INSERT_PICTURE()
Dim myPicture As String, myRange As Range
myPicture = Application.GetOpenFilename _
("Pictures (*.gif; *.jpg; *.bmp; *.tif),*.gif; *.jpg; *.bmp; *.tif", _
, "Select Picture to Import")