| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
prompt user to change source of links
I have an Excel based reporting pack that is linked to an Excel file
containing the data for my reports. The name of the Excel data file is changed at least twice a week and saved as a new version with a date suffix. When i open my report file I want make the user select the most recent version of the data file by changing links to this file and updating them. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prompt user to change source of links
Please describe the particular convention as to how the new filename is structured each week. ........is it something like "DataFile_030306", and "DataFile_031006", etc etc?..........something that Excel can predict based on today's date. Vaya con Dios, Chuck, CABGx3 "Bobak" wrote: I have an Excel based reporting pack that is linked to an Excel file containing the data for my reports. The name of the Excel data file is changed at least twice a week and saved as a new version with a date suffix. When i open my report file I want make the user select the most recent version of the data file by changing links to this file and updating them. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prompt user to change source of links
There would be no way to predict the name - I would like Excel to display the
explorer structure to enable the user to select a file. "CLR" wrote: Please describe the particular convention as to how the new filename is structured each week. ........is it something like "DataFile_030306", and "DataFile_031006", etc etc?..........something that Excel can predict based on today's date. Vaya con Dios, Chuck, CABGx3 "Bobak" wrote: I have an Excel based reporting pack that is linked to an Excel file containing the data for my reports. The name of the Excel data file is changed at least twice a week and saved as a new version with a date suffix. When i open my report file I want make the user select the most recent version of the data file by changing links to this file and updating them. Is there a way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prompt user to change source of links
Maybe you could just train them to use edit|links--
or use a macro to show that dialog: Application.Dialogs(xlDialogOpenLinks).Show Bobak wrote: I have an Excel based reporting pack that is linked to an Excel file containing the data for my reports. The name of the Excel data file is changed at least twice a week and saved as a new version with a date suffix. When i open my report file I want make the user select the most recent version of the data file by changing links to this file and updating them. Is there a way to do this? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
prompt user to change source of links
Jim Cone has a nice Add-in that may be of help to list the files in a
directory and allow you to select the one you want...........it's called ListFiles and is available at http://www.realezsites.com/bus/primitivesoftware/ hth Vaya con Dios, Chuck, CABGx3 "Bobak" wrote: There would be no way to predict the name - I would like Excel to display the explorer structure to enable the user to select a file. "CLR" wrote: Please describe the particular convention as to how the new filename is structured each week. ........is it something like "DataFile_030306", and "DataFile_031006", etc etc?..........something that Excel can predict based on today's date. Vaya con Dios, Chuck, CABGx3 "Bobak" wrote: I have an Excel based reporting pack that is linked to an Excel file containing the data for my reports. The name of the Excel data file is changed at least twice a week and saved as a new version with a date suffix. When i open my report file I want make the user select the most recent version of the data file by changing links to this file and updating them. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
| In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
| how do you change pathways (links) when consolidating spreadsheet. | Excel Discussion (Misc queries) | |||
| how would i change default user name all excel files | Excel Discussion (Misc queries) | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
