Why does an Excel Macro work with a path to the default doc lib on a site but not with a...

Hi Georgi,

maybe I should specify a bit. I am talking about a public Sharepoint Site, here I have a list of Subsites which I want to export. I know it works for an "Intranet" with document libraries and lists, but for a Site library on a public sharepoint site, the
menu item does not exist.

Cheers

Ingo

Hello

Thanks for the answers. But that's not what I'm looking for.

I search for a solution to "unlink" the fields in header and footer. For example a date field, which updates when I print or open the file.

In word I can do this with a macro, but in excel and powerpoint that solution didn't worked.

Hello Asher,
<br />thanks a lot for your reply.
<br />I have already tried the link you have mentioned. To use the Microsoft Support page does not work for me. I got forwarded from article to article but it does not fix my problem. Finally I found a MS phone number I called, but without success since the recorded voice recommend as "private user" check the web support page. I turn in a cycle.
<br />I also spend a lot of time with my Microsoft Account at "payment and billing". But always I got forwarded to the Microsoft Support page.
<br />So, I wrote the above request to the community to see if someone can help.
<br />Thanks
<br />

Note, your code puts your textbox, not in-line-with text, in the top right corner of your document. If that is where you want it, the building block can create it there.

You still have not explained why you want to do this with a macro.

I know of no way to, using vba, directly insert a content control mapped to that node. someone else may. The only way I can do it is using a Building Block.

Hi Dave,
<br />Thanks
<br />But what if I need such a large number for calculations, the one with the ´ is no longer a number?
<br />If you do not know why this is the case, it is not a drag because I do not need a calculation for my current case.
<br />Is just to expand my knowledge.
<br />Sincerely, Felix
<br />