View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Timmy Mac1[_4_] Timmy Mac1[_4_] is offline
external usenet poster
 
Posts: 1
Default Referencing Spreadsheet in VBA


I want to create a macro that imports data from a spreadsheet delivered
occasionally.

How can I set up the macro in such a way that the user can input the
name of the spreadsheet from which the data is to be copied over?


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=535579