Thread: How do I write an Excel macro to open a file using the CommonDial.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lynn Lynn is offline
external usenet poster
  
Posts: 131
Default How do I write an Excel macro to open a file using the CommonDial.
I am writing a macro. I have one spreadsheet open. I want the user to be
prompted to open a second spreadsheet by opening the Open Dialog Box and
having the user click on the file they want to open.
VB has a ShowOpen command, but I am having trouble using it with excel.
Reply With QuoteReply With Quote