Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default Multiple Versions of the same file

one approach may be to use a hidden sheet in the master.
in one column store the file name and in the adjacent column, the path.

use the combobox/listbox rowsource property to display the filenames and then
load the file they choose.

--


Gary


"RSHF" wrote in message
...
On my workbook I have a combo box which lists slightly different versions of
the same sheet (The master sheet). I am trying to enable users to scroll
through the check box on the master sheet and click the version they would
like to view, and that version of the master sheet would appear.

Summary:
1 Master Sheet
10 Different Versions of the same sheet saved as different files with
different amounts and type of data.
Sheets (The 10 ten different versions) listed 1-10, in the combo box.
The User would be able to scroll through the combo box and select the sheet
that they prefer.

Any assistance would be greatly appreciated!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Versions of the same file Dave Peterson Excel Programming 2 January 3rd 07 06:48 PM
Multiple Excel versions. Naveen Mukkelli Excel Discussion (Misc queries) 0 May 16th 06 12:55 AM
multiple versions of a spreadsheet Nick Excel Discussion (Misc queries) 1 March 1st 06 01:17 PM
multiple versions installed? BorisS Setting up and Configuration of Excel 2 December 14th 05 09:41 AM
Multiple Versions Andrew Excel Discussion (Misc queries) 3 January 1st 05 04:38 AM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"