Thread: Performing code without opening the Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marishah Warren Marishah Warren is offline
external usenet poster
  
Posts: 4
Default Performing code without opening the Workbook
The below working code opens the workbook and pastes cells as links from
another workbook. How can I make the below operation work without having to
actually open the workbook located in '"Workbooks.Open
Worksheets(4).Range("A6").Value"?

Workbooks.Open Worksheets(4).Range("A6").Value
Range("A1").Select
ActiveSheet.Paste Link:=True


Thank you

Todd Huttenstine


Reply With QuoteReply With Quote