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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BillTrAuthor Commented:
Can I load it from a text file instead of excel?
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
BillTrAuthor Commented:
I try it with the excel. The citrix server has excel 2003 though. Does that support Name Ranges?

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.