Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I pose a question for a better understanding of variables within my
spreadsheet. I have declared within "ThisWorkbook" Public Sub Workbook_Open() Public ver, Report, Week, Period End Sub Within Module 1, Sub Report1 I have given the variabes values Ver = 4 Report = "Report Week 1.xls" Week = 1 Period = 1 call Reports Sub Reports Routine that calls upon the variables mentioned above, eg. Workbooks.Add ActiveWorkbook.SaveAs Filename:="D:\Store Returns\Reports\" & Report, _ FileFormat:=xlNormal, CreateBackup:=False More code Windows("Poor Store Returns Ver " & ver & " 2003.xls").Activate but when run the variables are empty. Can anyone please help me to better understand where I'm going wrong. Regards Lee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I change a Name scope from local to Global? | Excel Discussion (Misc queries) | |||
How can I change a Name scope from local to Global? | Excel Discussion (Misc queries) | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Scope priviledges for locked/unlocked cells | Excel Discussion (Misc queries) | |||
Scope of range names | Excel Discussion (Misc queries) |