Thread: Allow user select file to copy data from "Application.GetOpenFilen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Moore Rob Moore is offline
external usenet poster
  
Posts: 7
Default Allow user select file to copy data from "Application.GetOpenFilen
I have been working on a macro that will prompt the user to select a file and
then copy and paste (special values) that entire worksheet into a new
worksheet "old file". I have tried 'Application.GetOpenFilename' which
prompts me to select the file to copy but that file never opens up. Any
ideas.

Thanks,
Rob
Reply With QuoteReply With Quote