Thread: Using a Variable in the Workbooks.Open code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phatchef24[_7_] Phatchef24[_7_] is offline
external usenet poster
  
Posts: 1
Default Using a Variable in the Workbooks.Open code

I was wondering if it was possible to use a variable when using the Ope
workbook code. I already have the file name that I need declared as
variable in my code already and now all I need to do is place that nam
at the end of this code.

Workbooks.Ope
Filename:="\\C:\myfiles\SOMEFILENAMETHATCHANGESeac hmonth.xls"

Is it possible to have excel do this automatically or am I stuck wit
having to go in to VBA and edit the code each month

--
Phatchef2
-----------------------------------------------------------------------
Phatchef24's Profile: http://www.excelforum.com/member.php...fo&userid=1093
View this thread: http://www.excelforum.com/showthread.php?threadid=27504

Reply With QuoteReply With Quote