Does anyone know a workaround for the problem of word always asking to save changes to an attached template? Maybe using the DocumentBeforeSave option in VBA?
Many thanks
Does anyone know a workaround for the problem of word always asking to save changes to an attached template? Maybe using the DocumentBeforeSave option in VBA?
Hi there.
2 quick questions that i've been trying to workout today, but to no avail.
Firstly, what is the difference between using the show method for a userform, compared to the load method....
and secondly, is there any benefit in writing the code for a userform, or writing it in a module...
I'm trying to find a way for a user to undo a macro in word without having to press the undo button loads of time. Is there a way for VBA to remember what it's done, but not list loads of "VBA" entries in the undo dropdown?
Many thanks
thom
I'm opening a series of excel files using the code below
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set xlWB = xlApp.Workbooks.Open("L:\Shared\CCFP\FACTS&BR\Offwork.xls")
Set xlWB = xlApp.Workbooks.Open("L:\Shared\CCFP\FACTS&BR\Onwork.xls")
Set xlWB =...
I now have a lovely long procedure that's doing everything that i want it, i.e grabbing bookmarked information from lots of other documents on a monthly basis and combining it into one monthly report.
It's just that it looks a little messy when it running with the screen flashing away like...
I'm able to break links in a word document from excel using:-
With ActiveDocument.Sections(1).Range.Fields
.Unlink
End With
Where "1" is the section of the document where the links are to be broken.
Where i'm having a problem is trying to break the links in a header or footer!
Any...
Hi.
Is there a way using code to close a document without saving, thus preventing the "do you want to save" box coming up with some documents.
Many thanks
Thom
Hi.
Does anyone know what {.......} either side of a word means in Word? It seems to be hidden text as it's not printing, but it's making formatting a document a nightmare. It stays there even when all formatting marks are hidden.
Many thanks
Thom
FYI. A problem we had today with photoshop was that it would not save to our main server, saying "could not save as "bla.psd" because the disk is full", even though we had over a Terabit of free space.
It turns out that that was exactly the problem. The sever had recently been upgraded to a...
Hi. I'm putting this here because there isn't a XP Home forum it seems.
How does one delete a user account and all the files and folders associated with it in XP home?
Many thanks
Thom
Me again.
One last thing. Using VBA I am opening a document in one directory and then saving it to another. I'm wanting to know if its possible for VBA to see if the document is already in the destination directory, and if it is... stop and say so.
Many thanks
thom
Does anyone know of a way to have word automatically update links with out it comeing up with the "Do you want to update links etc etc." box when you open the document. I've set all the links to "automatic" in the links dialog box, but this doesn't seem to do the trick
Many thanks
Thom
Hi. I hope someone can help.
I'm using Word XP and in VBA I am wanting to loop though a whole directory of documents, and copy a selection of text from each which I've already defined using bookmarks then have that text pasted in an existing large document!.
I'm ok with getting the bookmarks...
I was wondering if anyone know if, with Version 7 you should get the same pantone color libraries as you do with version 6.5, as I've just been upgraded and only have 5 or 6 libraries.
Many thanks
Thom
This is probably a silly question, but i need confirmation.
We've upgraded from Acrobat 4 to 6, and we are now getting a lot of users complaining that Acrobat Distiller no longer comes up as an installed printer! Is is correct??
Many thanks
Thom
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.