Problem solve Get help with specific problems with your technologies, process and projects.

File lookup within an Excel spread sheet

I have an Excel spread sheet that has been set up as a form. Within certain cells of the form I want to access a file on the iSeries to check the validity of the cell entered. I am not sure how best to do that. Can that be done with some macro in Excel or is Visual Basic or some other programming language needed to do that? Are there examples in an article, paper or book that has been published, or somewhere on the Internet that can help me learn how to do that kind lookup to a file on the iSeries?
The task you are trying to achieve will require some coding (since this is not only some bidirectional file transfer).

The following article might help you out.


Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

The Best Web Links: Tips, tutorials and more.

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.