Tech Problem Aggregator

Solved: Convert a Excel Sub to work in Word 2003

Q: Solved: Convert a Excel Sub to work in Word 2003

This is a sub routine designed for Excel 2003 that calls the 'Save As' routine and allows the user to input their own file name and directory etc. I would like to convert it to a Word 2003 routine can anybody show me how or suggest a method by which I can do the same in Word ? Word doesn't recognise the 'Application.GetSaveAsFilename' method in this routine.

I have tried using a MsgBox to define a file name and the use the ActiveDocument.SaveFileAs to save the file but I can't allow the user to choose his own directory using that method and its clumsy !

Dim file_name As Variant

' Get the file name.
file_name = Application.GetSaveAsFilename( _
FileFilter:="Excel Files,*.xls,All Files,*.*", _
Title:="Save As File Name")

' See if the user canceled.
If file_name = False Then Exit Sub

' Save the file with the new name.
If LCase$(Right$(file_name, 4)) <> ".xls" Then
file_name = file_name & ".xls"
End If
ActiveWorkbook.SaveAs Filename:=file_name
End Sub

A: Solved: Convert a Excel Sub to work in Word 2003

Try this

Application.Dialogs(wdDialogFileSaveAs).Show

Rollin

2 more replies
Answer Match 81.06%

Can someone please tell me how to convert a scanned image from Acrobat Professional 7.0 to a word document? Thanks.
 

A:Solved: Convert Acrobat Professional 7.0 Doc to Word 2003 Doc

6 more replies
Answer Match 78.12%

Hello,

I have a 27 page documents where some images and text are hyperlinked to different websites. When I use Word 2007 and convert to PDF, the links don't work.

Am I missing something here? How can I get around this?

I have Adobe Acrobat Pro 9 if that helps...

Cheers,

Dave
 

A:Solved: Word 2007 - Convert to PDF and links don't work

13 more replies
Answer Match 76.02%

I have a folder of documents created on Word perfect X4 that I need to convert to Word 2003. I have Word 2007 but have found that some with older Word versions (before docx) have trouble opening them.

I tried the Word batch conversion utility in the program but the docs came out garbled. This would save me a lot of time.

thanks!
 

A:Need to batch convert Word perfect X4 docs to Word 2003

It is not the conversion that is the problem, you need to make sure that Word 2007 is set to Save As "Word 97-2003" documents to be the default.
 

1 more replies
Answer Match 75.18%

I have several Word 2007 documents containing forms controls that I need to make compatible with Word 2003. When I save the 2007 doc as 2003, the controls become static content. I tried replacing them with legacy controls but can't get them to work. When I insert a drop-down list box, only the first entry in the list displays and there is no drop-down arrow allowing selection of other items in the list. Can you help?
 

More replies
Answer Match 75.18%

I have a report that contains macros to update all the information that is put in. It is in excel 97 and my business just recently updated to 2003 and now I get a compile error when I run the reports. How can I fix this error?
 

A:Solved: convert excel 97 macros to excel 2003 macros

8 more replies
Answer Match 73.92%

Is there a file I can backup so when I reinstall Word and Excel, I won't have to redo all my icons in the toolbar? I think it used to be normal.dot. Is that still the case?

Thanks
Peg
 

A:Solved: Word & Excel 2003 setup

Go to Start -> All Programs -> Microsoft Office. Somewhere in there is a settings transfer wizard which will do exactly what you want. I can't find the official documentation right now, but look in the menus for it, and follow the prompts.
 

3 more replies
Answer Match 72.24%

Well I'm puzzled and intrigued by the following:

I have two macros.
I started with one triggered in Word to search and replace for a string and replace with with another one.
The mcro opens an Excel file and stores the necessary data in an array and then the array's values are used to search and replace the corresponding strings in a word file:

Below is the code that works if you use it in Word
where fString is the search to look for and rString the string to replace it with, works perfect no problem here
Code:

Sub FindColALL(fString As String, rString As String)
' Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = fString
.Replacement.Text = rString
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = True
.MatchWholeWord = True
.MatchByte = False
.CorrectHangulEndings = True
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = False
.MatchFuzzy = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
End Sub

Now I decided to do it the other way. Open Excel, read the contents into the same array, then Open work (VBA references set and everything)
and do the same but calling it from Excel but the above code will not work,

Seems it doesn't recognize the Word commands even if the references are set.

I now use the following code... Read more

A:Solved: VBA Search and Replace (Word and Excel) version 2003

10 more replies
Answer Match 71.4%

Is it possible to convert an Excel spreadsheet to an MS Word document
 

A:Excel convert to MS Word

What you can do is copy a range of cells from Excel then in Word choose Edit>Paste Special and choose 'Microsoft Excel Worksheet object' from the list, click OK. The cells will be pasted in Word. To display these cells as they appear in Excel right click on the cells and choose Worksheet object>Edit. The cells will now be displayed correctly.
 

2 more replies
Answer Match 71.4%

Is it possible to convert a word or PDF doc to excel? I have a form that is in .doc and .pdf but rather than retype it into Excel I was hoping it is possible to convert it. Thank you
 

A:convert Word or PDF to Excel

6 more replies
Answer Match 70.98%

I have some documents that were created in Word Pro on Windows 98 - I am needing to get them into Word format and can't find any import filters - can anyone help please?

Thanks
 

A:Convert Word Pro To Word 2003

1. Try File-Open, change the files of type to Recover text from any document (please don't forget to change it back when you're done).

2. What happens when you try to open them now?

3. Do you have WordPro? Can you Save as to Word FIRST?
 

2 more replies
Answer Match 70.98%

Just learning (self teaching) about Group and Outlines in Excel 2003 as well as the RANGE command in VBA. (Client will not accept an Access 2003 Solution)

Perhaps the easiest way is to show what I am trying to do.
"SOLUTION" (outline level 1) "my SAP ERP"
"-SOLUTION AREA" (outline level 2) "Analytics"
"--PROCESS" (outline level 3) "End User Service Delivery"
"---Sub-process (outline level 4) "Employee Interaction Center"
"---Sub-process (outline level 4) "SAP Roles"
"---Sub-process (outline level 4) "Express Planning"
...
"--PROCESS" (outline level 3) "Strategic Enterprise Management"
Click to expand...

each of the sub-processes I identify as a group. each of the processes is also a group.
The cell-value in the sub process can be "yes", "no" or null.
If any of the subprocesses contain a cell value "yes", then the "owning" process must contain a "yes".
Similarly, if any of the PROCESSes in the SOLUTION AREA contains a cell value "yes", then that owning SOLUTION AREA must contain a "yes".

Now, of course, I can hard code this through a multiple "Range" VBA statements, but wonder if there isn't something more elegant.

Regards,

Grnadpa Brian
 

A:Solved: Can I work with Group names in Excel 2003 VBA?

Solved this issue by using the Access 2003 Outline capability.
 

1 more replies
Answer Match 70.98%

Hi all
I am working on a home project where I am trying to create a userform that consists of 2 controls (1 combobox and 1 listbox) that work as 1. So when I select a value within my combobox, the corresponding value from my source data is returned within the listbox (similar to the VLOOKUP function)
Example
My source data is contained on an excel spreadsheet (for instance A1:A5 is A,B,C,D,E and B1:B5 is 1,2,3,4,5)
If I use a VLOOKUP function within the spreadsheet itself and specify C, I get the answer of 3

I can create the userform with the controls and I can specify the sourcedata for the combobox (using the RowSource parameter), but I am not sure how I go about getting the listbox to return the corresponding values.

Any help on this would be greatly appreciated.
regards
Oldsmokey
 

A:Solved: Excel 2003 Userform controls work as one

8 more replies
Answer Match 70.98%

I need to convert some Excel doc's into word format on XP.
any help would be great.

Regards
Dave

More replies
Answer Match 70.56%

I have been used to using Word 97, but the company has upgraded me to 2003. I am using the Print Layout to create my documents, and when I create a hyperlink, the hyperlink shows up in underlined blue, but it won't work. It will work if I view the document in Reading Layout, but that doesn't do me any good, since that layout does'nt look anything like the Print Layout. Can anyone make any suggestions?
 

A:Solved: Word 2003 - Hyperlinks don't work in Print Layout

It works.
It's just that Microsoft, in its infinite wisdom, decided to make us Ctrl+Click for a hyperlink.

Otherwise, you can change the setting on your PC to NOT require the Ctrl key.
Tools-Options-Edit tab. Second checkbox on the right...

And don't you just LOVE that Reading Layout feature?
 

3 more replies
Answer Match 70.14%

Dear expert,
Needs to convert Word table (data) to Excel.
Using copy/paste does not work well as format are totally gone.
Have learnt to use:
1. For Word file, save as web page. Then close the word and file.
2. In Excel, Under Data menu, use Import External data, then import Data.
3. Choose the .mht file I have saved in Word.
4. New Web Query will pop up and choose options - check "FULL HTM Formatting to do conversion", check "USe the same import settings for the entire section"
5. Press import button and export to Cell A1
But the problem is ....
This still involves a lot of manual steps to do if there are a lot of files to be done.
Is it possbile to write the VBA in Word or write the script in Excel to do all the steps above?
Doc files in C:\Temp\Word\
Web files in C:\Temp\Web\
Excel files in C:\Temp\Excel\
Thanks for help.
 

More replies
Answer Match 70.14%

I am using the mail merge wizard in Word 2003 to create address mailing labels from a mailing list I saved in an Excel 2003 worksheet.

Everything is fine, I've tested is several times. But there's one very aggravating little problem.

The labels are all created with a space in front of the first line (name) on each and every label.

I want them to look like this:

John Smith
123 Main Street
Charlottesville, VA 22901

But instead they all look like this (the underscore I typed in is actually just a blank space):

_John Smith
123 Main Street
Charlottesville, VA 22901

I've tried everything I can think of.

The spreadsheet cells for names do not have an extra space in them before the names. I have one column in the spreadsheet called Name that has the entire name of the person I want to appear on the first line, so I'm not using separate values for first name and last name, it's just one: Name.

Please advise. Thanks so much!
 

A:Labels-Mail Merge,Word 2003 & Excel 2003-space at beg.of 1st line

Yup. It's a PITA. You need to NOT use the Address Block. Instead, insert the individual fields. See this article:
http://www.officearticles.com/word/insert_merge_fields_in_microsoft_word.htm
 

3 more replies
Answer Match 69.72%

I have a spread-sheet done in Microsoft Excel 2003, but I was wondering if it was possible to do something a bit clever with it.

What I have in the spread-sheet is two work-sheets (the tabs down the bottom of the screen). Now, one of these work-sheets is a list of DVD's that I want to buy, and the other is a list of DVD's that I already have.

What I want to do is to have something on the work-sheet of DVD's that I want to buy where I can check them off, or press a button, or something, when I buy them, and then it removes itself from that list and adds it to the bottom of the second work-sheet (with the DVD's that I already have).

I hope that makes sense! Any help would be appreciated.
 

A:Solved: Microsoft Excel 2003 Question (Connecting Work-Sheets)

10 more replies
Answer Match 69.72%

Hi

help with this would be very appreciated.

We run windows xp, word 2003 and excel 2003

we have created a mail-merge between our database of patients in excel and word, but when we come to the section where we tick the boxes next to the people required for the mail-merge we can select only 1 or 2 or 100, but when the mail-merge goes to the next section it has reverted to selecting the whole database of patients, which when your trying the send a letter to only a few people and it instead tries to print 5000+ letters is annoying to say the least.

i have tried changing the database to running from access, and i have started fresh and re done the mail-merge letter but this is all to no avail as the same error occurs???

any ideas,
please help
 

A:Mail merge problem using excel 2003 and word 2003

There may be some bad data within the columns that may be causing your issue. Look to see if there something out of the ordinary within the dataset you are trying to use for the mail merge. I think one may be column headings with spaces in them and another may be where two or more rows may have meen merged in your spreadsheet.
 

1 more replies
Answer Match 69.72%

I have a number of standard letters which require a dropdown box to be populated with a list of over 25 names.

When thinking this through, I figured that it would be best (due to restrictions on the network so I'm unable to use an access database) to produce this list in Excel 2003. Along with corresponding lists of email and telephone numbers.

Unfortunately I'm finding it very difficult to get the information onto the dropdown.

So far the code I have is:
Private Sub UserForm_Click()

'Define Variables
Dim xlNames As Excel.Workbook
Dim rsNames As Recordset
Dim cmbNames As ComboBox
Dim i As Integer
Dim SocServs As Worksheet

'open the spreadsheet to access the information
Set xlNames = Excel.Workbooks.Open("C:\Documents and Settings\00772367\My Documents\SocServs.xls")
'set up and activate the appropriate worksheet
Set SocServs = xlNames.Application.Sheets("SocServs")
SocServs.Activate

'retrieve the information from the named column in the spreadsheet
Set rsNames = SocServs.Columns(1, 1)
i = 0

With rsNames
' This code populates the combo box with the values
' in the Names column of that there spreadsheet (I fervently hope).

Do Until .EOF
cmbNames.AddItem (i)
cmbNames.Column(0, i) = .Fields("Names")
.Next
i = i + 1
Loop

End With
End Sub
There's a few errors in there, which I can't seem to surmount. The coding doesn't seem to recognise the fact that I've got a named range in t... Read more

A:Populate a dropdown box in Word 2003 from a list in Excel 2003

Is there any particular reason why you are needing to do this using VBA? You can populate a cell with your multiple choice options using Excel's built in Data Validation feature. Simply select the cell you want the options to appear in and click DATA --> VALIDATION and then select "ALLOW LIST" from the options. Then select the range of cells that contains your list of names.

Regards,
Rollin
 

2 more replies
Answer Match 69.72%

Hi - just looking for some help as getting a bit annoyed cos it's not working

I've got a table which contains people's details.

What I'm trying to do is if the person has no date of birth on file (i.e. they are over 18 year of age) for the merge to put a tick into a column, but if the person has a date of birth on file (i.e. under 18 years of age) for the merge to leave the column blank.

The column after this will contain the date of birth (if any).

In the over 18 box I've put the following function:
{ IF { MERGEFIELD DATE_OF_BIRTH } = "" "CHECKED/TICKED BOX SYMBOL" "UNCHECKED BOX SYMBOL" }

As each form will contain anything from 1 to 8 records, the lines which wouln't contain any merged data (i.e. if only 4 names to merge into a form, the last 4 rows of the form would be blank) - but it keeps merging in a ticked box for all the rows, even if there is only one row of data.

Hope this makes sense.

Thanks in advance for any help/advice.
 

A:Mail Merge - Help with Word 2003 & Excel 2003 using IFstatements

This does not sound like a merge function, it sounds like you are just validating data in a cell and based on that cells content putting a check in a check box.
 

3 more replies
Answer Match 67.62%

Hello,

I have created a 130 page report in MS Word that consists of figures and tables created in and linked from MS Excel. The idea is that this will be an annual document that will be updated on a regular basis. When updating, people would simply make the changes in the excel file and the Word file would automatically update. This was the plan...

The problem is when I try to update the links only about the first 60 pages update. After that I get this error " Error! Not a valid link". While I can maually update this by selecting the message and clicking F9, the size of the table has changed and the font changes from Arial to Times New Roman.

Any idea of how I can fix this. I spent about a week designing this and making sure all tables and figures fit nicely on the page.

Thanks for any and all help.
 

More replies
Answer Match 67.2%

At my work we have templates from Word 2003.

When we open them in Word 2007 they doesn´t work as they should.

We have for example a menu like

2 Electronics
2.1 Phones
2.1.1 Mobile phones

When you make an uppdate on the menu the sub-numbers disapear so it is
2 Electronics
Phones
Mobile phones

Also in 2003 you get a menu to the right where you can change in the list not only the types but also the numbering. Is there something like that in 2007?
 

A:Making Word 2003 templates work in word 2007

A couple of things.

Firstly here is an interactive guide for some of the features in 2003 - 2007. It is useful in some circumstances
http://office.microsoft.com/en-gb/word/HA100744321033.aspx

In regards to using 2003 templates for 2007 - i noticed that not all things worked in the same way in 2007 especially when it came to printing (things would display differently to how they would print)

I work for a big company and i had to redesign alot of templates. Sorry.

In regards to changing the numbering, you now right click on one of the actual numbers within the document and you can change the numbering from there.

Hope that all makes sense.
 

1 more replies
Answer Match 65.52%

I have several password protected documents from an old crapped out computer that are done in a very old version of WordPerfect and I cannot open them up in my current computer's "Microsoft Works Word Processor". The ones that are not password protected open up fine, but the ones that have password protection bring up the following Windows message: "Works cannot open (said document). The file may be in use by another application, the file may not be supported by any of the installed converters, or the file may be corrupt". I have tried all other "converters" that are a part of my Microsoft Works Word Processor. If my old computer still worked, I could simply remove the password and I would have no problem, but as you can see, this is not the case. Any help would be appreciated.
 

A:Convert PASSWORD PROTECTED WordPerfect files to Microsoft Work Word Processor

I just realized that the email address on file when I posted my question was obsolete, so I have just updated my profile with my new address. Sorry.
 

3 more replies
Answer Match 64.68%

Hi, I think I have a new one for you. I've seen this problem posted on other sites and no solutions ever addressed.

I'm mail merging a a mailing list onto sheets of ten labels, a different number of labels every day, anywhere from 30-200. I've used the wizard any number of times, always with the same result, never with an option or menu that provides a fix:
-- 1st sheet looks okay -- records 1-10 appear
-- 2nd sheet, records 2-11 appear
-- 3rd sheet, records 3-12 appear
-- etc, till there are as many sheets as there are records in the database. So for today's mailing list of 45 records, I had 45 sheets instead of 5.

The first label in my template has a header that says "Research Study" followed by the mail merge fields -- custom arranged, not using Address Block or anything preset. The propogated labels all say "<<Next Record>>" in front of "Research Study". I can provide an example if needed.

It also doesn't allow me to choose the order in which the emails propogate, i.e. I can go across but not down. I've done this many times in older versions of Word without these problems. I've used the Avery system, but I have to go thru the wizard each and every time when all I want to do is make a reusable template to copy and merge new records into each day.

Please help.
 

A:Labels-Mail Merge,Word 2003 & Excel 2003-labels repeating ad nauseum

11 more replies
Answer Match 64.68%

Word and Excel want to be reinstalled every time they are opened. When opening some other programs that have nothing to do with word processing, such as Reg. Mechanic, Adobe Photo Shop, Word wants to be installed. I have uninstalled and reinstalled frequently, but it still happens and if I don't do it the program just closes.
Any ideas please?
 

A:Word 2003 & Excel

Not sure why this happens, but have had a similar problem before. I solved it by completely uninstalling office. I even went as far as to delete the local user files for office. Then installed office, selecting custom install and then selecting to run all things of my computer. Problem sorted, although can not say what the problem was.

On my new computer I also have this sometimes, but it is because I have office 2003 and 2007 on the same machine. A reg edit more or less solved the issue, but in the end I had to also remove access 2007 and only have access 2003 on the pc.
 

2 more replies
Answer Match 64.68%

i cant open an excel file...i think i've tried everything. it's not just one file either. its any file that requires excel. help please.

A:Word Excel 2003

Hello stupidblonde,

Is there an error message that displays when you try to open the file?

15 more replies
Answer Match 63.84%

I really screwed up these programs. I downloaded a free trial of system mechanic and something happened to the programs. When I open word or excel a installer opens and trys to install the program but gets an error message that a cab file is missing. Error 1311 c:\msocache\allusers\90000409-6000-11d3-8cfe-0150048383c9\4t561401.cab The computer is a Dell and on microsoft site said I had to go to manufactor for help. They won't do anything except ot sell me the programs as the warranty is expired. Only other thing I can think of is to restore the computer to its origanal state but it would wipe out all the stuff on it. Tried to back it up on floppys but too many files 80,000. Any help woild be greatly appreciated as I have very little knowledge of computers. thanks

A:office 2003 word and excel

Hello

do you remember when you install the (system mechanic) ?

if to you can do this a long as you dont have the system restore turned of on your system

steps

start
select ( all programs
select (accessories
select ( system tools
select ( system restore

now you will be given the option to ( restore to a specific date or create a restore point

select (restore to a specific point

now a window will open with a calender on it

select a date that was befor you installed the (mechanic

then do the restore / now this may fix your issue and it may not

this is the issue with useing programs like this / they normally just make things worse or kill your system

hope it works for you

1 more replies
Answer Match 63.42%

Excel and Word are fine if I open a blank doc from the Quick Launch bar or even My Docs. but if I try to open either from an existing doc on the desktop, it takes forever and sometimes opens empty. Also if I try to open an attachment from Outlook Express. I have tried:
1) Making sure file associations are OK
2) Re-registering
3) Repairing Office 2003
4) Running sfc

I also sometimes find that if I have this problem, then I cannot get at my drives via My Computer.

Any ideas someone????
 

More replies
Answer Match 63.42%

Hey Folks,

So I'm hoping that someone here can help me out. I rebuilt my machine last week with a fresh install of XP Pro (SP2).

Four days later, Outlook started crashing whenever I tried to send a message (with Word as my email editor). So I checked out Word, and it would crash when I opened it. I sent the report to MS and of course, they recommended that I get all of the Office 2003 updates, which I did. Still, both Word and Excel crash every time I try to do anything in them. Outlook is fine now that Word is no longer the email editor, and the other Office apps work just fine.

Any thoughts on how to fix this one? I have tried reinstalling Office, but of course, since it never completely removes...yeah.

Helo would be greatly appreciated.
 

A:Word and Excel 2003 Crash All the Time

Hello

I have the same problem here. Windows XP+SP2.I tried the repair option in Office 2003 and the problem dissapeard but only for about 2 weeks, the it reapeard again. Then I uninstall and reinstall Office 2003 again and for now (3 days) it's ok.
Before uninstal I also tried installing Office SP2 but the problem was still there.

Any of you guys found working solution?

Thank you very much.

Gregor
 

4 more replies
Answer Match 63.42%

I finally got something to print on the labels. But it is all the mergefield jargon. Street number, etc. Not the actual information that I see on print preview. Can anyone either point me in the direction of an exact "how to" for this merge of labels for a mailing list including all the tricks for the problems existing in word 2003. Would love to go to sleep something tonight. Thanks.
 

A:Label Merge from Excel to Word 2003

Mail merge labels:
http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm

Mail merge issues:
http://www.officearticles.com/word/troubleshoot_mail_merge_results_in_microsoft_word.htm

Also, if you're still seeing mail merge fields, try Alt+F9 to STOP viewing field codes. This *could* be a problem you're having. See:
http://www.officearticles.com/word/view_field_codes_in_microsoft_word.htm
 

1 more replies
Answer Match 63%

Since installing Win10 I can't get 2003 Office Word to work.

It won't make links for email and web addresses, the wrong toolbars come up again and again, and it generally doesn't work.

Any way to fix this? I have tried with two different 2003 Office programmes, re-installing, but no luck.

Thanks

A:Word 2003 won't work.. any way to fix it?

I don't know if this is the solution, but I think that Office 2003 is so old that it works but has errors because of Compatibility. I had this same problem, so bought a subscription to Office 2016 and it all worked fine! ��

3 more replies
Answer Match 62.58%

I run XP Professional with Word and Excel 2003. I "think" my problem started after I upgraded to Office SP3. The apps open and close very slow. If I open Word without addins using winword.exe /a -- it's fine. How do I figure out what addin is causing the problem or does anyone know which one might cause this? It's making me nuts!

Ideas?

Thanks
 

A:Word/Excel 2003 Slow Loading and Closing

I had the same issue, and after reading your post I tried the winword /a also. Word opened in a few seconds. After some searching around I found an old autorecovery file in c:\documents and settings\myusername\application data\microsoft\word.
The name was something like "autorecovery save of .....".as$.
I deleted this file and now Word opens and closes normally again.

You should also check the Startup subfolder in the folder mentioned above. Move anything there to another folder temporarily and see if it helps. You could also try moving your normal.dot (and any other templates) from the Application Data\microsoft\Templates folder.

I've also seen this happen when accessing documents on a network share, when the local DNS settings point to an external (i.e. Internet) server as the primary, then an internal one as the secondary (it should be the reverse). You can check this from a command prompt using ipconfig/all.

Other than that you'd have to disable (or remove) the add-ins one by one to determine which it is.

Hope you got it solved already, but if not, hope this helps.

Steve
 

1 more replies
Answer Match 62.58%

Hi Guys
I am new to this forum and not very technical minded so please bear with me.

I have a monitoring spreadsheet through which i monitor c40 word docs. The biggest issue i face is that these words docs have a box with an expiry date on it. I normally have to open each word doc every week and update the date to current date. Then i go back in spreadsheet and manually update a column which has conditional formatting and goes red to alert me. For my purpose i will have the same date in all word files

WHat i want to achieve is to have a button in my excel file which when pressed updates the date in all word docs to current date. Word files will be closed during the update

I hope i am making sense

Thanking yo uin advance

Regards
 

More replies
Answer Match 62.58%

I have searched various forums, including this one, so I'm not sure there is a way to resolve this problem.

Every time I start Excel or Word [Microsoft Office 2003 Pro] I have to rearrange my toolbars. When I start Excel [for example], I'll arrange my toolbars [including dragging them]. After I have them all moved where I want them, I'll use Excel and then shut the app down. When I restart Excel, the toolbars will no longer be in the places I moved them to earlier. I have to rearrange them every time!

Is there a way to lock the toolbars in MS Office 2003 Pro, specifically Excel and Word?

Thanks!

Joseph
 

A:MS Office 2003 [Locking Excel/Word Toolbars]

8 more replies
Answer Match 62.58%

Hi all -- I have read a lot about similar complaints, but the solutions
are not working. I have a new DELL XPS, and installed my copy of office
onto it. Whenever i double click a document (Word/Excel)The program
launches, but the document doesnt load. I HAD Norton A/V on the system
when it was delieverd, but i uninstalled it as soon as I got it. After
reading, I thought maybe the offiveav.dll was still registered from the
old antivirus install, but i cannot find the file when searching in my system,
including hidden files/directories.
So now i have no A/V scan, had AVG, which was requesting a virus scan
of the doc before loading -- I removed it, and the virus scan message
disappeared, but the document still doesnt load.
I reinstalled office and also tried deleting the normal.dot file and
ran word to create a new one. All have not given me a solution. Also did a repair from the help menu in word without help.
BTW from within Word/Excel i can go to the open menu, and open any file
without difficulty, but I cannot tolerate this problem. Anyone else
with a sililar problem and possibly a solution.
Thanks in advance.
kraven
 

A:Canot open Word / Excel 2003 Files

16 more replies
Answer Match 62.58%

When I create a mail merge to merge number into a letter, the numbers show up with 14 decimal places. I am not trying to input money or any other number format into my letter, just simple two digit number. The number should look like 4.16., but looks like this: 4.1699999999999999.

I've tried changing the format in Excel, but no luck.

Any suggestions?
 

More replies
Answer Match 62.58%

Let's say I have data contained in Excel with each piece of data in an adjacent cell...

Name: Rank: SSN#:
Smith, John R SSG 123-456-7890

How would I take that information and merge it into a memorandum in Office, all in separate documents?

So say the memorandum looks like this:
Whomever it may concern,

Smith, John R., SSG, United States Army, 123-456-7890 has been certified blah blah blah blah

Sincerely,
Me

So if I had 50 names it would produce 50 documents or something?

Is that even possible?

A:Merging Data From Excel Into Word (2003 Or 2007)

I think you can use Mail Merge to do this kind of thing.

I'm guessing your spreadsheet is in the .CSV format?

If you are using 2003, I'm not sure what the headings are at the top, but with 2007 you need to choose the mailings tab and then select start Mail Merge.

Select the Wizard and you should then have an option somewhere down the line to import a data source.

After doing this you should be able to insert the merge fields which should look like <<Surname>> or something like that.

From this you should then be able to create a template letter and print all the records out.

Hope this helps,
Cornzey

7 more replies
Answer Match 62.58%

Hi Everyone!

I have a form that I created in Word 2003 (see attached). There are a few things that I’d like to accomplish with this form.

1) once the form is completed by the user, I want to be able to export the entered data into an excel spreadsheet (via macro button – submit/export - and VBA for the actual transfer of data?)
2) for 3 of the sections with radio boxes (employment type, rate your experience, and the 1st line of availability (1 shift/wk, 2shift/wk…)) I would like only one selection to be made. So the user can only select one of the options, and not multiple. Actually the Teaching Experience one…I need it so they can select whichever grades they teach, but only one selection of ‘years taught’. They can select any/all the MPMxx but it’s the ‘years’ that is important…

I have a very basic understanding of VBA but I work with excel all the time so I’m relatively comfortable with some things and willing to learn/try new things…

Can someone please point me in the right direction as to how I can accomplish this?

What I envision is the form being completed then sent back to me. I then hit a button embedded in the form that will then export the data to my excel spreadsheet where I can sort, etc…

Any help would be much, much appreciated as I’ve tasked myself with completing this…when maybe perhaps I should have tried to figure out how complicated this might be first…

Thanks for reading!!!
 

A:[VBA] Exporting Word 2003 Form Data to Excel

Files
http://www.mediafire.com/?xxexol8mexwi1ma

Okie, my objective here is to transfer the data from a word .doc into an excel spreadsheet. The form is all bookmarked with proper tags. I have started the VBA code, but I’m at a loss as to why some things aren’t working…


Sub Report1()
Dim path As String
Dim wdApp As Word.Application
Dim wdDoc As String
Dim curDoc As Word.Document
Set wdApp = CreateObject("Word.application")
wdApp.Visible = True
path = "C:\Users\xxxxxx\Documents\APPLICATION FORM\FINAL COPIES"
'Get first document in directory
wdDoc = Dir(path & "\*.doc")
'Loop until we don't have anymore documents in the directory
Do While wdDoc <> ""
'Open the document
Set curDoc = wdApp.Documents.Open(path & "\" & wdDoc)
Range("A1").Select
Selection.End(xlDown).Select

ActiveCell.Offset(0, 1).Value = curDoc.FormFields("DATE").Result
ActiveCell.Offset(0, 2).Value = curDoc.FormFields("FNAME").Result
ActiveCell.Offset(0, 3).Value = curDoc.FormFields("LNAME").Result
ActiveCell.Offset(0, 4).Value = curDoc.FormFields("EMAIL").Result
ActiveCell.Offset(0, 5).Value = curDoc.FormFields("OCT").Result
With ActiveCell.Offset(0, 6).Value
If FieldName = True Then
ActiveCell.Value = "PERMFT"
ElseIf FieldName1 = True Then
ActiveCell.Value = "LTOS"
ElseIf FieldName2 = True Then
ActiveCell.Value = "RET"
ElseIf Fie... Read more

2 more replies
Answer Match 62.58%

Hi,

I'm running a Win7 32-bit system with Office 2003 installed, all latest patches are installed as well. I have these periodic (and very sporadic) errors when working in a spreadsheet or document where the application stops working when copying and pasting information between sheets, cells, documents etc. and the computer freezes up and I have to reboot. The error is "Microsoft Office has encountered an error and needs to close". This has become very frustrating when working on templates and losing large amounts of information. I haven't been able to find any troubleshooting tips pertaining to these issues and it is happening across 3 or 4 computers in our network now. These are new Dell Latitude E6410 laptops with clean installs on them.

Anyone have any ideas?

Thanks,
~Chris
 

A:Excel/Word 2003 copy and paste crash

Have you ever sent an "error report" to MS? (I certainly never do, I'll admit.) I am curious as to what the error report generated would be - something to do with your anti-virus, perhaps?
 

3 more replies
Answer Match 62.58%

Well i did a big report on my computer with Word Perfect i couldnt print it so i took to school on my flash drive. IN my first class i edited it on Word 2007 and in the class i could print it they had Word 2003 and i couldnt open my file and now i cant even open it in word perfect. I doubt i can use the laptops for a while anyway i can open this on wordperfect
 

A:Solved: Word Perfect- Word 2003 - word 2007

If you saved the file in the "new" Word 2007 format (with a file extension of .docx) then you will be unable to open it in the other applications.

For Word 2003 you can install a converter, but I know of no XLM converter for WordPerfect.

When using Word 2007 you need to "save as" Word 97-2003 format to retain backwards compatibility.
 

1 more replies
Answer Match 62.16%

I am running a large survey for which I set up a Word 2003 file in order to match survey responses to the questions. The survey responses download in Excel 2003 format. I can locate the data source each time, but the records refuse to match up. There are nearly 200 entries in the survey -- some of the response fields are blank, but they still exist -- so going through and attaching each record becomes very confusing. I use the mail merge function and select a new data source, but just before the merge runs I get a window that says, "Invalid Merge Field, This merge field is used in the main document, but it does not exist in the data source." This is not true, of course, but from this point on, I have to connect every single merge field again. I can't figure out what is happening or how to fix this issue. Thanks.
 

More replies
Answer Match 62.16%

I am using Excel 2003 to create a database of hyperlinks to different paragraphs and then through the use of a macro I can create word documents. I inherited this macro from a different department and want to customize it for my needs. That being said I have no idea how to edit a macro this large and complex. What's the best way for me to post the macro and my questions, through email, message through this site, post it in this window? The macro is about 15 pages in length. Thanks.
 

A:Excel 2003 - Macro for creating word document question

First, welcome to the forum!!!

The best way for one of the Excel gurus to work on your problem would be to post your file, after you have removed any confidential data (make a copy and do the editing in it). If it is too large, zip it first (and zip is preferred to rar).
If you are unable to post the file (there seems to be a problem at times with people who don't have very many posts being able to attach files) just send me an email via my profile (include the URL link to this thread). I will respond to you and then you can send it to me, after which I will post it for you.
 

1 more replies
Answer Match 61.74%

Hello,

I am having issues with Word and Outlook 2003. I just upgraded them from 2000 and now I am running into a couple of issues. Help!

Microsoft Word 2003
- Can't highlight or select an area on my Word page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.

Microsoft Outlook 2003
- Can't highlight or select an area on my page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.
- Can't open Word document attachments only. I can open excel, pdf, etc..., but not Word.

I have restarted my pc, reinstalled office 2003, erased the normal.dot profile, removed the 11.0\Word\Data registry and no luck. Any solutions would be greatly appreciated. Thanks!
 

A:Can't highlight in Word 2003 and Outlook 2003. Can't open Word 2003 attachments.

9 more replies
Answer Match 60.9%

I would like to get this preferably into Word and be able to use the tab key to jump to the next entry. is there any way to do this?
Ho do I reduce the size of this file so I can upload it?
 

A:getting a document into excel or word and being able to work with it

7 more replies
Answer Match 60.9%

Help!
I am using Microsoft Office XP Professional - WORD and EXCEL
When I click on any of the Menu options - all that appears is a shadowy line at the right hand side and base of where you would expect the menu options to display i.e. the size varies for each menu item, there are no menu items listed.
I've had a read through other posts on the site to see if anything applies and can tell you:
- I can happily edit the document
- All the EXCEL and WORD shortcuts work i.e. F& conducts a spell check in word, F12 allows Save as
- I have searched for normal.dot (clicking on the widows icon in the lower right of screen and entering normal.dot in the search box) and can't find it!? a number of word document. A number (say 20) of seemingly random word documents re listed i.e. documents that I have created all with a file type of Microsoft Word Document
Many Thanks
JoGirl - Auckland, NZ
 

A:Word & Excel Menus don't work

Which year version of the programs are you using? Perhaps normal.dot should be normal.dotx. It is a hidden file.
 

2 more replies
Answer Match 60.9%

Can you write a macro that will copy something from excel and paste it into word?

If so how do you do it? Do you write the macro in Excel or Word?

Many thanks
 

A:Macro to work in Word and Excel?

Yes, this can be done. Describe in detail exactly what you are trying to do and I'll write you a sample macro. Where should the values appear in the Word document? Which cell values will you be using? If you could .ZIP and attach some sample files that would make things much easier.

The basic steps are:

1) Set reference to Word library in your VBA Editor in Excel
2) Create a new instance of Word Application within your Excel project.
3) Execute your code on the instance of Word application.
Code:
Dim wdApp As Word.Application

Set wdApp = New Word.Application

wdApp.Visible = True

wdApp.Documents.Open ("C:\Documents and Settings\DocumentName.doc")

'ADD MORE CODE HERE

WdApp.Quit
Rollin
 

2 more replies
Answer Match 60.9%

I'm having a very hard time with Word 03 Professional. For some reason, my macros have been disabled, and I'm not even allowed to make new ones. The exact message I'm getting is "The macro cannot be found or has been disabled because of your Macro security settings." My security settings are at low right now; I've went to Help>About Microsoft Ofiice>Disabled Items, but nothing is there. I'm not sure what to do next. Any help would be appreciated.

More replies
Answer Match 60.9%

When I bought my new computer its' 64 bit, I transferred everything from my old 32 bit computer and

everything went fine, but my word 2003  will not load the Pleading Wizard.  It loads everything else in the
word program but the PLEADING WIZARD, it was working fine in windows 10 at 32 bits
Does anyone know how to get my 2003 32 bit program to work on my new 64 bit computer?

More replies
Answer Match 60.9%

Hi,

I can enter values in the Page Setup dialog box, but the disappear during Print Preview or actual Printing. The other footers and all the headers are fine. I also tried entering a range through VBA, and that doesn't work either.

Other Excel files work fine.

Paul
 

A:Excel 2003 Left Footer Doesn't Work

It could be a margin issue. Can you post the file in question? If the data is sensitive, replace it with non-critical or nonsense data.
 

1 more replies
Answer Match 60.48%

I have a document that I did in MS Publisher and want to convert it to something else so a co worker can cut some items out of it. We use MS Word but I didn't see that in the save as. What can I do here?
 

A:Solved: Convert Publisher to Word

6 more replies
Answer Match 60.48%

I need some help...

i have a spreadsheet (excel 2007) and Column A is all IP Addresses, I need them to resolved to HOSTNames in Column B.

Is this possible? If so, how can this be accomplished?

I have searched the threads here and found one similar, but it required a text file. I would like to do this all from within Excel.

Thank you in advance!
Andrew
 

A:Solved: Excel - Convert IP to Hostname

12 more replies
Answer Match 60.48%

Unable to convert Word form to Excel form. Tried screenshot of Word form, pasted to Excel sheet and filled-up by text but the text itself always mis-arrange.Kindly help me please...

A:Convert Word form to Excel form

Rather my cherry picking and copying a few how to... suggest you follow the results here:http://tinyurl.com/zxfccfrIt's a google list found using:convert excel document to wordas the search term...

2 more replies
Answer Match 60.48%

As above.

Is there a software upgrade i need to do.

I have the password. comes up with...

"Word experienced an error while trying to open this file"

Thanks in advance

K
 

A:Solved: Can't open password protected Word 2007 document in Word 2003

6 more replies
Answer Match 60.48%

First, let me start by saying I am not an IT computer person, I have very basic knowledge (other than what I do for a living) about computers, and I really need instructions that are easy to follow, please?

I am a medical transcriptionist. I have hundreds of auto corrects on my current computer with Windows XP Word 2002 on it. I am needing to, if possible, copy the auto corrects from Word 2002 to another computer with Windows XP Word 2003.

I also have hundred of words that I have added to spell check that it would be great if I could copy those as well.

I do have a flash drive that I can save these to.

Can someone please help me in terminology and steps that a computer dummy can understand?

Thanking you in advance.
 

A:Solved: Copying auto corrects from Word 2002 to another computer with Word 2003

6 more replies
Answer Match 60.06%

Hi all, do you know if it is possible to word-wrap text around an inserted picture in Word 2003? Basically, I'm trying to create a class reunion program with a one-page bio of a person with his/her picture in the upper right-hand corner. I have pasted a picture and positioned it where I want at the top; however, it forces the text below it downwards, which is not what I want. Any ideas? Thanks in advance.
 

A:Solved: Word 2003 - Insert Picture/Word Wrap Question

Select the picture

Make sure the mouse pointer is hovering over the picture and click once with the right mouse button

Click once with the left mouse button on the menu choice "Format Picture"

Select the "Layout" tab

In the section called "Wrapping Style" click once with the left mouse button on "Square"

Beneath where it says Horizontal alignment click once with the left mouse button on "Right"

Click on OK

You should be able to type text to the left of the picture.
 

3 more replies
Answer Match 60.06%

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.
 

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...

http://officearticles.com/misc/best_install_procedures_for_microsoft_office.htm

Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

2 more replies
Answer Match 60.06%

I’m using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.NewSearch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

A:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

7 more replies
Answer Match 60.06%

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

14 more replies
Answer Match 60.06%

I have a JPG image of a simple text document. How can I convert this to an MS Word document?
thank you.
 

A:Solved: Convert JPG image to Word document

10 more replies
Answer Match 60.06%

I need to convert a doc into a tip or pdf file and I am lost....any ideas? Thanks.
 

A:Solved: How to convert a word document into a tif or pdf file?

Try CutePDF.
 

3 more replies
Answer Match 59.64%

I was recently sent a .wdb file that I needed to convert to Excel format. A Google search found this thread among other info. Since that thread is now closed, I'm posting this effective update to it.

I found a Java applet that can convert the .wdb file into Excel format here.

I just ran it on my Linux system and it worked fine. I was able to open the converted .wdb file in OpenOffice as an Excel spreadsheet just fine.

Hope that helps!

Peace...
 

More replies
Answer Match 59.64%

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks
 

A:Solved: Problem with Excel 2003 macros in Excel 2007

8 more replies
Answer Match 59.64%

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
Application.Quit
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled
 

A:Solved: Excel 2003 vba code not working in Excel 2007

16 more replies
Answer Match 59.64%

Like many others out there I'm sure my question will be redundant as searching has not shown any conversion software that won't cost me more than I can afford.

Looking to convert my old Lotus Notes emails to Out 2003.

Any Ideas?

Address Book is not a problem, I can handle that.

Thanks Rick
 

More replies
Answer Match 59.64%

I posted this question on MS Forums yesterday and received an e-mail that there was a response. The link to the post did not work and I find no response under my post. I'm hoping that Tech Guy is much better.

The desktop icons for both .doc and .xls files give error message that
program cannot find the file. Word or Excel opens and then I can click on
the icon and file will open or they will open from the open menu within the
program. They have worked in the past but suddenly stopped. Deleting the
icon shortcut and resending it from explorer do the same. I have run Norton
Registry Cleaner and no change.
 

A:Desktop Icon Shortcuts for Word, Excel don't work

Welcome to the TSG forums.
Have you tried doing a system restore?
If you spend a bit of time browsing the forums you will notice that most of us recommend NOT using a registry cleaner. They can cause many problems. Much more than they help.
Post back and let us know how the restore goes.
vicks
 

3 more replies
Answer Match 59.64%

When trying to open Excel 2000 on a XP SP 2 machine I get an error asking if I want to send to Microsoft. I can use Word and other Office products but Excel does not open. I cannot open it from the main icon or a saved spreadsheet. The saved spreadsheets are still associated with the program. I uninstalled and reinstalled Office as well to no avail. I saved a screenshot of the first section of the "do you want to send to Microsoft" error data and it can be seen in the url below. If you need to see more please let me know. Seems to be a problem with Windows, perhaps.http://s16.photobucket.com/albums/b14/daca...rent=error1.jpgThanks in advance.

A:Excel 2000 won't open; Word & Powerpoint work

This can be caused by a corrupted Com Add-In in Excel. Have a look here and slide down to Delete the registry keys for the COM add-insRemember to follow the instructions about backing up your registry as noted in the directions.Hope this helps,

3 more replies
Answer Match 59.64%

my system: vista 64 Ultimate, Office 2007, all updates, no viruses, 8 GB RAM, 750 GB HDD, C2D
Problem: I used to have office 2003. At some time word could not save anymore. so I switched to office 2007 thinking it is related to vista. when I start word 2007 I get the error message "could not create work file. check the environment variable". At first it wouldn't save either, but I fixed that by deleting the normal.dot It seems to work besides the annoying message. The other problem may be related: Excel can not save at all and crashes while trying and says: "MS Excel cannot open or save any documents because there is not enough available memory or disk space... to make memorey free...". all other Office applications seem to work well (haven't tried too much).
I googled and tried all the registry tricks (that's how I found the fix with deleting the normal.dot). I suspect at some time I changed something and can't remember what. but word 2003 worked at some time. I have reinstalled Office multiple times (deleted registry entries etc.) Nada. My links to the temp folders in environment variables should be correct. I had meddled with those at some point.
I searched the forum, haven't found anything. Sorry in case I overlooked something here.

Edit: I have the swap file size on "automatic", despite 8 GB of RAM. I only have one account (administrator)

A:Excel can not save, word cannot create work file

No one an idea? It happens in outlook too. but not when i start it, it sporadically pops up that it can't create that work file.
I really googled around and could at least solve it so that i can save in word, so i really tried before asking.

3 more replies
Answer Match 59.64%

After an automatic HP update, my Microsoft Word and Excel programs won't work and my files won't open.  What caused this and what can I do to fix the problem without losing my files?  I have files that are part of my work and I HAVE to have them ASAP.  Please help. Thanks in advance.

A:my microsoft word and excel programs won't work and files wo...

Hi: Try running the system restore utility and select a restore point to a time before the automatic HP update ran. If you are unfamiliar with how to use this program, please read the info at the link below. http://windows.microsoft.com/en-US/windows7/products/features/system-restore Then change you HP update program to notify you that there are updates and you choose when to install them rather than it being done automatically. That way you can run them and find out which one is blowing up your system and you can prevent that one from running the next time. Or you can just leave things as they are if they are working OK for you. Paul

8 more replies
Answer Match 59.22%

i made a table in ms word.
but i want to convert this table into execl sheet for data analysis.
only copy/cut from ms word and paste into execl sheet are not working as the whole table comes into one cell of the execl sheet and it doesn't serve my purpose to analyse the data.
the volume of the data is huge and re-entry into execl sheet takes lot of time.
is there any solution to convert this ms word data into execl sheet.
its urgent.
 

A:Solved: how to convert ms word table into execl sheet

16 more replies
Answer Match 59.22%

i have large Word docs (handbooks and policies & procedures) that i need to convert to spanish. is it possible to systematically convert text in Word 2000 to spanish?
 

A:Solved: convert english to spanish (Word 2000)

Unless you are a native speaker of español then I would say no. The online ones are riddled with errors.
 

1 more replies
Answer Match 59.22%

Created a worksheet with formulas, in Excel 97, and saved it on floppy and hard drive. Can open worksheet from floppy and hard drive in Excel 97 but not Excel 2003. Formula cells become #NAME?

Sample of formula:
='C:\blp\api\dde\Blp.xla'!BLP(C190&" equity","ask",,,RTD("BLOOMBERG.RTD","","IZU+UV Equity","ASK"))

How can I resolve? Thanks.
 

A:Solved: Can't Open Excel 97 File in Excel 2003

7 more replies
Answer Match 59.22%

When I open a spreadsheet in Excel 2003 that was created in Excel 97, the pages with macros open with only the columns showing. It looks as if the row that appears has an infinate length. I've tried changing the row hieght, and everything else I can think of, but can't view the spreadsheet normally. Other tabs in the spreadsheet do not appear either.
 

A:Solved: excel 97 display problem in excel 2003

10 more replies
Answer Match 59.22%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

A:Solved: Excel macro to extract Word form data into Excel

7 more replies
Answer Match 58.8%

I have got the problem, that for some weeks now I haven't been able to fill shapes by a color, using the filling effect either in word or excel 2007. There are no shadow or 3-dimensional effects activated.

Thank you very much for your help.
Kind regards

A:word and excel 2007 filling effect doesn't work

Try this :
Word 2007: Working with Shapes - Lesson 11

9 more replies
Answer Match 58.8%

So I have a batch of about 750 Word documents that need to be converted to RTF. I recorded a macro that looks something like this:

quote:

Sub rtf3()
'
' rtf3 Macro
'
'
Documents.Open FileName:="D:\user\Desktop\test\1.docx", ConfirmConversions:=False, ReadOnly:= _
False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
"", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
Format:=wdOpenFormatAuto, XMLTransform:=""
ActiveDocument.SaveAs FileName:="D:\user\Desktop\test\1.rtf", FileFormat:=wdFormatRTF, _
LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
False
ActiveDocument.Close
It works fine, but there are a couple of problems w/ it. 1, I have to repeat it over and over for each file, and 2, each repetition has to be edited w/ the next filename, the path to that file, and the new filename. I figured out a way to partially automate that process, but it's still a PITA .

Can't I just tell it to get all the .docx files in this folder and all its subfolders and save them as an RTF w/ the original filename?
 

A:Solved: Word 2007 macro to convert file types?

10 more replies
Answer Match 58.38%

Hello,

I have a list of email addresses that have either:
[email protected]
[email protected]
[email protected]
or no corelation to [email protected]

I'm looking for a macro that will take the emails with dots in them and put the first and last names into cells next to the email. The others I can do by hand. PLEASE HELP!
 

A:Solved: Excel Macro to convert email addresses to names

16 more replies
Answer Match 58.38%

i need to transfer my resume from word 2007 to word 2003 because this site im trying to uplaoded to wont take the 2007 format.

I cant open a 2003 doc with 2007..

Brilliant move by Microsoft

Any Ideas?

Thanks
 

A:Solved: Word 2007 doc to Word 2003 Doc

Firstly, Word 2007 can be set to save all documents in compatability mode (.doc instead of .docx). Just save as, or under Word options set it as the default

Secondly Word is full backwards compatible with earlier versions.

What exactly are your problems opening older document versions, what message do you get?
 

3 more replies
Answer Match 57.96%

Is there a way to clear, and add Fill color to an Excel spreadsheet? Please see the attached file.

I need this to be compatible with Excel 2003 & 2007.
 

A:Solved: Excel 2007 & Excel 2003

16 more replies
Answer Match 57.12%

I want to email a Word 2003 document(as an attachment) that has two hyperlinks to two different word documents files. I have tried this and everything works fine except when I ctrl + click on the hyperlinks the files won't open. How can I get this concept to work. I don't want to send a lot of files and attachments for the recipient to have to deal with.
 

A:Solved: Word doc. with hyprlinks to other word docs. won't work when emailed

16 more replies
Answer Match 56.7%

Boss gets a new digital picture frame and they want pics on it when he gets it. Saved a bunch of pics on a flashdrive and they work fine in it but at random it shows anyone it wants first and 2nd etc.

Have a new windows 7 computer and went to the HP Media photo part and was making a slide show so we could number what pics came up in order, I can save them to a flash drive with no problem but it has a .msl format and the frame won't play it , it can't even see that there are pics on it, I tried a couple of online converters to get it to .jpeg but it comes back error.

Can someone tell me how I can change the .msl to .JPEG I am going nuts we worked on it 3 hours tonight and my wife has been trying for days, I would just like to leave it and let it show them randomly but the boss wants certain ones shown first I will upload the file I saved so you can see the format or shouldn't I load one with pics of people and a farm business on it? I guess it comes down to converting .msl to .jpeg or some other way to get them to stay in order, she saved them randomly she had to scan everyones pic as they gavbe them to her and there are picsl of the building etc, we only need to get like 21 or 22 of them to go in order and then the rest can be random , PLEASE HELP--PLEASE NEED PEACE AT HOME.
 

A:Solved: Need an answer fast if possible for my wife for her work-please-Image convert

7 more replies
Answer Match 56.7%

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.
 

A:Solved: Excel search does not work Excel 2013

7 more replies
Answer Match 56.28%

Hi,

Recently, I'm having slow file loading while opening ms word files and excel files directly from windows explorer. It takes a minute to load, however it opens immediately if I open .doc files or .xls files directly from their application software. It also take a minute for MS Word and Excel software to shut down.

I have run my antivirus (Symantec) and MBAM but they all show no virus was found. I'm not sure what should I do next, please advice.

A:Microsoft Word & Excel - problem with opening files in Word and Excel

What version of Word & Excel?

6 more replies
Answer Match 55.86%

I don't have WORD on my computer, and got a wpd. attachment. I found out that 602 software will not read a WORD document.

Is there any software tool that convert a wpd. document to something my software can read? Or is some other software I can get (hopefully freeware) that can read WORD documents, or am I stuck having to get WORD in order to read a wpd. document?

Thanks in advance for taking the time to help me and others on this forum.

Your Friend,
John
 

A:Is There A Tool To Convert Word wpd. into something that non word software can read?

13 more replies
Answer Match 55.02%

Hello. I have some .xls files on a cd which I could open fine until yesterday. The files were created on my Acer Aspire 5732Z (Microsoft Windows 7 Home Premium system x64 - based pc) using Microsoft Office Excel 97-2003.

Yesterday, I opened the cd on a different laptop (Acer Aspire 5733 64 bit operating system - windows 7 home premium, service pack 1). This laptop opened the files using Microsoft Excel starter 2010. I saved the files back to my cd when I'd finished, then safely ejected the CD using the correct method.

Now when I insert the CD into either pc, it show the CD drive but there are no visible files, so I can't open anything. I tried the error checking tool, but it can't check for errors as it says "windows cannot access the disk".

Can anyone help me open the files please? I have all the files backed up elsewhere, except for the two I worked on yesterday, but I really don't want to have to type them up again unless I absolutely have to as it will take me many hours. Any help would really be appreciated. Thanks in advance!
 

A:Solved: Cannot access Office excel 97-2003 .xls files after opening in Office Excel S

6 more replies
Answer Match 55.02%

hello, i use word at home to do a lot of things, kids charts for their allowance, lists, just lots, but at work we use word perfect 10 so i send things from home to work to print out in color at their cost but cant seem to read or open them is there a way to get this done? and vise versa.. thanks

all using windows xp (is there any other program )
 

A:can you convert word perfect to word and back again?

6 more replies
Answer Match 55.02%

Hi All,

My office is upgrading from Office XP to Office 2010. We have a dozen different macros written for Office XP. They are all Word documents. Each produces a different form. Some have only about a dozen fields to populate. Others have up to 100 different options.

These macros run great in Word XP but crash when run in 2010 with a variety of VB errors. All our users are running Windows 2007 with the latest service pack.

Is there an easy method to upgrade these macros to 2010 format, without having to learn enough VB programming to recode all of them? I have an MSDN subscription and one idea was to try a gradual upgrade - from Word XP to Word 2003, then Word 2007, then Word 2010 - just alot of testing VMs to set up...

Thank you,

Mike C.
 

A:Convert Word XP Macros to Word 2010

Can you provide some examples of the code that is failing and include some of the error messages you receive? The issue could be as simple as differences in the object libraries that are being used. Without seeing the code it would be hard to tell.
Rollin
 

3 more replies
Answer Match 54.6%

Hey all,

Does anyone know if it's possible to convert macros from Excel 97 (Excel Basic) to Excel XP/2002 (Visual Basic) ? Or do I have to do these manually?

Any help is appreciated

Thanks!
 

A:Help!! Convert Excel 97 Macros to Excel XP (2002) ???

9 more replies
Answer Match 54.6%

Hi All.
How can I allow other users of my PC to use MS Word? ie Can I place a word icon on each of their Desktops?
Can each user password protect their Data & files?

Many thanks,
Brian.
 

A:Solved: MS Word 2003

6 more replies
Answer Match 54.6%

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Intel(R) Pentium(R) 4 CPU 3.20GHz, x86 Family 15 Model 3 Stepping 4
Processor Count: 2
RAM: 1022 Mb
Graphics Card: RADEON X300 Series, 128 Mb
Hard Drives: C: Total - 234778 MB, Free - 206308 MB;
Motherboard: Dell Inc. , 0J3492, , ..CN4811148P00UT.
Antivirus: Microsoft Security Essentials, Updated: Yes, On-Demand Scanner: Enabled

Have been using Word for a few years. Found that under Auto Caption there are many items that I created and no longer have any use for. The Word files for which I used the captions no longer exist. Tried unsuccessfully to clear them. No answer found in Help menu. Is there a way to delete the items?

Thank you.
 

A:Solved: Word 2003

6 more replies
Answer Match 54.6%

Hi has anybody got any ideas for the following problem.
I am running Microsoft Office 2003, I have a work folder that i store my Word 2003 files in and now for some reason and i dont know why but when i click on one of these files to open it as a quick way of starting word with the file i want to work on, i get an error it says

(The command cannot be preformed because a dialog box is open. Click Ok, and close the open dialog boxes to continue).

If i then click on ok it then loads the file correctly and i am able to work on it and save it but then the next time i want to open it i get the same message.

If i first start word by it self it starts ok and then go to open the same file it is ok.

Anybody got any ideas.
 

A:Solved: Help with Word 2003 please

7 more replies