访问Excel超链接，新问题检查旧帖子 [英] Access to Excel Hyperlinks, New question checked old posts

问题描述

对不起伙计们，这是在扼杀我。


我已经打了几个星期这个问题，但无济于事。我将查询结果导出到Excel工作表，其中一列来自链接到共享驱动器上的文件的超链接字段。


我无法获取超链接被分配。我可以更改字段名称，但不能更改超链接地址。无法理解。


1）我有一个标题行

2）第16列是超链接的位置


这是：

Sorry guys, this is killing me.

I have been fighting this issue for several weeks, to no avail. I am exporting the results of a query to an excel sheet, with one of the columns being from a field of hyperlinks that link to files on the shared drive.

I CANNOT get the hyperlinks to be assigned. I can change the field name, but not the hyperlink address. Can''t figure it out.

1) I have a header row
2) Column 16 is where the hyperlinks are

Here it is:

展开 | 选择 | Wrap | 行号

推荐答案

我知道你已经检查并找到如何将Access中的超链接字段导出到Excel - VBA （我必须删除在你意识到你需要在你自己的帖子中发帖之前你把它放在那里。


这可以帮助你我'肯定，但首先你需要考虑你的代码的基础知识。您的代码中似乎没有任何内容可以建立任何Excel链接。首先查看应用程序自动化。


您的代码似乎如此遗失，很难知道你在哪里。让我们首先解决基础知识，然后我们可以从那里开始修复超链接情况。

I know you''ve already checked and found How to export a hyperlink field from Access to Excel - VBA (I had to remove the post you put in there before you realised you needed to post in your own thread).

This can help you I''m sure, but first you need to think about the basics of your code. It appears that there is nothing in your code which establishes any link into Excel. Check out Application Automation first.

Your code seems to be missing so much it''s hard to know where you''re at. Let''s get the basics sorted out first then we can move on from there to fixing the hyperlink situation.

Roger，谢谢NeoPa。


让我发布所有内容。我想我会切入它的追逐，但我们走了：

Roger, thanks NeoPa.

Let me post all of it. I was thinking that I would just cut to the chase of it, but here we go:

展开 | 选择 | Wrap < span class =codeDivider> | 行号

一般情况下你可以做（并且在可能的情况下这是一个好主意），但是你必须包含相关数据，否则你的代码将无法识别。


你是否只是简单地写了一条评论，简要说明了什么代码已经完成以及对象变量指向的内容（就像你为编写SQL字符串的代码所做的那样）也可以起作用。


无论如何，没有伤害，没有犯规。我会看看我是否能找到一些时间来详细讨论这个问题。此刻即将结束午餐时间，因此必须随时挤进。

Generally you can do (and it''s a good idea to where possible), but you must include the relevant data or your code will not be recognisable.

Had you simply included a comment saying briefly what the code had done and what the object variables were pointing to (much as you did for the code formulating the SQL string) that could also have worked.

Anyway, no harm, no foul. I''ll see if I can find some time to go through this in some detail soon. Just coming to end of Lunch-hour at the moment so will have to squeeze in as and when.

这篇关于访问Excel超链接，新问题检查旧帖子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！