Recent content by GrodanBoll

Hi I have made som templates for my company that I now would like to copy to the users comuters via vbscript. But I can't find the variable for words template path (i.e. 'C:\Documents and Settings\Andreas\Application Data\Microsoft\Mallar') i can only get the template folder under the user...

And the dicussion continues at http://www.vbaexpress.com/forum/showthread.php?p=43542 Thanks =] Grodan

Hi and thanks for your answers. =] The custom properties are copied to a new document if I have them in any other template than "Normal.dot". And if I understand fumeis answer correctly that is the way it works? So I should put the code to create the properties in the Document_New sub as...

Hi :) I have some custom properties in my templates (i.e. letter.dot) that I use. And these work like a charm. I also have the same custom properties in the Normal.dot but they will not reproduce when I create a new document based on this normal.dot. Why is that? Thanks Grodan

Used ' 'Updates all fields in the document. 'From: http://www.gmayor.com/installing_macro.htm ' Sub UpdateAll() Dim oStory As Range For Each oStory In ActiveDocument.StoryRanges oStory.Fields.Update If oStory.StoryType <>...

Hi In my template I reference custom propertie fields (DOCPROPERTY) via the reference fields. When I close my user form that I use to populate al the custom properties I do a print preview in my code to update all the reference fields. The reference fields in the headers and footer gets...

Thanks, I'll try this out. =]

Ah, sry for the bad spec. it looked clear in my head. ;) Today I have built up some templates with VBA and userforms. But I don't really have the time to update and create new ones for my work. So, I was thinking of some new way of creating simple templates that are easy and fast to create. I...

Hi I'd like to replace the popupform I currently are using in my word templates with an invisable (at print) table instead. Is it possible to use a certain cells value to reference in other parts of an document (for example headings, header, footer)? If so, can you give me a push in the right...

Thanks a bunch sleipnir214. =] Ur function was much nicer and cleaner, i'll steal it if U don't mind. ;] Regarding that the last element was not showing, I hade an coditional error in my 'for' loop ($i <= count()). =/ Thanks Grodan

Hi :) I have filled an array with data containing a hierarchical structure. $testarray = array ( 1 => array ( "id" => 100, "descr" => "etthundra", "parentId" => "root" ), 2 => array ( "id" => 200, "descr" => "tvåhundra", "parentId" => "root" ), 3 => array ( "id" => 300, "descr" =>...

Thx Jock1970. :) That was the answer I was looking for. Sry trqchina if my post was diffuse. /Grodan

Hi I'm about to create a time rapport for my work. In a cell I'd like to write a desciption for the hours. But in this description I'd sometimes like to have a row break to make my description easier to read. I've tried SHIFT + RETURN but it doesn't work. Can I do this? Thanks :) Grodan

Thanks alot PHV, U saved my day. Sometimes it's hard to start something new and then it's very helpful to get a push in the right direction. Thanks again. Hope U have a nice weekend! :) /Grodan

Hi I have treid to search the forum and the faq but I can't find the answer. I have created ia function in VBA in 'ThisWorkbook'. Now I'd like to call the function from a cell in my worksheet. I have tried to use '=test01(Typ)' like if i'd call a predifined function but it does not work, I get...