Another totally different question...which may be well over my head.
In a Module called Getinfo i have a sub called GetData. In this sub i have the following piece of code...
' Retrieve data from closed workbook - Change each YEAR
GetValuesFromAClosedWorkbook "L:\Stocktake Info 03-04", "Turnover 03 - 04.xls", _
"Daily Turnover", "A1:AG1000", "TempDailyTurnover"
GetValuesFromAClosedWorkbook "L:\Stocktake Info 03-04", "Turnover 03 - 04.xls", _
"Weekly Turnover", "A1:AG1000", "TempWeeklyTurnover"
EDIT: The bolded text is passed to another sub
The bolded section has to be changed each year. What i want is a macro that Looks in this sub for the Workbook it points to (only workbook linked in project) and displays the reference and asks the user to type in the new reference. The code is then changed and we are all go. This way the code is not accessed by anyone but the new workbook each year can be entered into the code.
Hope that makes sense.
thanks
Kyle
In a Module called Getinfo i have a sub called GetData. In this sub i have the following piece of code...
' Retrieve data from closed workbook - Change each YEAR
GetValuesFromAClosedWorkbook "L:\Stocktake Info 03-04", "Turnover 03 - 04.xls", _
"Daily Turnover", "A1:AG1000", "TempDailyTurnover"
GetValuesFromAClosedWorkbook "L:\Stocktake Info 03-04", "Turnover 03 - 04.xls", _
"Weekly Turnover", "A1:AG1000", "TempWeeklyTurnover"
EDIT: The bolded text is passed to another sub
The bolded section has to be changed each year. What i want is a macro that Looks in this sub for the Workbook it points to (only workbook linked in project) and displays the reference and asks the user to type in the new reference. The code is then changed and we are all go. This way the code is not accessed by anyone but the new workbook each year can be entered into the code.
Hope that makes sense.
thanks
Kyle