Thread: Workbook Variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andrew Taylor Andrew Taylor is offline
external usenet poster
  
Posts: 225
Default Workbook Variable

Dim wb As Workbook
Set wb = ActiveWorkbook


wrote:
Typically I would just run through the help menu for this, but our VBA
program at work doesn't have it, so hopefully this is a simple enough
question:

Is there a way to set a variable as the name of the currently open
workbook/file?

Reply With QuoteReply With Quote