[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

Accessing local file data via citrix

We have a citrix based excel app that includes a drop down list. The list shows all the accounts on the backend database. It's getting very large and since the Users access just the accounts they support, some kind of a favorites list would be very useful.

I was thinking that this was very hard because I expected it to require a change to the database, where I'd have to maintain the association between the user and their favorites.

But, another way to handle it could be to write out a file to the User's cdrive that could be pulled in on the next session.

Anyone done something like this?
Thx!

0
BillTr
Asked:
BillTr
  • 3
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello BillTr,

In your Citrix setting, I can save files to my C drive by using the path

\\Client\c$\Documents and Settings\<myUserName>\My Documents

I have an Excel file called favs.xls in that folder with a range name called Favourintes.

In my Citrix environment I can open that file and then create a range that references the local file. With the local file open, I just need to refer to

localFavs =favs.xls!Favourites

I can then use the range name localFavs in a data validation list in Excel.

When I close the local file, the range name definition for localFavs changes to

localFavs ='\\Client\c$\Documents and Settings\<myUserName>\My Documents\favs.xls'!Favourites

With the local file closed, the data validation no longer works.

Hence: yes, you can use a local file, but in order to use data from that file in data validation drop downs, you must

- have the local file open
- Create a range name in the Citrix file that references to a range (or a range name) in the local file
- in data validation of the Citrix file reference the range name of the Citrix file.

Hope that makes sense

cheers, teylyn


0
 
BillTrAuthor Commented:
Can I load it from a text file instead of excel?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I guess you could open the text file from within Excel, but you'd need to ensure that its content is in a structure that can be used for data validation.

If the text file consists of a column of account number, that is probably doable. If the text file is more complex, or if the rows contain text strings with spaces, you'd need to ensure that it opens nicely and is not thrown by the settings in the user's Text-To-Columns preferences.

cheers, teylyn
0
 
BillTrAuthor Commented:
I try it with the excel. The citrix server has excel 2003 though. Does that support Name Ranges?

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Yes.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now