kidvegas19
Technical User
Access/Excel 2003.
I have a table of data I would like to export to Excel. For each record in this table there is a link designed to take the user to the location where the related folder (and thus the support documentation for the record) lives. This table field is of the type 'Hyperlink'. The links look something like this:
When I use the OutputTo method in the macro builder the results in the spreadsheet boggle me. The column of links appears to be active but they don't go anywhere, or so it seems. Turns out each and every link on the spreadsheet is linked to the spreadsheet they are on. In other words, instead of being linked as what shows in the cells:
The link is to:
File:///\\C\Data\testfolder\table_index.xls
File:///\\C\Data\testfolder\table_index.xls
File:///\\C\Data\testfolder\table_index.xls
Fine. I'll try TransferSpreadsheet. This works except that this method apparently uses an apostrophe delimited type scheme as all the fields have an apostrophe as the first character which makes the hyperlink not a hyperlink. Removing the apostrophe makes the hyperlink a hyperlink and it links correctly.
What on earth am I missing/doing wrong? I can not believe that something this basic would be this impossible to do.
I can't attack this using code. I need to stick with the builders etc. I can't do post mortem work on the spreadsheet either. It just needs to be generated, work correctly, and be replaced when the next regeneration happens.
Any thoughts? Hopes? ROTFL'ing wondering why I would use those two methods instead of using......?
Thanks you for the help.
I have a table of data I would like to export to Excel. For each record in this table there is a link designed to take the user to the location where the related folder (and thus the support documentation for the record) lives. This table field is of the type 'Hyperlink'. The links look something like this:
When I use the OutputTo method in the macro builder the results in the spreadsheet boggle me. The column of links appears to be active but they don't go anywhere, or so it seems. Turns out each and every link on the spreadsheet is linked to the spreadsheet they are on. In other words, instead of being linked as what shows in the cells:
The link is to:
File:///\\C\Data\testfolder\table_index.xls
File:///\\C\Data\testfolder\table_index.xls
File:///\\C\Data\testfolder\table_index.xls
Fine. I'll try TransferSpreadsheet. This works except that this method apparently uses an apostrophe delimited type scheme as all the fields have an apostrophe as the first character which makes the hyperlink not a hyperlink. Removing the apostrophe makes the hyperlink a hyperlink and it links correctly.
What on earth am I missing/doing wrong? I can not believe that something this basic would be this impossible to do.
I can't attack this using code. I need to stick with the builders etc. I can't do post mortem work on the spreadsheet either. It just needs to be generated, work correctly, and be replaced when the next regeneration happens.
Any thoughts? Hopes? ROTFL'ing wondering why I would use those two methods instead of using......?
Thanks you for the help.