Over 1 million tech questions and answers.

Word doesn't recognize Excel and Access file types

Q: Word doesn't recognize Excel and Access file types

This problem has probably been addressed here before, but I haven't found it, so will ask it again. Word is supposed to allow data access from other files types such as Excel and Access, for mail merge source and other file linking. These file types are not recognized by Word. If I try to open an Excel file as a data source, all I get is a text file with garbage and a message box asking how to convert it.
Using Office 2003 with all patches and fixes. OS is Win2K with all patches and fixes.
I suspect it is a problem with OLE or DDE, but I don't know how to track it down. I've tried repairing the Office installation with no success.
Thanks for any help.

Preferred Solution: Word doesn't recognize Excel and Access file types

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Word doesn't recognize Excel and Access file types

Read other 11 answers

Well every single picture link someone sends me over MSN messenger works, except for .png format.

I want them to open with the internet from msn, my pc already recognizes .png because they already open fine on my pc with windows picture and fax viewer.

When i try them i get this error:

A:Windows won't recognize file types


Read other 2 answers

I had old word perfect files that converted to word -- however i had organized them using file extensions (such as .frm to signify forms). I have renamed them without the extensions and assigned them to word but under the type heading they still show as WPD File. How can i change the file to show as word file types

A:Changing Word file types

First, open Windows Explorer.
Hit Tools-Folder options.
Hit the View tab.
Make sure you're VIEWING file extensions.
This should bring some light to what's occurring.


I STRONGLY recommend NOT doing what you're doing anymore. Windows has always been such that it depends on file extensions to know what kind of file it is.

Instead of using file extensions to tell you what type of file it is, use folders instead.

Put all your forms in a folder called forms, or put the frm in the filename BEFORE the file extension.

Windows recognizes Word documents as having a DOC extension. If you use this method, you can then simply double-click a DOC file to have it open in Word. If you use FRM, Windows won't know what the heck program it should use.

I could tell you how to set Windows to open FRM files from Word, but that is a WAY bad idea because Windows counts so much on file extensions....

Read other 2 answers

I?m running Office 2000 in Windows 7 64 bit, & it?s been working good except for Outlook, & don?t care about Outlook. I?m getting ready to install Office 2007, & would like to install both Office versions (2000 & 2007).

The MS site said this is possible. To avoid conflicts, it said to take a few steps before installing Office 2007. The 1st is to rename Office 2000 startup links. All I?ve done so far is rename the links (e.g., "Microsoft Word" to "Word 2000"), & nothing else. Office 2007 has not been installed, & I?ve made no changes to registry or anything else.

Word is now giving me 2 startup problems. It?s as if Word is no longer registered with Windows.

1) The User Account Control (UAC) now activates every time I start Word. The UAC asks if the program (winword.exe) should be allowed to make changes. It also shows the publisher as ?unknown.? This includes starting Word manually from within its directory (C:\Program Files (x86)\Microsoft Office 2000\Office). Word runs OK after clicking "Yes" in UAC.

2) The Word start icons are not recognized by Win 7. I get blank generic icons in the Start Menu & Taskbar. I did unpin those icons from the taskbar & start menu before I renamed them.

Can anyone help me fix this?

A:Windows Doesn’t Recognize MS Word

the original winword.exe may have been overwritten

Have you tried an installation repair of Office 2000?
To do this:
Go to programs & features in the Control Panel
Scroll down and select Microsoft Office 2000 and there should be an option to Change/Repair

Office 2007 would work better on Windows 7 as it has current update support and will integrate better with windows

Read other 2 answers

In some cells I have the format: $ 47,000+. Other cells have $47,000.

So I extract the 47,000 part using this formula:

=IF(ISBLANK(A1),"",IF(RIGHT(A1)="+",MID(A1,(FIND(" ",A1)+1),LEN(A1)-3),A1)).

When the source cell has $ 47,000+, I end up with 47,000 is the desination cell. But Excel does not recognize it as a number when I try to format it or use it in another formula.

Anyone got any ideas?

A:Excel 2002 doesn't seem to recognize a number

Read other 8 answers

This is an update of a closed thread... u can see the original here: http://forums.techguy.org/business-applications/856041-solved-word-2007-macro-convert.html

So I've got the macro and it works great -- for converting doc/docx to PDF or rtf. But there are 3 issues that still need to be addressed.

1. I can't get it to work to convert to txt properly -- it gives me an output txt file that includes a bunch of formatting instructions like font, color, spacing, etc.

2. It would be really helpful to get it to create PDF, rtf, and txt files all in the same folders. So for instance, I've got Folder1 and inside that is SubfolderA (which contains A.doc) and SubfolderB (which contains B.doc). I'd like the output to be Folder1\SubfolderA, and inside SubfolderA is A.pdf, A.txt, and A.rtf. SubfolderB would contain B.pdf, B.txt, and B.rtf.

3. So far, 3 other people on this committee have tried the macro on their computers, but it only works on mine (and all 3 of them have checked "Microsoft Scripting Runtime"). And I had to delete all the existing macros in Word to get mine to work -- it seems like I can only have 1 macro at a time. 1 of the computers doesn't do anything when we try to run the macro, and the other 2 give this error: Run-time error '76': Path not found" even though the path in the macro was edited to be correct for that machine. This section below was highlighted after clicking “Debug”...

FSO.CopyFolder Left(FolderNa... Read more

A:Word 2007 macro to convert file types?

1. I can't get it to work to convert to txt properly -- it gives me an output txt file that includes a bunch of formatting instructions like font, color, spacing, etc.Click to expand...

When you run the macro to save the files as text are you changing the actual output format type in the macro? My guess is that you are only changing the portion of the code that replaces the filename extension and not the actual file type. The portion of the code that I highlighted in red below should also be changed to FileFormat:=wdFormatText.

2. It would be really helpful to get it to create PDF, rtf, and txt files all in the same folders. Click to expand...

Are you saying that you want to run the macro one time and have it create all 3 files types at the same time without having to modify the code and change the file output manually?

3. So far, 3 other people on this committee have tried the macro on their computers, but it only works on mine (and all 3 of them have checked "Microsoft Scripting Runtime") Click to expand...

Are all 3 computers running the same version of Word?

Have you checked to make sure all upper and lower case letter match what is listed in the the folder path since it IS case sensitive. Did you also make sure there is a backslash at the end of the directory path? Call GetFiles("D:\maddenb\Desktop\test\", True, True)

Also, there is also no reason for you to have to delete other macros on your computer for this macro to run. Where... Read more

Read other 1 answers

This is an update of a closed thread, which itself was an update of another closed thread (I work for the government, so everything takes forever ). U can see pt2 here: http://forums.techguy.org/business-applications/876775-word-2007-macro-convert-file.html#post7030254

Anyway, issues 1 and 3 in that thread were resolved w/ the advice that Rollin_Again gave me. Only issue 2 remains:

2. It would be really helpful to get it to create PDF, rtf, and txt files all in the same folders.
Are you saying that you want to run the macro one time and have it create all 3 files types at the same time without having to modify the code and change the file output manually?Click to expand...

Yes... virtually every time we run this macro, we will need pdf, rtf, and txt versions of the original file in the same folder. So if the input file is in FOLDER1 and is named FILE1.docx, then the output folder should also be called FOLDER1 and it should contain FILE1.pdf, FILE1.rtf, and FILE1.txt.

I've pasted the macro below... it looks to me like some portion of the do-loop that creates the RTF file needs to be replicated twice more and each of those replications needs to be modified slightly to create PDF and TXT files.


Sub ConvertDocs()

Call GetFiles("D:\Desktop\test\", True, True)

En... Read more

A:Word 2007 macro to convert file types (pt3)

Read other 16 answers

Have some data files unzipped with .com on the end of the filenames.
I've been using these for years - you just rename the file with .txt and open it in Excel.

I used to just right-click and select 'open with'. Excel would come up in the list to choose from.

However, on Vista, I see I have the option (if I persist) of opening these text files in... wait for it, Paint or Media Player?!?!?!
But no Excel.

(Why has this been changed? Did someone think it was a good idea?)

When trying to choose another progam to open .txt files with you are just dumped into the 'programs' folder to find it for yourself.

I don't want to set Excel as the default .txt opener, I just need to use it sometimes... often.

Anyway, perhaps I can rename the files to .txt in WinZip before extracting, so that the file association will be set then?? Currently it thinks its a DOS prog and no amount of renaming will alter that.

Can I get Windows to show the .txt instead of hiding it so that I can rename the file association? I can't find the place where you might do that on Vista.

Great forum, btw, where would we be....?


A:Vista file types and opening txt files in Excel

What I did was to select open with, then select choose default program, then browse to Programs to find excel.exe. It will then show in the list. Make sure that you select Notepad as the default when you exit. The next time you select Open with, excel will be there as an option.
As far as displaying extentions, Go to Control Panel,Folder options,View and uncheck
"Hide extentions for known file types".

Read other 4 answers

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:


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:= _
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?

Read other 10 answers

I recently went through all my registered file types and changed the file extensions that are always hidden (even if you uncheck "Hide extensions for known file types"). This worked fine except that I had not anticipated that all my desktop icons would be followed by ".lnk". I tried to change it back, but when I looked in the list of registered file types in Explorer folder options, LNK was no longer listed. I figured that something that might work would be recreating it by clicking "New" and entering LNK, but I know that it won't work unless I enter the correct wording in "Associated File Type". The problem is that I can't remember that exact wording, and I can't pick it out of the list of 8 million file associations that I have to choose from. I also am not 100% sure that the above procedure will work, anyway. This is not a huge deal, but unresolved issues like this always bug me. Does anybody have any suggestions? Thanks in advance.

A:How to access file types?

Read other 11 answers

Have career (job search) and financial files from '99 that were moved via floppy disk, tape, CD, or e-mail from old NT 4.0 to newer NT 4.0 box and then to current W2K box. On latter two boxes these files produced 'access restricted' errors and were inaccessible. I've kept them in hopes of someday being able to reaccess the data. These file types include doc, txt, html, MS Money data, and possibly another one or two. In other words, file type is not the issue. I was on the old boxes and am on the W2K box THE administrator, and I have tried everything from renaming, taking ownership, changing permissions for folder and file, and still cannot access them. The current drive and previous drive were both NTFS, but I may have had a problem on a FAT drive also, although that is vague in my mind.

Any suggestions would be appreciated!

A:Solved: Access denied for range of file types

Read other 16 answers

Tried opening a video file that was changed from MSWMM in Movie Maker
to wmv. Previous files opened when I changed them to WMV. This is
what I get when I try to open file: "Unrecognized format for 'D:\Documents and Settings\(name of file).wmv'". Can anyone help?

A:XP doesn't recognize video file

Read other 6 answers

I built a new computer last night and now I have it running on Windows XP. My motherboard, video car, and sound card all came with CDs to install their drivers and I've installed all of them except for the sound card (I'll explain this later).

My problems are as follows:
- Whenever I attempt to install my sound card, I get flashed witha quick stop screen and then my computer crashes

- My computer doesn't recognize that there is an ethernet cable plugged in it

- My computer doesn't recognize that there are USB ports on it.

I read in one of the files on my motherboard's cd that the USB problem could be fixed with Windows service pack 1, but I don't think I can obtain that without the internet.

A:(XP) I can't access the internet and my computer doesn't recognize it's USB slots

Read other 12 answers

Hello all,

I have been presented with a project that involves Forms that I am not able
to resolve.

Basically I have been asked to create a document template where other team
members can fill out a form that asks a series of questions, then to have
only the completed form results export to a new file.

I am aware that Word can export the form results to a text file, but when I
do this all of the questions that were on the original form are exported to
the new file.

What we are looking to achieve in the end:
If the end user is faced with 20 questions, but only 12 of the questions
pertain to the end users project, only the 12 completed form fields will
export to a new file.

I know that this should be possible with using a macro button to export the data, but that is where I need the help.

I tried searching for this exact situation, but I did not find any matches, hence the new thread.

Thank you in advance,


A:Macro help needed to export Word form results to a new file... Word/Excel

Read other 11 answers

I have an Excel Workbook where I try to embed a Word and Excel file (icon). But, I cannot open the file afterwards. However, my colleagues can open it when I sent it to them by email. What could be the problem with my application.

I tried disabling my spyware software and reloading Microsoft Office XP but the problem is still there,

What could be the problem?
Thanks a lot

Read other answers

I am getting the errors Could Not Enable File History: The System Cannot Find the File Specified and File History Doesn't Recognize This Drive. I've tried a couple solutions I've seen posted. I tried deleting the File History folders on the external drive and in the AppData folder (although the File History folders never contain any files, they are always empty). I tried sharing the File History folder on the external drive with Everyone. Nothing has worked. I am out of ideas.

Edit: I've also tried to select another drive or reselect the external drive; I get the message "We found some files you previously copied using File History" and asks if I would like to move them. It won't let me choose No, i.e. choosing No has the same effect as choosing Cancel. If I choose yes, I get an error message saying it can't complete the migration. It seems like I need to reset File History somehow and maybe get rid of these leftover files (although I don't know where they would have come from, because I don't think I've ever turned on File History in the past, but I could be wrong there.) At any rate I don't know where these leftover files would be located because I've already deleted every File History folder I could find (in AppData and on external drive).

A:File History Doesn't Recognize This Drive

File History Doesn't Recognize This Drive.

Can you post a screenshot of the actual failure message and also a screenshot of Disk Management and tell us which drive is not working?

Read other 12 answers

I hope I can clearly explain this problem.

I've built a query that has one a criteria line that looks like this:


The query runs exactly as it should and filters the value in cbMyOtherComboBox parameter if the word "Regional" is in the noted in cbMyComboBox, or does not filter on anything if the word "Regional" does not appear in the cbMyComboBox.

I've built a report based on this query. In the report I've placed a chart, also based on the same query and created a master-child link on one of the fields so that the chart will loop through the data for each grouping within the field and chart the data.

This all worked great and smooth, until I added the filter to the query that callls the combobox value in the form. While, like I said, the query runs smooth, the report does not. Actually, the report runs fine in report view, but it breaks in print preview (or printing to PDF) and states the following error message:

The Microsoft Office Access database engine does not recognize [Forms]![frmMyForm]![cbMyOtherComboBox] as a valid field name or expression.

Any thoughts on why this won't work with print view (but it does with report view) and how I can fix this?

A:Access 2007 report doesn't recognize form text box

Read other 8 answers

I have 3 computers on a network over a linksys WRT54G router. A netbook running XP, an HP laptop running Vista Home Premium SP2, and a MAC running OS 10.5.8. All 3 show on all computer network locations and I can access files between each of them EXCEPT the HP Laptop under VISTA to the MAC. For that connection, VISTA wants a user name and password and I enter the same (and only user) name that I have on the MAC and I get the message that Windows cannot find that machine and asks me to check the user name/password. I use that same user/password combo when accessing the MAC from the XP Netbook, it works fine. What can I do in VISTA to get to the MAC. I know that the user name/password I am using is the only one that exists on the MAC. I also have 2 printers attached and they both work fine on all 3 computers.

A:Solved: Vista Laptop doesn't recognize password to access MAC on network

have a read here and see if this helps

Here’s how you can get your Windows 7 PC to share printers and files with XP and Vista PCs--and even a Mac

Read other 3 answers

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

Read other 9 answers

Hi Tech Guys,

I needed support for corrupted and excel files, do you know any best word and excel corrupted recovery software? i recovered a deleted word and excel file, but when i opened it some are okay and some are corrupted.

Please i really need help.. thanks in advance

Read other answers

I have rather a long problem at work. We keep a database with various information regarding contracts. For each contract we have to do a manual. ath the moment each manual is written out by hand with all the various information in, i.e. motor size, gearbox name etc. a guy has done a kind of hash job with mail merge which kind of automates the documents, but i want to do a litlle bit more.

all the information is inputted into access at the start of a job. because each job has a different type of machine we need about 10-15 different manuals. I want to be able to click on a contract, or input contract no., and it know what manual i need, and fill in the relevant details with regards to the contract.

for example:

contract 1 needs manual a
contract 2 needs manual f
contract 3 needs manual n........

so if i select contract 1, i want a manual with all the information for contract 1 to open up in a word manual with all the relevant information in.
any help will be appreciated.

A:word/access/excel help

Read other 12 answers

Hey all,

I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.

Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.

My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time

Your help is greatly appreciated.

A:Excel chart in Word 2010: extract chart values? Lost Excel data file!!!! Help.

Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?

One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?

Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.

Read other 1 answers

I had to do a sytems recovery for wind xp prof. but there is no icon for xcel or word. Did a search & they are there (C:\program files\microsoft office\office but when I try to open err comes back with "this application must be installed to run. please run setup from the location where you originally installed the application" any suggestions?

A:can't access programs (excel, word)

The best idea: "Run setup from the location where you originally installed the application".

Setup will give you options about what to install or repair. It looks like some registry entries may have been corrupted or removed by the restoration, especially if you restored to a point prior to when they were installed.

Read other 2 answers

Hi, I have a new client who has asked me for some advice in linking an Acess Database and an Excel spreadsheet that he is using for his rental equipment business. Currently, he is using the default "customer" template database that came with Office. And he is also using Excel to store records of clients transactions, such as purchases & payments and current balances.

He would like to be able to update the info in Excel and have this automatically update in the database and visaversa. He would also like to be able to have room to store notes about the customer - such as telephone conversations.

His problem is that a number of his clients have multiple contracts - these need to be easily accessible. Each time they make an agreement for a new rental item, it requires a new contract. I'm wondering if this is possible to link to a contract created in word as a hyperlink.

Personally, I think he would be better off investing in a client management system that will also do invoices and accounts and inventory control as he has other excel spreadsheets for this information. The whole set up sounds rather messy and complicated.

Is it possible to link the three office programs to do what he wants? I have an appointment with him on July 23rd to discuss options and solutions.

A:Linking Excel & Access & Word?

Read other 6 answers

All of a sudden when I try to access the internet from Word or Excel I get the following error message:

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

Since this is a single user machine I'm the system administrator. I vaguely recall there is a security setting somewhere that allows you to control this but I can't remember where it is. I am running Win XP SP 2 and Firefox.

Any ideas???



A:Can't access internet from Word/Excel

In IE, Tools-Internet Options, Security tab...

Read other 2 answers

Windows 8.1 with Excel 2007
On one PC is it ok? but not on another PC:
*a file with xls or xlsx suffix doesn't open as the exe-file of Excel is not found.
*Excel on it self is starting up and after openening the dedicated xls-suffix the file is visible
In configuration / programma's /file type linking with xls to the Excel program isn't seen

Ps: the doc-suffix is correctly linked to Word 2007

Who can help;


A:Excel file doesn't open

Right-click the xls file and choose "Open With". Then select "Choose default program".
Assign it to EXCEL.

Read other 4 answers

Hi guys,

I'm a teacher and i'm doing something for the school.

As a teacher we have to send a letter to all parents who's child is at risk of failing in subjects.

As we had to manually type the address and other details i did a mail merge from access table to a word document.

Also i have a excel which tells them what percentage they got after all those assessment work. i would like to add another column at the end of my excel a button. When i click this button i want the mail merged doc to open with the same name on my excel field.

In other words: when i click the button on excel, it should refer to student name and then the word doc should take the name field from excel and search in the mail merge and display that student name, address and other details.

Also i want the percentage to be displayed on the word

I've attached a sample of the work i did so far.

Thank you


Read other 16 answers

Well it seems like I encounter the strangest problems.
My environment is Windows 98SE
I've used WORD extensively and EXCEL occasionally.
Then today I could not open a document for either program, nor could I activate the programs. I received an Illegal Operation message, followed by a Restriction error message:
"This operation has been cancelled due to restrictions in effect on this computer." Surprise!
Everything else seems normal on the computer (Gateway SOLO 9300 laptop with big specs). No problems with internet access, nor running other large programs.
Has anyone out there encountered this error? How do I find out what these supposed "restrictions" are, and how to get rid of them.
Thanks for any suggestion. This is a great site.

A:Suddenly cannot access WORD or EXCEL docs

Read other 8 answers

I am still running Windows XP with Office 2007. Suddenly neither Excel or Word will automatically open existing files when I click on them from windows explorer. I can go to the Open option in the menu bar for Excel or Word, select the file to open and it will then open properly. Are there any option settings that allow for the files to open when click on them? I do not receive any error messages nor does the event viewer provide any error messages.

A:Excel / Word File Opening

does it give any error messages

in the file manager
do you have the word/excel icon next to the file ?

if you right click on the file - do you get an "open with" option

have a read here - see if the file is associated with the program

Read other 2 answers

I'm trying to insert from Word into Excel using Insert-Object-Create From File.

The tab I'm inserting it into is set up correctly (in this case Landscape Legal). But when I view, it only has the first page (of two) from the Word document. I've given it enough space page break wise.

Is there a better way to do this than my first idea (insert one document for the first page, and another for the second)?

Thanks in advance.

A:Insert File From Word into Excel

I know it seems it should work, but it doesn't. I'd just copy and paste special between Word and Excel. In Excel, use Edit | Paste Special | Text.

Select All in the Word doc. In Excel, widen column A, format to wrap text, and do the paste special | text.

Not as quick as Insert | Object, but it works.

Read other 2 answers

Excel cannot open the file " " because the  file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches.
Files got corrupted at time of virus removal. also have and use Carbonite backup if that helps.
Already tried:
Open MS Excel in your system.
Click on File tab > Open. Or press Ctrl+O.
Locate the corrupted XLSX file and select it.
Click on the arrow shown beside the Open button.
Click on Open and Repair in the list.
Still wont open files, any help would be appreciated 

A:Excel and MS Word "cannot open file"

Uninstall/reinstall MS Office...update for all SPs...update for all critical updates.
Then try.

Read other 11 answers

Whenever i click on a recent excel or word doc, the program opens and gives me a warning saying i already have a file of that name open, but i dont..... Im running windows XP.

A:file already open excel word

Read other 6 answers

Hi guys,

So here's what I'm trying to do. Basically I need to create a word document report from data in an access database. The access database basically contains risk items for different entities. So, the report will contain all the risk items for one specific entity and a summary.

What I want to be able to do is enter all this information into the database and then automatically generate the report. The database is basically setup, including the queries I need. I just don't know how get the information over to word in the way need.

The main problem is that I need a summary section that lists the number and types of risks found above, and then the details of each individual risk below. So a very simplified example:

Report for ENTITY 1.

1 High Risk
2 Medium Risks
6 Low Risks

Detailed Information
Risk 1: RISK 1's NAME
Severity: High
Infomation: This is the information about risk 1.

Risk 2: RISK 2's NAME
Severity: Medium
Information This is the information about risk 2.


I know that this is not a standard "mail merge", but I thought it might be possible using VBA. I have used a (very) little VBA, but I am willing to learn more. I just need a push in the right direction as to where I might get the information I need. Several other things I would like to be able to do (but could sacrifice if necessary) are pulling images stored as OLE objects in the access db into the report for each risk and being able to control the backg... Read more

A:Access/Excel merge to complex Word document

Read other 16 answers

Suddenly, several nights ago, I turned on my laptop at home and got errors that prevented me from opening any Word document, any Excel document and any pdf file. The Word error I get is "Word cannot open the document: user does not have access privileges...." Attempts at Excel and Adobe pdf file opening anywhere on the computer produced the same result. MS-Access, MS-Powerpoint and other file types can be opened as normal. Also, I have no problem opening any Word, Excel or pdf from an external source, like an e-mail attachment or a flash drive. In fact, I can replace the unopenable copy of a document with the same file from a flash drive and it becomes openable from the hard drive. (However, when I try to use Explorer to replace the unopenable copy on the hard drive with the backup from the flash drive, I am told that I do not have permission to do this, so I must first delete the hard drive file and then copy the flash drive copy into the folder where it resided.)

The files that were unopenable at home become openable when I am hooked up to the network at my school. So, the problem mysteriously vanishes.

This laptop is my only computer. Only I have ever used it, and I have gotten nothing of this kind before. However, I do hook it up to my university network when I am there. In such cases, I never get the error. I am on a Lenovo W520 laptop running Windows 7. One more issue that might be related is the annoying fingerprint recognition message that I always have ... Read more

A:access privileges error in Word, Excel, Adobe pdf

Hi loonguy and Welcome to TSG!

The files on the remote drive, were they created on the problem system under the same account? When you access your school account, is it on a separate Domain account for the university? On your home profile go to Program Files \ Microsoft Office and locate "EXCEL.EXE" Right click Properties \ Security \ Advanced \ Owner. Who is the current owner? If it isn't you, Are you in the list to Change Owner to? If not, add yourself. Click Other Users and Groups \ Advanced \ find Now and select your account. Under Owner click Edit, select your account, apply to take Ownership. The same will apply in word and the PDF app, probably Adobe. Please post your results.

Read other 2 answers

Its been about 9 years since I last worked with either access or excel and now im trying to fix a database that seems to have been corrupted.

I had to emergency save data from a dying access database into an excel spreadsheet.

I tried to rebuild the database and import the data from the spreadsheet but wherever there was a line break in an address field, it was replaced by a lovely square symbol. I discovered that in excel this is what happens to data that was word wrapped that is no longer word wrapped. It seems the option to word wrap isnt available when i try to reenter the data into the new access database.

There are 9000 entries so its not possible to go through each one individually to remove the squares...

SO im looking for an expert who can explain so an idiot will understand to help me out with some things.

1) how to remove these squares en-mass without damaging the data or changing its meaning

2) how to set it up so that the data with squares still make sense as an address incase of mail merge or how to resume the word wrap thing in access

3) how to import data into access without datafields being deleted when they dont meet the input rules (even tho theyre set up identically to the database the info came out of) or how to change input rules without losing data.

I'm sure there are loads more things but this is all i can think of for now.

Please help. Its been 9 years since i last had to do this kind of stuff and I cant remember a thing.

A:Word wrap issues importing from excel to access

Welcome to the forum.

1) Copy the little square then hit "CTRL"+"H" on the keyboard to bring you into Find/Replace. In the Find What: section paste the square ("CTRL"+"V"). In the replace section type in a space. Then click on the "Replace All" button.
2) If those fields have multiple line addresses they should be migrated into separate fields.
3)If you import into a new table it should allow you to import all the fields. The only problem you might have is the field names which Access gets particular about.

Can you post a sample of the data with mock or fake values?

Read other 3 answers


I am looking for a reliabe file (mostly Excel and word files) vault for Windows 7. I have not found anything at the moment.

Would you please advise some solutions?

Thanks a lot,

A:File (excel and word) vault for windows

Need some help here "reliabe file ... vault" - - what do you mean - - what does a vault provide for you?

Read other 3 answers

I lost a few hours of work due to:
Suddenly unable to save a file in Excel. No warnings etc. Blissfully working (and saving) along but when I boot up again later I found the file 'not saved' but a random number file eg; BDF45000 in directory. Opens up in Excel but with only some data.

I did:
Run repair, Office 2003 Proff. (No change)
Check for 'read only' (Not the problem)
Use Reg Mechanic, cleaned up and defragged... (No change)
Save under different name. (No change)

I use AVG... could it be that a third party app interferes with a 'proper save'?.. or AVG interference whilst excel tries to save? I am a bit paranoid at this stage... not trusting the pc. Ideas?

A:Unable to save file in Excel /Word

Read other 6 answers

Recently, when I open either my MS Word or Excel programs, and click on the yellow "Open" folder, whereas previously a list of my saved documents came up, now sometimes the page is blank! If I leave it for, say, ten minutes, they appear and I can open and work on them, but I wondered whether anyone had an idea as to why this is happening? I am running Windows 7 (64 bit). Many thanks.

A:Word and Excel File lists not appearing

Read other 14 answers

not sure why this happened, but I cannot open these programs,
I tried all the discs I have for my laptop, with no luck?

how do I get them working and why did it happen?

Read other answers


Can anyone help me to automatically take data of 20 students from excel file and fill the template which is in my word file and print it.

Here is the sample data and sample template
Please help me to do this..........


Read other answers

I have tried an easier way to copy contents of an excel spreasheet into Word .doc.

Using this site I have found that in Excel copy one large range and Edit-> Paste Special ->
Microsoft Excel Worksheet Object, and this will copy text and tables to Word.

One problem is that the backgound cell lines in Excel also get copied. How can you remove those, in Excel I presume before the copy.

Here is an example.

A:Copy Excel file info into Word

See Tools > Options > View > Window Options.

Read other 1 answers

My Word 2000 help file is not loading at all, whereas in the past it was available (loaded slowly, with index window showing) . I just tried to pull up the help files for Excel and Access, and neither loaded. I have Office 2000, don't remember how I installed it. I think Access and Excel are under an Office directory, whereas Winword is on it's own. Can't figure out what happened. I don't mess with software once it's been installed.

Read other answers

I have Office 2003 with a Vista operating system. Everytime I try to do a mail merge to create label with a Excel csv file it forces me to close the application.

I can complete the mail merge using the same file on any other computer. The only why I can get the mail merge to work is to save a csv file as a regular excel file. It doesn't matter what csv file I try on, it just crashes word.

Tried unistall and re-install of Office and the problem is still occuring.

I don't know why word won't allow me to use th csv file type.

Please hlep

Read other answers

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.

Read other 3 answers

clicking on "file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141" in excel redirect to browser but omits "file:///" &"?3/4/3141" portion from the hyperlink thus doesn't open in the browser. how can I let excel redirect file:// protocol without modifying the link
I am cross posting due to time constrains and due to that no one is responding and due to the fact it is a difficult issue to resolve. and I promise when I get it solved I will notify you promptly.

Read other answers

First time poster here! I am helping a user of ours in Atlanta who is having odd behavior with MS Word 2003 and Excel. Detect&Repair also causes application crash. Anything stand out in this log?Logfile of Trend Micro HijackThis v2.0.2Scan saved at 2:18:29 PM, on 9/13/2007Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)Boot mode: NormalRunning processes:C:\WINDOWS\System32\smss.exeC:\WINDOWS\system32\winlogon.exeC:\WINDOWS\system32\services.exeC:\WINDOWS\system32\lsass.exeC:\WINDOWS\system32\svchost.exeC:\WINDOWS\System32\svchost.exeC:\WINDOWS\System32\WLTRYSVC.EXEC:\WINDOWS\System32\bcmwltry.exeC:\Program Files\Common Files\Symantec Shared\ccSetMgr.exeC:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exeC:\Program Files\Common Files\Symantec Shared\SPBBC\SPBBCSvc.exeC:\WINDOWS\system32\spoolsv.exeC:\Program Files\Cisco\CSAgent\bin\CSAControl.exeC:\Program Files\Cisco\CSAgent\bin\leventmgr.exeC:\Program Files\LANDesk\Shared Files\residentagent.exeC:\Program Files\Symantec AntiVirus\DefWatch.exeC:\WINDOWS\system32\inetsrv\inetinfo.exeC:\Program Files\LANDesk\LDClient\LocalSch.EXEC:\WINDOWS\... Read more

A:Word / Excel Crashing When Clicking File->open

Hello and welcome to BC.Sorry for the delayed reply. Nothing suspicious in the log.

Read other 2 answers