File porting and opening in an application with file path in excel spreadsheet

[tvsramesha]

Hi -

I'm working on a project, where barcode reader is used read the barcode containing the filepath into A1 cell of a excel spreadsheet, an automation is required to open a the file of the filepath in a application(GerbView), when again a different barcode is read the opened file in the application should close and new file should be opened addressed in the filepath.

Tried recording macro of excel, it doesn't work, pl let know if it is possible to do so? and appreciate any help in achieving it.

Thanks