| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vba code to open workbooks | Excel Worksheet Functions | |||
| macro or code to open multiple workbooks | Excel Discussion (Misc queries) | |||
| Visual Basic code available for all open workbooks | Excel Worksheet Functions | |||
| Sharing variable values between open workbooks? | Excel Programming | |||
| VBA code for looping through open workbooks and worksheets | Excel Programming | |||
![Phatchef24[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
