I am creating a sheet in VBA that retrieves a file from a
FTP server. It parses the information from the file and
creates separate configuration file for each line item on
the text file being retrieved. I have a template to create
the original files and I have a naming convention:
Copy c:\TemplateFileName.xls to
c:\Folder\TemplateFile_device.xls
On the original sheet, I create a hyperlink for the user
to access these files. But, when the user hyperlinks to
the workbook the Active X components (radio buttons) are
not displaying properly. A few other things are weird
also. But, it I open the same file by either File-Open or
double-clicking, everything works fine.
I have heard that Excel's hyperlink function has
limitations, but I haven't heard the specifics.
If anyone has any advice, it would be appreciated.
Thanks,
Amanda