Pages

Search

Microsoft Word - Word UserForms: Saving .addItem answers in an Array

Microsoft Word - Word UserForms: Saving .addItem answers in an Array

Word UserForms: Saving .addItem answers in an Array

Posted: 11 Dec 2012 10:48 AM PST

I have a number of UserForms where I have to use .addItem to populate comboboxes.

In some cases, I just create the .addItem entries manually in the Initialize stage.  In some other cases, I have Word VBA grab data from a local Access database.

In either case, this process can take a very long time, up to a minute.  It works, but it takes way too long.

It would seem to save time if I could save, on first use, the .addItems items in an array for the entire Word session.  While I use VBA quite a bit, I have no experience with arrays (and since some of the .addItem's have 2 or more columns, I'd need a multi-dimensional array).

How could I do that?

TIA

Problems printing labels -- comes out grey?

Posted: 11 Dec 2012 07:29 AM PST

I'm using MS Word 2007. Trying to print Avery Shipping Label 5164. When I print the label the background comes out grey on the whole sheet of labels.  How can I fix this?

When I am trying a mail merge in Office 2010, Word says it can't find the data file. The file is saved as a Word document and I don't understand why there is a problem.

Posted: 11 Dec 2012 03:07 AM PST

I am new to Office 2010 but am pretty sure I have followed the steps correctly.

changing a number of paragraphs into one paragraph

Posted: 11 Dec 2012 01:21 AM PST

Could you please suggest a macro to change a number of paragraphs into one paragraph?

Want to convert Word spreadsheet files to Microsoft Office Excel files

Posted: 10 Dec 2012 06:39 PM PST

Original title: spreadsheet converter

 

 

How can I convert my Works Spreadsheet files (.xlr), to Microsoft Office Excel files (.xlsx) without losing my information. Is there a converter that will do this for me and where can I get it.

How to make table margins obey margin settings?

Posted: 10 Dec 2012 03:37 PM PST

Hello:

When you set page margins, and add a table to a page, you can drag the table edges outside the set page margins without "punishment" :-). How would you make the table edges obey the page margins? And/or where can you see the margin values for the edges of a table?

Sorry if this is simplistic, but I actually have never seen answers to the above questions, although I have only used 2010 for a while.

Regards,

Hans L

Microsoft Word has converted text to "pdf" that is not readable. I don't know how to change it back.....and also, my computer boots up in "test mode"...

Posted: 10 Dec 2012 01:21 PM PST

I use Windows Vista Premium Home Edition and Microsoft Office 2007

Word stooping when trying to open existing Doc's

Posted: 10 Dec 2012 09:20 AM PST

Hi  I have Microsoft Office Profesional 2007 installed on Vista. When I open Word and attempt to open an existing file in my documents, Word "stops working". I have uninstalled Office and reinstalled but it made no difference!!! When I open a file direct from my documents Word runs OK.
Richard

my office shows unlicensed product and won't edit documents

Posted: 10 Dec 2012 07:10 AM PST

I can't edit, save or create new documents on microsoft office

Recover MS Office 2010 Files After Trial Period Is Over.

Posted: 09 Dec 2012 09:51 AM PST


I have downloaded the 60 day free Ms Office 2010 Professional.  I will be doing some work and send files to my friend.  My question is, will my friend be able to view and make changes (if required) in those files which I created, once the 60 day free period is over? My friend has a 2007 Office version. I will not purchase the product once the free period is over.

Thx