View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Lloyd Don Lloyd is offline
external usenet poster
 
Posts: 119
Default Arguments for a filename

Hi Mike,

It's the path to the Picture that's required.
Try changing FILE.BMP to MIKE.BMP

regards,
Don.

"Michael Smith" wrote in message
...
I have a sub that has an arguement for (FILE)...basically if a cell says
MIKE, I want it to open up the file MIKE.BMP. I have created the
arguement for FILE I just cant get it to recognize the path. Help is
greatly appreciated...

Obviously it is struggling on FILE.BMP

ActiveSheet.Pictures.Insert("C:\Documents and Settings\Me\My
Documents\My Pictures\FILE.BMP").Select


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!