Hi all I was wondering if anyone knew how to add in a text box prompt that will modify code?
'part 1 run in sample file Sheets("Master").Select Cells.Select Selection.Copy 'this window will change based on the date the user is checking if possible the prompt should pop up with everything punched in already so the user would only have to change the date/month. And the code would update itself for each time "Picking Differences XX-XX-XXX Daily.xls was referenced. Windows("Picking Diffences 04-01-2009 Daily.xls").Activate Sheets.Add Range("A1").Select ActiveSheet.Paste 'this is a static spreadsheet name Windows("productivity results for area.xls").Activate Sheets("Productivity Results For Area").Select Application.CutCopyMode = False Sheets("Productivity Results For Area").Move After:=Workbooks( _ "Picking Diffences 04-01-2009 Daily.xls").Sheets(2) Range("B5:B80").Select Selection.Copy Sheets("Sheet2").Select Range("D2").Select ActiveSheet.Paste Application.CutCopyMode = False Sheets("Productivity Results For Area").Select Range("A5:A66").Select Range("A66").Activate Selection.Copy Sheets("Sheet2").Select Range("E2").Select ActiveSheet.Paste Application.CutCopyMode = False Sheets("Productivity Results For Area").Select Range("E5:E66").Select Selection.Copy Sheets("Sheet2").Select Range("A2").Select ActiveSheet.Paste Application.CutCopyMode = False Range("B2").Select Calculate
Bookmarks