Word Title Property Dilema
Hi.
Previously posted to Word_VBA @ yahoo and Word_PC.
Word 2002 on Win XP. All up-to-date.
I have a template that runs a Document.New event. The main part of my
problem starts with:
ActiveDocument.BuiltInDocumentProperties("Title") = vDocType + vDate
I've also tried:
ActiveDocument.BuiltInDocumentProperties(wdPropertyTitle) = vDocType +
vDate
Where vDocType and vDate are declared variables and have values
assigned.
When a new document is created from my template the Title in the
Properties Summary tab has my document type and the date as expected
However the Contents tab in Properties shows either the first lot of
text in the document or the pre-populated Title from the template if I
have set it.
When a Save As is run my Title isn't the default filename. The text
from the Contents tab is being used. I have tried to overwrite the
Contents tab info by duplicating the above BuiltInDocumentProperites
task and putting it in an on click event from a userform but this
doesn't change the Contents tab info and therefore not picked up
during a Save As.
What I'm tring to do is have my text in the Title property so that
when a Save As is run my info is the default file name. I "can't" use
a Save As (not that I know of) because this is handled by a third
party password protected add-in. This would mean my users having to
do two Save As tasks. Not ideal. The other option is to break the
password of the add-in. Again, not ideal.
I'm hoping someone can suggest a way for me to set my default filename
so that when the add-in runs it picks up my Title property properly.
Thanks in advance.
Shane Tag: I found a tickets site Tag: 90520
Help with a macro required
I keep receiving the message "Run-time error 5941: The requested member of
the collection does not exist". I have created the following macro and the
line Indx = ActiveDocument.FormFields("fName").DropDown.Value is returning
the error. I am a complete novice but I have entered the drop down box in my
template and renamed the bookmark name to 'Name' as I think I'm required to.
The other form fields have been created . I have done the same with the
other Text form fields. Any assistance would be greatly appreciated.
Sub fNameExit()
Dim Name As Variant
Dim Address1 As Variant
Dim Address2 As Variant
Dim Phone As Variant
Dim Fax As Variant
Dim Indx As Long
Name = Array("Bundaberg Assessing Centre", "Cairs Assessing Centre", "Eight
Mile Plains", "Mackay Assessing Centre", "Maroochydore Assessing Centre",
"Rockhampton Assessing Centre", "Southport Assessing Centre", "Toowoomba
Assessing Centre", "Townsville Assessing Centre", "Zillmere Assessing Centre")
Address1 = Array("249 Bourbong Street", "Shop 50X, 537 Mulgrave Rd", "2649
Logan Road", "214 Victoria Street", "12-16 First Avenue", "Shop 22, Cnr
Richardson & Yaamga Rds", "239 Nerang Road", "176 James Street", "202 Ross
River Road", "E1A/605 Zillmere Road")
Address2 = Array("Bundaberg QLD 4670", "Earlville QLD 4870", "Eight Mile
Plains QLD 4740", "Mackay QLD 4740", "Maroochydore QLD 4558", "North
Rockhampton QLD 4700", "Southport QLD 4215", "Toowoomba QLD 4215",
"Aitkenvale QLD 4814", "Zillmere QLD 4034")
Phone = Array("(07) 4152 3377", "(07) 4033 6433", "(07) 3361 2890", "(07)
4957 2918", "(07) 5443 9422", "(07) 4928 7523", "(07) 5588 7719", "(07) 4632
2244", "(07) 4775 3999", "(07) 3862 9042")
Fax = Array("(07) 4151 4167", "(07) 4033 5672", "(07) 3841 6309", "(07) 4951
3831", "(07) 5479 3756", "(07) 4928 8458", "(07) 3841 6309", "(07) 4638
8819", "(07) 4775 4890", "(07) 3862 8803")
Indx = ActiveDocument.FormFields("fName").DropDown.Value
Indx = Indx - 1
ActiveDocument.FormFields("fAddress1").Result = Address1(Indx)
ActiveDocument.FormFields("fAddress2").Result = Address2(Indx)
ActiveDocument.FormFields("fPhone").Result = Phone(Indx)
ActiveDocument.FormFields("fFax").Result = Fax(Indx)
End Sub Tag: I found a tickets site Tag: 90518
Using VBA how do I return a line number on a page
Help! I am writing a series of tables from Access to a Word Template. To
avoid breaking the table over a page, I would like to calculate whether or
not a table can start on the current page or move to a new page.. It would
go something like:
If current line number < (total lines on page - 15), insert page break
How can I tell the code what line is being processed? Tag: I found a tickets site Tag: 90513
Macro not working
Can anyone help with the message: "Run-time error 5941: The requested member
of the collection does not exist."
The macro is as follows:
Sub fNameExit()
Dim Name As Variant
Dim Address1 As Variant
Dim Address2 As Variant
Dim Phone As Variant
Dim Fax As Variant
Dim Indx As Long
Name = Array("Bundaberg Assessing Centre", "Cairs Assessing Centre", "Eight
Mile Plains", "Mackay Assessing Centre", "Maroochydore Assessing Centre",
"Rockhampton Assessing Centre", "Southport Assessing Centre", "Toowoomba
Assessing Centre", "Townsville Assessing Centre", "Zillmere Assessing Centre")
Address1 = Array("addresses included here")
Address2 = Array("Bundaberg QLD 4670", "Earlville QLD 4870", "Eight Mile
Plains QLD 4740", "Mackay QLD 4740", "Maroochydore QLD 4558", "North
Rockhampton QLD 4700", "Southport QLD 4215", "Toowoomba QLD 4215",
"Aitkenvale QLD 4814", "Zillmere QLD 4034")
Phone = Array("phone numbers inserted here")
Indx = ActiveDocument.FormFields("fName").DropDown.Value
Indx = Indx - 1
ActiveDocument.FormFields("fAddress1").Result = Address1(Indx)
ActiveDocument.FormFields("fAddress2").Result = Address2(Indx)
ActiveDocument.FormFields("fPhone").Result = Phone(Indx)
ActiveDocument.FormFields("fFax").Result = Fax(Indx)
End Sub Tag: I found a tickets site Tag: 90510
Opening a template from vba
How can I open a template from VBA (and get its associated vba code executed)?
I want to create a new document, based on that template, all this from vba
code....
--
thanks Tag: I found a tickets site Tag: 90509
unable to save in word perfect(can not oen file).What is wrong?
In Microsoft word we are unable to save to a file. When do this it says
unable to open file. Also sometimes it freezes while we are typing a rpoet
word perfecty also. Tag: I found a tickets site Tag: 90507
Inset MS Project into a Word template
I am trying to create a word template using MS Word 2003. One section of
the template will be formatted as Bullets and subheadings. How can I apply
this formatting to a form field in a template. Obliviously I don't know how
many bullets a person using this form will need, so need to leave room for
it to expand, at the same time keeping the formatting standardized.
Thank You Tag: I found a tickets site Tag: 90506
How to set up the new German spellchecker?
I downloaded and successfully installed Service Pack 3 for Word 2002, the
only Office XP program I am running. All other Office applications are
version 2000. Trying to install the new spellchecker hotifix
officexp-kb923347deu.exe fails due to a missing .msi image file. When I
extract the exe file all I get are 3 msp files and 3 read-mes.
How can I install this spellchecker hotfix? The "Check for updates" utility
did not even bring this patch up.
Thanks,
Antje Tag: I found a tickets site Tag: 90504
Add Bookmark text to a header or footer
Is there a way to add a bookmarked text section from the main document to
header or footers? So that if the Text in the body of the document changes,
this is auto populated into the header or footer?
Would this be better done in VBA or is there a straightforward way of doing
it without adding code to the template?
X-posted in .word.newusers Tag: I found a tickets site Tag: 90493
Need help fixing software update conflict
purchased pc with software (60 day trial of Office 2003) and purchased
Microsoft Works Suite, loaded it and can't use Word. What do I need to do? I
already tried deleting the 60 day trial. I tried downloading updates to see
if this fixed the problem but it still remains? Tag: I found a tickets site Tag: 90483
Help with creating wizard for forms
I am a beginner in creating forms and know very little about visual basic.
I want to write wizards that will pop up on initiating a document template
to help me in filling in forms.
Can anybody tell me where I can find a simple web site or book to start
with?
Many Thanks
Ed Tag: I found a tickets site Tag: 90482
Making a macro loop
I often need to copy an itemized bill from the Web in order to sort it. I
copy and paste it into Word and it comes in as one huge paragraph. I want to
format it into paragraphs, then convert it to a table using the spaces
between each column to separate into cells. I've written the following macro
to format break each line of data into a separate line (paragraph), but I
need to make it loop. Can anyone tell me where and what code to insert to
make it loop until it reaches the end of my unformatted text (when there is
not another / or : to be found)? Here's what works manually, without a loop:
Sub Phonebill ()
Selection.Find.ClearFormatting
With Selection.Find
.Text = "/"
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindAsk
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchKashida = False
.MatchDiacritics = False
.MatchAlefHamza = False
.MatchControl = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
Selection.MoveLeft Unit:=wdWord, Count:=3
Selection.TypeParagraph
Selection.Find.ClearFormatting
With Selection.Find
.Text = ":"
.Replacement.Text = "^p"
.Forward = True
.Wrap = wdFindStop
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchKashida = False
.MatchDiacritics = False
.MatchAlefHamza = False
.MatchControl = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
Selection.MoveRight Unit:=wdCharacter, Count:=1
End Sub Tag: I found a tickets site Tag: 90478
how to insert page number for word document from current page
hi experts,
i am facing a problem while inserting page numbers in a word document. i
have 30 paged document. And i want to insert the page number starting from
the 6th page only. not for the first five pages. how to do that?
plz suggest.
with regards,
beulah daniel Tag: I found a tickets site Tag: 90467
Dropdown list question
I need help trying to figure out how to do something in Word 2002. I have a
form that I am trying to automate. I have a dropdown list with selections
for all of my local courthouses and one selection is for out-of-county
courthouses.
What I want to happen is if the form user selects one of the local
courthouses, that selection will display but if the form user selects
"out-of-county courthouse" I want the dropdown list to disappear or become
hidden and activate 2 or 3 text fields where the form user would type in the
out-of-county court information.
I also want the results of this to duplicate in one other location on
another page of this document. It is a 3-page form. Tag: I found a tickets site Tag: 90466
Replace tab with break
Please help me find the third Tab Character in each paragraph and replace it
with a Manual Line Break.
NB I might need to change to second or fourth Tab Character.
Francis Hookham
(I thought I had posted this request but I cannot find it - please excuse me
if this IS the second request) Tag: I found a tickets site Tag: 90458
How do I add query field values to text in VBA?
Im a novice at this but here is what Im trying to accomplish. My
office has hundreds of memos going out on a regular basis. All of
these memos go to a set group of people from a set group of people.
Those people change based on the sender and recipient. The body of the
memos is based on a set number of subjects. I have most of this
automated now but the problem is that in VBA using the Select Case
Method I have told access what to show for the body based on the
subject but the body contains information that needs to be a field from
a query. How do I reference that field? For example a memo to a car
dealer about new cars would have a set body, part of which is the
contact information from the person sending it. So the body would be
something like this:
Dear Mr. [Owner of Dealer]
My office is interested in purchasing 3 new vehicles from your
dealership. When you have time to discuss specifics please contact
Purchasing Officer [PO] at [Phone Number].
Sincerely,
[PO]
Keep in mind that the body of this memo needs to be calculated as well
based on the subject the user selects. I hope this makes sense. My
job has nothing to do with cars but I cant comment on what I do so the
example probably confuses things. Thanks in advance for any help you
can provide!
Rob Tag: I found a tickets site Tag: 90448
Macro to look for highlighted text and delete it
I want the macro to look through the document for any text that is
highlighted (it will be in yellow), and delete the text, and remove the
highlight.
I'd appreciate any help.
Thanks,
J.O. Tag: I found a tickets site Tag: 90446
Can date format be changed
I have a number of paragraphs which start with the date in the format
05.09.2006
that is dd.mm.yyyy
Please can you write a macro to find dates in dd.mm.yyyy format
and change them to d mmm yy format, that is 5 Sep 06
Having seen how to do that, I take it that it would be straight forward to
change instead to ddd, d mmm yy (Tue, 5 Sep 06) or ddd, d mmmm yy (Tue, 5
September 06) if I wished.
Many thanks,
Francis Hookham Tag: I found a tickets site Tag: 90444
VBA question for "save as" function
I am creating a Macro that will save the currently open .doc file as a .txt
file of the same name. In the following line, what do I need to change/add
to make the file save as the same name as the currently open file?
ActiveDocument.SaveAs FileName:="<current filename>.txt", FileFormat:= _
I am new to VBA, and I don't know what the code callout is for the current
filename, and I know that is what has to go in the line of code where I have
"<current filename>" typed in for this example. I also realize that I will
not need the quotation marks around the code command.
--
I'm just a simple man, trying to make my way in the universe... Tag: I found a tickets site Tag: 90441
Unable to "Save AS" document...I get a read only message.
I am unable to "save as" a document in word. Even though I am the
administrator and have not choosen "read only" I am unable to save a
document after making changes when I try to save to my E drive. This is not
removable media, it is a hard drive. If someone can help me I would
appreciate it. I have tried uninstalling and reinstalling, I have tried
changing the file name...etc.
--
BSimon Tag: I found a tickets site Tag: 90437
How can I reset page number in a Page field in the middle of doc?
I am trying to create a template where the page numbers reset in the middle
of a document. I need to use a Page field to hold the page number. Is there a
way to reset the page number with a switch or something?
Thanks Tag: I found a tickets site Tag: 90434
Hide CheckBox FormField
Hi,
I have a work template which has 2 check box form fields. I try to hide one
of the check box depending on user enter information from a text field. is
this possible? How can do this.
And also, can I change a text formfield's backgroud color to different color?
Please help. Tag: I found a tickets site Tag: 90433
Run-time Error 5981 "could not open macro storage"
One of my coworkers recently started getting these errors when opening a Word
document, and she doesn't remember changing any settings. She still has
Office 2002 and I checked the macro security settings - they are low. I also
made sure the Trust all add-ins,etc was checked. I'm thinking it might be a
corrupt template, but there's about 8 different macros listed and I don't
want to mess up her defaults and other settings. Is there a way to get rid of
those error messages?
Thanks. Tag: I found a tickets site Tag: 90430
hide page number when Landscape
Hi,
I am trying to hide page number when the page property is Landscape. My
word document contains pages in both portrait and landscape view.
Or it will be really cool to write something like ...if page property
is Landscape ....show page number at x" from to top and y" from right..
The main problem is i am new for macro and stuff....
Seeking your help.
web address to get these information will also be helpful
Thanks
musa.biralo Tag: I found a tickets site Tag: 90429
voice recognition it would be nice to have more training availabl
I would like to see more training available for the voice recognition program
installed in windows X. P. it is a very good program to have but there still
is a lot of errors in the typing that I speak out I am using it right now to
write this text but I think with more training available. I think it would
be a lot more accurate. If somebody knows more information about how we
greatly appreciate some information to know if I'm doing anything wrong . I
would also like to know if I should read to the training program all over
again will that greatly affect the way I speak and the machine understand my
voice? Please respond to this someone at your earliest and the if need be
please e-mail me at just_I_32@yahoo.com I am mostly using that e-mail so
please feel free to e-mail me at your convenience or just posted here thank
you.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=a5e13b37-a088-403c-adc3-1e643997ead2&dg=microsoft.public.word.vba.general Tag: I found a tickets site Tag: 90428
how do i set up random numbers in a cell & row?
here is what I am trying to do: I have 6 rows like so
01 01 01 01 01 01
goin down rows 1-5 I want random numbers from 1-55, In row 6 I want random
numbers 1-42. How do i do that? Tag: I found a tickets site Tag: 90425
count-if
hi!
i'm a novel programmer in vba and i am looking for a funtion or procedure
that returns the number of times that a specific character appears in a
given paragraph
I´ll put an example to explain myself better:
dim text as string
dim count as integer
text= "name * surname * age "
' XXXXX is my desired procedure:
count= XXXXX(text, *)
' this procedure must return '2', that is number of asterisks
anybody knows if there is any vba funtion to make the count? or some idea to
construct my procedure? Tag: I found a tickets site Tag: 90417
Add a hyperlink to dropdown box
When designing a web page in Word, how can I put a hyperlink into a dropdown
box? I would like it to show the short name and not the URL. I have several
pages I would like to list and give others a choice. Tag: I found a tickets site Tag: 90410
Using Bookmarks to store User Form data, how to hide?
Hi there,
I'm automating our company's standard documents. The idea is to
collect info about the document and author, and automatically fill this
in at spots in the header and footer. This is to standardize how it's
input so users don't have to worry about getting the right format.
Previously, I used a stack of ASK fields to collect the info into
Bookmarks, then put cross references in the header and footer. I put
the ASK fields on the front title page, which doesn't get used much and
so were out of the way of stray keystrokes. This worked well since the
ASK fields were "invisible" unless you toggled field codes. But all
those dialog boxes in a row were a bit tedious.
So now I've created a User Form that collects all the info in one spot
and inserts the data into Bookmarks.
I inserted the Bookmarks on the title page like I had the ASK fields,
but now I realize that the full text of the Bookmarks is showing up on
my page!
My question is: How can I make these Bookmarks invisible like the ASK
fields?
I have already moved the obvious Bookmarks off the title page and into
the header and footer (Doc No., Doc Title, etc), but some of the
Bookmarks I will only use as cross references later in the body of the
document (which doesn't exist yet) such as Customer Name.
I've tried highlighting the Bookmarks on the title page and selecting
Font > Hidden, but when I insert a cross reference, the formatting
comes along and the reference is also hidden!
Is there any kind of switch or place I can stash Bookmarks that will
make them invisible to the user, yet be easy to cross reference to?
THANKS,
Matt Tag: I found a tickets site Tag: 90404
Paste text to currently open document
Hi all,
I have such a problem: I wrote sub to copy text form one doc to
currently open document. I attached this sub to button I would like it
to insert text form another doc in the selection in document which I
edit. But instead of inserting text to currently open doc it copies
text to the file from which this sub takes text:
Dim OpisKryterium As New Document
Set OpisKryterium =
Application.Documents.Open(SciezkaKryterium(NrKryt))
Dim TekstOpisu As Range
Dim DlugoscTekstu As Long
DlugoscTekstu = OpisKryterium.Characters.Count
Set TekstOpisu = OpisKryterium.Range(0, DlugoscTekstu - 1)
Selection.FormattedText = TekstOpisu.FormattedText
OpisKryterium.Close
Set OpisKryterium = Nothing
Set TekstOpisu = Nothing
I think that it is because of this line:
Selection.FormattedText = TekstOpisu.FormattedText
but I tried to do it with ActiveDocument but result is the same. So how
can I reference to currently open doc.
Please help.
Regards,
sweet_dreams Tag: I found a tickets site Tag: 90397
read and write chinese words
Hi,
I want to read chinese, traditional chinese,korean,japanese words from word
doc and write it into text file. But I have no luck up till now. I have no
problems with french and german languages but these other 4 languages just
can't be written into the text file. It'll leave some empty blank spaces
into my text file.
Code so far:
Const ForWriting = 2
Dim objFSO, objFile
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("C:\TCS.mtp", ForWriting)
Dim counter as integer
do while
lineArray = Split(theTable.Cell(caseStartRow, 2).Range.Text,
Chr$(13))
objFile.writeLine (lineArray(counter))
counter = counter + 1
wend
objFile.close
Please help if there is anyone know how to solve the problem. Thank you so
much!
John Tag: I found a tickets site Tag: 90394
Adding AutoText to all headers and footers
Is there a way to add an autotext entry to ALL headers and footers in a
document no matter if there is a different first page or not, or if
there are multiple sections or not? Tag: I found a tickets site Tag: 90392
Calcuate on Exit Bug?
Maybe I don't really understand what checking calculate on exit does for a
form field but I've never seen this before. I've got a form with about a
dozen fields, some of them are calculations but...
well what they are doing is MULTIPLE calcuations as you tab through the
fields. They don't calculate just once...they REPEATEDLY calculate the
formulas everytime you tab out of a field in the document. so 200 becomes 400
becomes 800 becomes 1600, etc.
This won't work, and I have other Word forms with Calculate on Exit that
don't act this way at all. Am I missing something or is my document bugged? Tag: I found a tickets site Tag: 90391
Word ComboBox values in txt file
Is there a way to reference the choices provided in a drop down list of a
Combo Box from a txt file or macro stored in the Word Template? I have a
Word Form with many combo boxes that should have the same choices but need to
store them outstide of the code because I get an error that the code is too
long. Tag: I found a tickets site Tag: 90390
Are single field calcuations possible?
How do I get a form field to perform a calculation on a number that the user
puts in it?
I know how to do it with multiple fields like =(Field1)*(Field2) but what if
I want it to equal what the user puts in this field itself /12, for example?
so If I have one field in a document that is supposed to display how much
the average person makes in a year based on an hourly rate. The field would
need to accept the user's input (the hourly rate) and automatically multiply
that number by 2080 and the change what they inputted to show the result.
is that possible? Tag: I found a tickets site Tag: 90383
Creating a format for headers
I would like to create a format in word that makes it possible to transfer a
word from the text to a header. For example, if I write:
"This is my header"
in the text, I would like to be able to mark that text and chose a format
which automatically converts that text into a header.
Does anyone understand what I mean? And if so, is it possible? Tag: I found a tickets site Tag: 90381
Create macro in a template?
Yesterday I submitted a question about disappearing macros. It was suggested
that I create a macro in a template that I should save in the Word Startup
folder. How do you save a macro as a template? Tag: I found a tickets site Tag: 90380
macro to make picture in-line with text
hi all,
wxp pro sp2, office 2003 pro sp2,
i have a large document with lot of figures (300+). it just transpires to me
that as a result of collaborative work, we end-up with a mix-bag of figures
that are in-line with text, square or tight in layout.
i wonder whether someone would be kind enough to provide me with a macro
that would enable figures to be changed to in-line with text, if this is
macro-able. or is the solution one of swallow the bitter pill and
check/convert figure 1 by 1?
thanks for your advice/help,
jes Tag: I found a tickets site Tag: 90370
Word version independent macros
Hi,
I have created word template with some subs and functions. Generally
this macros, copy content of other .doc dokument and paste it to active
document, create tables and format text. I created this template in
wrod 2003. But it turned out that this template will be used on
computers where are Word versions form 97 to 2003 and in the future
perhaps 2007.
So my question is what can I do to make this template (especialy macros
in this template) Word version independent? Can I use objects like
ActiveDocument, Selection??? Or Should I rewrite this macros using late
binding???
Any help, suggestions will be appreciated.
Regards,
sweet_dreams Tag: I found a tickets site Tag: 90365
Selecting just one word in document
When I use:
Selection.Words.Count
with nothing selected I get Selection.Words.Count =1
I get the same result when I actually select just one word (which I
expected).
Likewise if I use Selection.Words.First, I get then next word after cursor.
How do I know if the user REALLY just selected one word?
thanks Tag: I found a tickets site Tag: 90362
Setting savepath through Word Automation.
Hi.
I'm currently using MS Word automation to open up a template and fill
in user information automatically based on the person who opened it.
However I can't figure out how to set the savepath so when the user
chooses to save, the save dialog goes to the path given by me.
Does anybody have any solutions regarding this?
Best regards
Svein Arild Tag: I found a tickets site Tag: 90360
pop up messages when printing or sending
Is there a feature in Word to automatically show pop up messages when
printing or sending a document? If not, what would the Visual Basic code be
to make this happen? Tag: I found a tickets site Tag: 90353
Transfer Calculator Result
I know how to display the Microsoft calculator in Word.
MS says that a two step 'Copy/Paste' operation is the only way to capture
the result of a calculation. Is there any way via VBA to more directly
capture the answer and automatically get the calculator's answer into the
document or into a form field (by clicking one button, for example)?
Thanks,
Ed (in Virginia) Tag: I found a tickets site Tag: 90352
Macros in Office Basic vs. Office Professional
I have documents whose macros run fine in Word in Office Professional but do
not run at all in Word in Office Basic. I need to use the documents on both
computers. How can I make this work? Tag: I found a tickets site Tag: 90351
how to insert a picture to a word document
how to insert a picture to a word document,and align Center both Horizontal
and Vertical Tag: I found a tickets site Tag: 90349
Creating a second word instance to run my project (Word 2000)
Hello
I have one last obstacle to overcome with my project. At this stage it is
working more or less as i want it, application is hidden with only a userform
in view, and my labels are printing out fine, time after time of button
clicking, documents are opening and closing correctly etc etc.
My (final???) problem now is that when I close the applicatiion the way I
need to, ie Application.Close wdDoNotSaveChanges - so that its ready to be
used again another time, it also closes with it any documents that are laying
open at the bottom of the screen - this could well cause much anguish amongst
the users who (hopefully) will be using it in our office, and I'm sure to
become little miss unpopular!!
I think one option, if it can be done, would be to fire up the document in a
new instance of word, separate from the one that is already open with
documents at the bottom of the screen. Is this possible, and if so can
someone point me in the right direction of where to place the required code.
I have seen some code in a book that will open an instance of word from
another program - do I do this in the same way? And where should the start
up code be placed?
Thanks Tag: I found a tickets site Tag: 90345
VBA Code
I have a seeming simple task that I can't figure out.
I have a macro set up to refresh a query and then do some copying and
pasting of cells.
What code can I use to tell the macro to wait until the query is finished
refreshing until it does the copy and paste?
Here is the simple code.
Sub GetData()
ThisWorkbook.RefreshAll
' I need the following code to be run after the refresh is finished'
Range("J5").Select
Selection.Copy
Range("J6:J65000").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWindow.LargeScroll ToRight:=-1
Range("D1").Select
End Sub Tag: I found a tickets site Tag: 90343