Over 1 million tech questions and answers.

Populate and Save several word files from excel

Q: Populate and Save several word files from excel

I have an Excel sheet that contains text/data per row. This excel sheet may have as many as 300 rows of data. I would like to export the data in the excel file row to a word template, and save that to a specific file name which corresponds to column 2. I would like to be able to 'click' a button and have all 50 rows export their information using the word template and have these files saved under specific filenames in the line item data (ex: column 2). Do you have any suggestions on how I can do this?

Read other answers
Preferred Solution: Populate and Save several word files from excel

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.)


Hi guys,

I have a question that has stumped me so far. Here is the scenario: I am dealing with a spreadsheet that has several tabs on it. In each tab, there are several word, powerpoint, and pdf documents that are embedded as objects. My task is to write a macro, that will for each document (keep in mind its an embedded object that needs to be opened), open it with the appropriate program, and save it using a pre-assigned name (the name of the column heading and the row it is in) to a predetermined folder path. This process needs to be duplicated about 200 times. I'm not sure if this is even possible, but I know enough about vba to believe that it is. I've been working on it since yesterday, and I can't seem to tie the pieces together. Can anyone help on this?


Read other answers

At work we deal with a lot of repeated data in a very fast paced setting.

I want to be able to enter the data into an excel sheet and then press a button to populate a word document with a pre-existing template or press another button and put all the data into a premade word form so that I don't have to keep copy/pasting over and over.

This is sensitive data, so it cannot be transmitted or leave my workstation to make the transition.

I would like to be able to do it all native, because I cannot use non approved third parties.

I am pretty sure this can be accomplished with VBA, but the coding is over my head.

Thank you in advance.

A:take notes in excel, populate two different word docs

Can you upload a blank template of your word document and also your excel this way we can see how to map the content from one to the other

Read other 1 answers


I have an Excel sheet that contains data per row. At the end of each row, I want to put a button (or a hyperlink to a file) that will put the data from that row into a new Word document, something like a printer-friendly document.

Please find enclosed the Excel file and the DOC format that I need.

A:Solved: Populate Word Document from Excel

Read other 16 answers

So I've tried to teach myself VBA to record macros that will take information from an excel spreadsheet and populate it in a corresponding bookmark in MS Word but no luck.

Basically I want a button in my excel spreadsheet that I can assign a macro to that will open up a word document for each student and populate a MS Word template with data from the excel file in the correct bookmark location.

In other words, I click the button in Excel, a file in MS Word is opened up for each student that is filled out using the corresponding data from Excel.

If anyone knows the code for all this it would be real helpful.

A:Populate a form letter in Word Using Excel

Read other 7 answers

I have an excel spreadsheet I have to work with a lot. I also have to turn around and type it all in again on a word document. I just need to make sure I get two different papers complete. Anyway, how do I automatically populate in word when I put the info on my excel sheet. If anyone could help me with this you would save me tons of work. I would really appreciate it. Thanks

A:How do I atutomatically populate a word document from an excel spreadsheet?

Read other 6 answers

Well..glad I found this forum. I would like to be able to populate a word document from an excel worksheet, with the ability to select (highlight) multiple rows in excel and have those rows transferred to word, but only certain columns

I found almost the right macro here:

Except you can only select (1) row.

Any coding solutions on how to copy a range of rows? This will also require the .Text in the word paste to change....
I see some hope with this code as well, but figuring it out may take me longer than someone that does this everyday.
Thank you.

A:Populate Word Doc from Excel (Multiple Rows, Select Columns)

Read other 12 answers

Good evening,

was trying to find a piece of VBA code online for the following problem, found pieces for some single aspects, but cannot make it work. Have excel and word 2013.

I have a excel spreadsheets which is my master database. Every row (90 in total) lists one data set with up to 40 columns, but I will not need all informations. The first colum has a checkbox which I would like to use to chose which data set to work on to populate the word doc (working with multiple ticked would be great as well).

In addition I have multiple word documents, where I added text form fields which should then be filled with the informations from the excel sheet (I will not need all 40 columns for every word doc).

The code needs:

(1) To open the correct word document

(2) Fill in automatically the present date at a defined location in the word doc styled Jan 31st, 2018 with the correct st, nd or th.

(3) Fill in the specified data in the text form fields

(4) One column in my spreadsheet is a drop down menu, is there a difference if this content is transfered to the text form field?

(5) Some of the cells in the excel may be empty, how to make sure the transfer is not hicking-up?

(6) Save for every data set ticked a document (word and pdf) in a distinct location with some information from the data set contained in the name of the file.

I would be so greatful, If one of you can help here, guess for you this is done in a split of a minute...


Read other answers

I am un able to get an existing word file to open. I can get the following to open a new word file. I need this to opoen an existing file.

Sub export2Word(row)
Dim oWD As Object
Dim wdDoc As Object
Dim TWB As Workbook, wsh, wsh1 As Worksheet
Set TWB = ThisWorkbook
On Error Resume Next
Set oWD = GetObject(, "Word.Application")
If Err.Number <> 0 Then Set oWD = CreateObject("Word.Application")
Set wdDoc = oWD.documents.Add
With wdDoc
With .Range.paragraphs(1).Range
.Text = "PICK UP & DELIVERY" & Chr(10)
.Font.Size = 15
.Font.Name = "Times New Roman"
.Font.Bold = True
.Font.Underline = True
.ParagraphFormat.Alignment = 1
End With
With .Range.paragraphs(2).Range
.Text = "PICK UP" & vbTab & Cells(row, "K").Value & vbTab & Chr(10)
.Font.Size = 10
.Font.Name = "Times New Roman"
.Font.Bold = True
.Font.Underline = True
.ParagraphFormat.Alignment = 0
End With
With .Range.paragraphs(3).Range
.Text = Chr(10) & Chr(10) & Chr(10) & Chr(10)
.Font.Size = 13
.Font.Underline = False
.DefaultTabStop = Application.CentimetersToPoints(1)
.ParagraphFormat.TabStops.Add Position:=Application.CentimetersToPoints(5), _
Alignment:=0, Leader:=0
End With
With .Range.paragraphs(5).Range
.Text = "NAME" & vbTab & Cells(row, "B").Value & vbTab & _
Cells(row, "C").Value & Chr(10) & _
"ADDRESS&qu... Read more

A:Populate Word Doc from Excel (Multiple Rows, Select Columns)

Welcome to the forum
You should paste your code in a code clock

[ code ]

no spaces in between the []

[ / code ]

Set wdDoc = oWD.documents.Add

To open a word doc

Set wdDoc = oWD.documents.Open(fullpath and name of the file)

This should do the trick

Read other 1 answers

Okay, this maybe a tough one...

I have a list of registered attendees for a training session. I would like a button for each registrant that auto populates an Word invoice template and confirmation letter template - Conf. letter fields: first name, last name, company, address 1, address 2, city state/prov. and country. Invoice fields: first name, last name, company, address 1, address 2, city state/prov. and country. Session name, date range, cost...

I would also like to use the same list to populate a registrant booklet that is also an existing template in Word - first name, last name, company, email address and phone number. I read on another post that we could possibly do an auto save to a specified location when it populates the template as well. Then we have name tags, book labels and certificates that also need to be populated from the same list...

Anything to save some time and reduce errors resulting from human interference.


A:Excel macro to populate existing word documents and booklets

Why do you need a macro to do this? Have you looked into a "Mail Merge" ??


Read other 1 answers

I had an idea... in my company there are several stand-alone contact lists each one managed with a separated Excel file. These directory of contacts are in several cities for that I had that idea:
create a master directory excel sheet managed by the HQ and populate it with all the other "branch" files uploaded on Google Drive or any other Web space by the users.
What the VBS or macro should do is anytimes I open the master document, it must look inside the path where the files have been uploaded then one by one import in into the master doc by creating the sheets inside each one.
Which one is the way to do that?

A:How to populate an Excel doc with external Excel files.

In the branch worksheet, select the cell you want to link to and click Copy. Switch to the master spreadsheet and click the cell where you want the link. Then, right-click and select the Paste Link from the Paste menu.

Read other 6 answers

Hello I found an answer to this question but it was specific to his form. I have several Excel Logs (Tables) that contain information that is also entered into a separate form. Some forms are in excel and some are in word. I would like to hit a button that transfers a row of data to the form so i only have t enter data once. The forms will have additional information that will be entered. The forms are saved as a specific file type and are also printed so the answer that i found on this site may work but it puts the data into a different spread sheet in the same workbook and i need to send the data to a new workbook and in one case to a word doc. Can someone help me out. I have attached a couple examples of what i currently do.

Thanks for the help

A:Solved: Populate Excel Form and Word Form from Excel Table

Read other 16 answers

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")

'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")
i = i + 1

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.


Read other 2 answers

The computer involved is using Windows 7 Pro 64bit and Office Professional Plus 2010.

I am having a problem I cannot find a solution to. I have one user at a clients location that has recently stopped being able to save excel files in their my documents. The my docs is being redirected to a server. The files open correctly and can be edited, but when save is clicked an error box says the document not saved. Using cntrl-shift-i I found the error code to be 100490. I can open any other file and save them just fine. And any new excel documents can be opened and saved correctly. The file can be saved into the same folder using save as is and the document is renamed. However, the user cannot erase the old file.

Doing some digging I made sure the trust zone was enable for the network path and trusted locations on a network were allowed. They had already been configured.

I checked for the windows update that microsoft reported could fix this problem and it was not installed. I went ahead and tried the hotfix, but it would not run because of the missing update.

I tried changing permissions and ownership. This where it gets strange the user has full control enabled on the folder. On any other folder or file I can right click and view the security tab. However, on the excel files when I click the security tab a red line is displayed that says "This file is currently not available for use on this computer." If I try to make a security change on a whole folder any excel fil... Read more

A:Cannot save excel files in a redirected folder unles I use save as

To resolve this problem, reinitialize the cache of offline files. To do this, follow these steps:Click Start, type regedit in the Start Search box, and then press ENTER.
If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.
Locate the following registry subkey, and then right-click it: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\CSC
Point to New, and then click Key.
Type Parameters in the box.
Right-click Parameters, point to New, and then click DWORD (32-bit)Value.
Type FormatDatabase, and then press ENTER.
Right-click FormatDatabase, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor, and then restart the computer.

Taken from Gray "X" on network share folder icon

Read other 3 answers


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?

Read other 6 answers

Received a few MS Excel files from an outside vendor as e-mail attachment. I am able to save the attachement to My Doc or desktop and then open or open them directly from Outlook 2003 or 2007.

But when I tried to save the doc with or without making changes, the spreadsheet just sits there and saying Saving at the bottom. I waited several miniutes to be saved, but it just sits there. It does not taking any extra resources. On Application event viewer, it just displayes application hang error.

A:Unable to save or save an Excel files

Read other 16 answers

Hi! i need you help!.. I am unable to open or save files in the shared drive using Excel 2007 but i can open/save excel 2007 files saved in my local drive

The error message I get when i try to open is "Could not open...." followed by the path and excel name.

This is the error message i get when i try to save in the shared drive:

Microsoft office excel cannot acces the file". There are several possible reasons:

the file name or path does not exist
the file is being used by another program
the workbook you are trying to save has the same name as a currently open workbook

Please help

A:Unable to Open and Save Excel files in the shared drive using Excel 2007

Read other 15 answers

My WindowsXP system has suddenly and for no apparent reason developed a problem where both Word and Excel give the hourglass of doom and crash, when you try to 'save as' your work. Otherwise the machine works as normal on all other programs I have tried using. I have seen one other post for this problem on one other forum - but no suggestions how to remedy it. Can anybody help please?

A:'Save As' problem with Excel and Word

See the sticky at top of forum. Microsoft security update MS06-015 (908531)
KB 918165

Read other 3 answers

I am using Win 8 and I can't remember now if this has started since going to Win 8 or if it worked OK for a while and is glitching now. (I am using 2010 and Outlook on Win 8)
If I prepare a Word or Excel document and want to send it on to someone I can no longer go to the File/Save and Send/Send as Attachment feature because if I do that then my machine says cannot send this message.
I then delete the attachment, click on Attach file, find the file, attach it in this way and boom...of it flies - kind of irritating.
Rather strange - anyone care to comment?
And I would really love it if, when this feature does work, such as when you send a picture straight out of My Pictures, it freezes you on that email so if you suddenly remember another file you want to add, or you decide you need to check something somewhere else before you hit go, the screen flashes at you (gives you the finger). So now you have to close/delete that message and start again (fortunately if you have added text you can highlight it before deleting, copy it and then, after closing the message you can paste the copy into word temporarily until you get a new message ready then copy/paste it back into your email.
I have not tried to send straight out of my pictures for a while - must check if that still works....it does!

A:Save and send Word & Excel

I have Office 2010 and Windows 8, I get the same error. I tried 6 Different repair options and so far none have worked.

Read other 1 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

I have store word/excel to server. I experience when I open it from server and edit, when save it to the same location, it got and error and cannot be save. I have to save as my local pc and do copy/paste to the server.

How can I solve this problem?

Thank you.

A:Word/Excel document cannot save to server

It sounds like a permissions problem as though you have access to open the file, but not modify or save it.

Is this on your work network or a home network?

Do you know how to use permissions and folder/file security?

Read other 3 answers

I recently changed computers. I saved all of MY Documents And loaded tham into the new computer, along woth my Office 2000 software. My OS is now Windows XP.
When trying to save a new document I get the following message:
"Folder C:\Documents & Settings\(my name)\My Documents\(title)\ isn't accessible. The folder may be located in another volume or protected with password" I can access all of my previous documents. Just cannot add to them.

I do not have password protection. Does anyone have a clue? is Office 2000 not compatable with XP? This XP is getting to be a pain in the butt!

A:Unable to save new Word or Excel document

Are the files set to Read Only?

Read other 3 answers

Just recently (last 2 months), I have not been able to save any email word or excel attachments. I can open the document. I can even edit it. But if I try to "save as", the info page shows it trying to be saved in a temporary file on my C drive. It doesn't matter what I do: let the icon spin, try to load, try to save, try a different path. Word (or excel) simply stops responding, then the error message pops up and I have to close the program.

If I open the file again, the prompt to save the file appears, but the same process occurs. I was fortunate (and have no idea how it happened, think I just "saved" it) that a 75 page document that I needed to edit somehow got "autosaved" in my document library, and so I am able to work on that one. The original is still sitting in my email in box because I can't save it :-(

This follows a change to the look/layout of my "info" page that happened roughly the same time. It used to be that I could simply save any document by going to "file", "save as" and it would take me to my library files. Now I have a two boxes at the top with a tile list of my document file folders. I have to either browse my C drive for the file, or click on the appropriate file folder.

What change has happened that my word program no longer saves as I always have?

A:Can't save word or excel attachments from emails.

Hi & welcome to the Forum.

You have not mentioned what version of Office you are using, but you could try repairing Office as a start. To do that:

Open Control panel,
select Programs & Features,
scroll down to Microsoft Office,
Right Click on it & select Change,
This should open a couple of Repair options to try.

Also make sure office is up to date.

Read other 1 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

The only way I can get any MS office programs to open is to right click and choose the "open with" option. I check the box to Use as default, but they still won't open the next time.
I tried run > winword /r to reset word, but that didn't help either.
All the icons are the same, a little blue chemistry beaker.
In properties, the type of files say they are, "FFV files (docx), FFV files (xlsx), etc".
How do I get these files to open the normal double click way?

A:Excel and Word files will not open in Excel and Word

Have you tried repairing the Office installation (via Start > Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair)?

Aside from that if the file types are "FFV files (docx), FFV files (xlsx), etc", that suggests you've installed some other software that has taken over the file associations. In that case, you might consider uninstalling that software; otherwise you'll need to reset the file associations, by right-clicking each Office file-type (docx, xlsx, etc.) and using Open With>Choose default program to re-associate them with the correct Office application.

Read other 1 answers

I'm trying to figure out how to make it so that a very long checklist, which includes checkboxes and text boxes, can be transferred to excel. (I'm working with the Microsoft Office 2007 suite.) I've been reading about how you're supposed to enable the "Save Data as Delimited Text File" in the advanced part section of the 'Tools' Options tab, and then save it as a text file to import into excel, but when I do that it doesn't save any information, just two zeros. I've been looking at other forum questions and messing around with how the forms are protected or not, but I can't get it to actually save any of what's entered in to the forms when I save it as a text file. Any help on this would be very much appreciated.
I've attached a zip folder (I hope) with a section of the checklist in case that might help. Thanks so much!

Read other answers

I have 2 comps that have this prob, both running xp sp2, I can open files (word and excel 2000 and microsoft works 4.5) from the network no prob. I can also save the files to the network drive.
The prob happens when i try to save as to the network drive, I recive the error

I can save the file to my hard drive.
I have no password on the file and the network drive is accesable.

I have unistalled and reinstalled the office (did not help).

All other programs have no problems with save as on the network.

A:unable to save as to network drive with word/excel 2000

Read other 14 answers

All of these programmes run fine, but as soon as I try to use them to save my work or open an existing file, they stop responding! I'm using the 2007 version and Windows Vista.

Thanks for your help in advance!

A:Word/Power Point/Excel 2007 Programme hangs when I try to save or open!

You could try opening up word, select help and look for a detect and repair option. Give that a try and see if it solves your problem.

Read other 2 answers

I am new to this forum, but recent difficulties have driven me here.
For some reason, whenever I go to save a document in Microsoft word, the "save as" box will pop up as usual, but where it would normally show my the contents of my documents folder there is absolutely nothing! Just blank space! And it will give me the "busy" cursor like its trying to load, but it never will and if I click anything it just goes to "not Responding" and I have to close it! This also happens if I try to open a file. Not just with word either, its all of my programs.

So basically, it is crashing whenever a program tries to access "my documents," which is usually the standard folder that opens whenever you go to "save as" etc.

This used to happen online too, but now that works for some reason but it still doesnt work offline. I thought installing "vista service pack" would help so I did that this morning but its still crashing.

If anyone knows any way I can fix this it would be much appreciated.


Read other answers

Ms Word will not save an edited nor new file. There is no error msg. I am using Windows 7, cannot find normal.dot nor any other normal, I have ran diagnostic, uninstalled and reinstalled MS Office, it still will not "save" nor "save as" it just sits there. When I try to save an edited file and check "yes" it just sits there unless I check "no" and it removes the file but will not save it.
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 32 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz, x64 Family 6 Model 15 Stepping 11
Processor Count: 4
RAM: 3326 Mb
Graphics Card: ATI Radeon HD 2600 XT, 256 Mb
Hard Drives: C: Total - 336778 MB, Free - 214233 MB; D: Total - 10239 MB, Free - 5739 MB; G: Total - 953867 MB, Free - 485413 MB;
Motherboard: Dell Inc., 0FM586
Antivirus: ZoneAlarm Antivirus, Updated and Enabled

A:ms word will not save files

Read other 6 answers

I read this thread. Is this problem resolved today? I installed Office 2013 and have the same problem: not able to save Word-files in folders, can save them on the desktop and - so far... - on external drives.

A:Cannot Save Word Files To Folders

If you select the Computer option when saving, it should present you with access to the C: drive and all files and folders there. Is this option not available?

Read other 1 answers

Says I can't open document because 'word has insufficient memory' -- I'm assuming this is related to the 62% resources free on bootup...should be 80 if i remember (this is win98) -- any ideas other than that as to why it won't save/open?

and if you agree its the resources problem - how to fix? This is my cousin's old machine...IBM Aptiva...i think it's a duron, only 64mb dedicated system memory...88 included onboard vram.

A:Word won't save or open files

I got system resources free up to 88% but it still won't open documents. If I open a document straight from my documents, it will open. But the 'open' command won't work in Word. I can't use the 'save' or 'save as' command.

I can open recent files though in the 'file' menu. Any ideas? Seems really weird.

Also, appears to be true in all Microsoft applications, not just Word.

Read other 3 answers

When I try to save some excel files in some particularfolders, I cannot save them properly and the following message shows up;

“The file could not be accessed. Try one of the following;

- Make sure the specified folder exists

- Make sure the folder that contains the file isnot read-only

- Make sure the file name does not contain any ofthe following characters: < > ? [ ] : | or *

- Make sure the file/path name does not containmore than 218 characters.

I save them on desktop and copied and pasted them fromDesktop, however I cannot open them from the folders in question.

The same files could be saved and opened from other folders.Some other file with shorter file name can be also saved and properly openedfrom the folders in question.

However, I need a longer file name in these folders inquestion, so I would like to hear from you any helpful advices

A:I can't save excel files in particular folders

Hi there, welcome to the board!

First and foremost you need to ensure you have full permissions for that folder, at least both read and write, but full permission is always best. I'm also assuming you've ensured the reasons listed have been mitigated, and you're not using illegal characters or file names that are too long. I'm also assuming this is on a Windows (XP or later) machine and the file system format is NTFS, as there are restrictions on file systems like FAT32 in regards to file name length. This actually doesn't sound like an Excel issue, but more of an administrator issue with your OS.

Read other 2 answers

Hey Guys, Issue wherein the customer could not save files in Corel Word Perfect X3. The Operating System the customer was using was Windows Vista Solution: Dand install Service Pack 2 http://www.corel.com/servlet/Satellite/us/...d=1166554021807 Issue Resolved!! Renji George(Moderator edit: moved post to more appropriate forum, jgweed)

Read other answers

I have MS Office Home & Student 2007 loaded on my stand alone XP operating system.

Just recently, I have not been able to save a document that I have opened and edited in word as a 1. Word Document, 2. Word Template, 3. Word 97-2003 Document, 4. Other Formats.

When I click on any of these four options nothing happens.

However the only other option in the list: PDF or XPS does work. I am able to save the document as a pdf file.

I have tried repairing, uninstalling and then reloading the office suite. I have also done a system restore to a time that it worked correctly. All these methods have not fixed the problem.

I have not installed any new programs recently. The only thing I have done is deleted everything in my Temp folder. (could this be the cause of my problem?)

Any ideas to resolve my issue would be very much appreciated.

A:Solved: MS Word will not save files anymore

Read other 13 answers


I am a teacher and would like to save my lesson plans in order so I can reference them easily. I have tried numerous naming conventions but haven't been able to achieve exactly what I want. It may not even be possible. Specifically, I create weekly lesson plans and want to save them in order by week,month, year. This would make it much easier to search for a specific lesson plan. The way it is, windows saves everything in alphabetical order so files are not sequential.

I am running Word 2003 on Windows XP. If anyone can help, I would appreciate it so much.


A:Save Word files in order by month

The file naming is going to have to start with data that you want first, i.e., week-month-year-SubjectMatter.

The week and month are going to have to be NUMBERS.

Read other 2 answers

We upgraded from Windows XP to a new HP Pavilion PC running Vista Home Premium. Installed Word perfect 10 with all the service packs/hotfixes I could find and copied the documents over. I can see and open the files but can not save or save as. The Save dialog box comes up but it is not pointing to the default file location I set up in WP. The file name always comes up *.* - which I can change but it will not let me set a file type (the line is blank and I can not type in it) and clicking the save button does nothing.

A:Solved: Can not save files in Word Perfect 10

Read other 7 answers

Friend is having 2 relatively minor problems with his 64 bit Windows 7 Home Premium laptop.

The second:
He uses a flash drive to copy Word files from a Windows XP PC to his Windows 7 laptop. I created a one line bat file for him to copy all the .doc files from his document folder to a thumb drive.

We noticed that not all the document files were being copied. Of about 40 new files, only about 32 made it to the flash drive. When I tried to individually copy/paste files I get a msg (on the 'paste' end of it) that I
Cannot copy (whatever).doc. The directory or the file cannot be created.

So I brought up the original document, and did a Save As to the thumb drive. There I got the msg
Word cannot save or create this file. Make sure that the disk you want to save the file on is not full, write protected, or damaged.

The flash drive is about 1% full, does not seem to be damaged, and allowed me to copy 30-some of the Word files that have been created since 01//06/12, just not all of them.

Any of the documents already on the flash drive can easily be re-copied from the documents folder on the C: drive. It asks if I want to replace the file, I say yes and I get no error.

Any ideas? The Windows XP PC is runing Word 2003, while the Win 7 laptop is running Word 2007 if that makes any difference (I don't know why it should).

First problem in another thread.

A:Problem 2 - Word cannot Save or Create (some) Files

Run chkdsk on the flash drive?

Read other 8 answers

Just started having trouble opening and saving word files on Mac

Read other answers

When trying to save newly created Excel Files (I still use the 2003 Excel), my computer shows the blue screen with the message PAGE_FAULT_IN_NONPAGED_AREA. The error does not occur when modifying and saving existing Excel files and it does not occur with Word files. The error started recently - I have not made any conscious changes to my old machine.

Any help would be appreciated

Read other answers

A woman that I work with has an Excel spreadsheet that she updates often throughout the day. Everytime she saves another TMP file appears in that folder. After closing the folder and opening it, the TMP file is still there. At one point she had over 400 of these temporary files. The beginning of the file name of this TMP file is the same as the file that she used but after that it has a ~ then letters and numbers. An example would be: Aftercare.xls~RF4bdb5c8.TMP Also the icon is not an Excel icon. These files do not show up in the temporary folder either, they are right in the folder where the spreadsheet is saved.
Obviously they can be deleted, but why is this happening and is there a way to stop it? I have uninstalled and reinstalled Office, but the problem still continues.
I appreciate any help anyone can give me on this one because I am stumped


A:Excel 2002 creating TMP files w/every save :eek:

Read other 15 answers

Its been a week now since i have this problem that im unable to save MSoffice files on my laptop's C drive. I keep on getting the message "Your changes cannot be saved to "fxx.xxx" because of sharing violation."
This started when i removed my membership from administrators group to power user and change the owner from me to administrators group, i did if for standard security setup in our office for all computers (im part of administrator team, so i know the admin password anyway). Since then im not able to save any MSoffice file on c.
So far this is the only program that i know of that wont allow me to save files on c although i tried running a standalone program from D (no installtion required) and create a profile/or user for that parcticular program, then close the program and open it again but the profile is not being created. I tried doing it using admin login and it is able to create i can also save MSoffice file on c. Funny thing is, on the other machine the same standard security set up is working for a power user. i tried reinstalling the msoffice XP program but to no avail. I tried adding my name again on the administrators group stil not able to save.

A:Unable to save MSoffice files (excell, word, etc) on C

Quote: Originally Posted by 2010incubus

Its been a week now since i have this problem that im unable to save MSoffice files on my laptop's C drive. I keep on getting the message "Your changes cannot be saved to "fxx.xxx" because of sharing violation."
This started when i removed my membership from administrators group to power user and change the owner from me to administrators group, i did if for standard security setup in our office for all computers (im part of administrator team, so i know the admin password anyway). Since then im not able to save any MSoffice file on c.
So far this is the only program that i know of that wont allow me to save files on c although i tried running a standalone program from D (no installtion required) and create a profile/or user for that parcticular program, then close the program and open it again but the profile is not being created. I tried doing it using admin login and it is able to create i can also save MSoffice file on c. Funny thing is, on the other machine the same standard security set up is working for a power user. i tried reinstalling the msoffice XP program but to no avail. I tried adding my name again on the administrators group stil not able to save.

would setting yourself up with a new account plus admin privileges work..?

Read other 7 answers

My xls/xla files on an 8 year old PC (PC1) are saved in a flash. Wether via VBA or the interface Ctrl+S.
- Office XP Pro, SP1 -- Office/Excel 2003
- never a glich in 8 years
- I have copied both xls and xla files over to a new PC3

My new PC (PC3) takes about 8 times longer to save those copied files
- Office XP Home SP2 -- Office/Excel 2003
- the only changes are in cell values
- file sizes 300kb to 500kb
- writing new VBA files is painful -- I go for a walk while the files are saved

I have written an xla tool (that works just as well in xls) to rebuild "RSQ" devt files as they bloat.
My RSQ tool rewites everything on sheets and userforms and VBA code (it copies nothing)
(eg, file sizes of 1200kb down to 450kb)
The tool has an option to strip out all module Rems.

These pristene files in PC3 are taking a frustrating long time to save.
One file on PC1 saves in less than 1 second, -- copied to PC3 it takes 12 seconds to save.
I have spent 2 days googling and all solutions are for network PCs
NONE of my PCs is connected to the internet.
We have a standalone PC (no applications) purely for "surfing/research".
- all downloads are checked for viruses before the download files are copied onto PC3.
The "save" problem only applies to Excel. MS-Word and Windows programs are not a problem.

TESTED an xls file with ...
1. Just worksheet data (12 sheets) and formatting RSQd --
full of cell "Comments" and some cell colouring , no cell formulas, use... Read more

A:Solved: Excel 2003 files very slow to save

I have tried ...
chkdsk, defrag (MS-Defrag + MyDefrag v4.2.9), temp files deleted, Virus scans (Malwarebytes + Trend), Indexing Service (disabled + enabled),
TweaksUi (disabled drives A,B, I toZ), Excel options ([ ] Recalulate before close + [ ] Recalulate before close),
XLB file renamed to force a fresh XLB file, Startup folders are empty, Excel Repaired, eHome site gave incomplete/misinformation,
three days of googling and reading (I have forgotten details of other "tries")
File Types
WinExp > Folder Options > File Types
XLS > Open
default:= "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e
DDE Message: [open("%1")]
[x] Use DDE
modified to := "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "%1"
[ ] Use DDE

In desparation ...
Name:= EnableOnDemand
Type:= DWORD
Data:= 0
(for networks, but worth a try .. no improvement)

Currently investigating:- Install Repair + Clean Install
- courtesy ...

- its looking all a bit daunting
- I am not an expert (only self sort) I hope a clean-install does not require system fiddles in the boot screen
PC1 __ XP Pro SP1 -- fast saves Excel 2003 files (PC build: 2004)
PC2 __ XP Home SP2 -- slow saves Excel 2003 files (PC build: 2010)
PC3 __ XP Pro SP3 -- slow saves Excel 2003 files (PC build: 2008*)
(* PC3 build 2008 and not... Read more

Read other 2 answers

I have these two files: template(attached for reference), The Data file.

The Template – is a form I want to populate with data from the (data file) i attached it so you can see(i want macro to open the datafile filter it by distributor and list all the data for each particular distributor then copy the data and open the template file and paste the copy data on cell a6:g6 and down depend on how many data it pull for that particular datafile.

The datafile – that file has all the information/data I want to populate on the template

PS: I want to be able to run a macro where, macro would filter my data file by distributors and copy the data distributors by distributors and paste it in to the template file(after each distributor/filterdown it create a new ws for the new set of data for the next distributor). I attached some example but I didn’t send the data file OR i would like to have a macro to run every time the value change in cell "c2" it opens the data file and if c2 match value a2 in data file, i want it to copy all the data for that value in column a then copy and come paste it to template form. i attached the template and example or reference.

Your help is greatly appreciated!! plz

A:Populate excel form

Read other 6 answers

I'm new to this particular message board and recently, there has been an issue for my clients at my workplace who has difficulties saving their files into the remote drive on the file server (for example Drive Z:).

Everytime when they open an Excel Spreadsheet for example (my clients use
Office 2007, but some use Office 2003), they modify the data in that file.
When its time to save it, they click on "Save" and it gave them an error message that "this particular file is currently in use by another user. Please try again later."

Even though that there is no one around who is using that file remotely, they still gave the error.

The file server runs on Windows Server 2003 Standard Edition. Some clients
use Windows 7, but all others utilize Windows XP Professional.

Upon further examination, I realized that the particular version of McAfee
Virusscan is probably to blame on preventing the users who save files in
the Office 97-2003 format.

When I saved it under the Office 2007 format (i.e.
.xlsx) it worked fine, but many users want to keep it as .xls - just to maintain
cross-compatibility. I've tried to perform a registry fix for the problematic systems, but the problem persists.

By the way, based on my recent search all over the website, I heard somewhere that a version of an antivirus program was likely to blame for the drive saving issue. The file server wasn't restarted though. It kept on continuously.

The version of McAfee Viru... Read more

A:certain users in Windows 7 could not save Excel files in remote drive

Note to the administrator(s):

Permission to move this thread to the "Microsoft Office support" section of this message. Please reply ASAP.

Read other 1 answers

I'll try to make this as concise as I can:Problems/steps taken:- Running Windows XP SP 2/Office Pro 2003.- User noticed problem this morning; some corporate patches or updates may have been applied since yesterday (not sure).- Initially couldn't open Excel files by any method. Excel would hang and the task would have to be ended.- Used Add/Remove Programs on Office 2003 and chose Repair. Didn't notice a change. Then did Change on Office components and unchecked Excel to remove it. Later re-checked Excel to put it back on.- Noticed that I could now open Excel files by double-clicking on them or opening from recent Excel files list. File | Open or toolbar Open button still make Excel hang.- Also noticed that Save As command from the file menu (or the toolbar, if you add a toolbar Save As button) also makes Excel hang.Notes:- There are no files in XLSTART under the Office11 folder or the user's profile. There are no .xlb (customized toolbar) files on the system. There are also no Add-ins running and never were.- Running Filemon.exe (from Sysinternals.com) shows that several files are not found as Excel tries to Open or Save As, but I'm not sure I see any unfound files that should make any difference. It keeps looking for shell32.dll repeatedly after it's already been found in C:\Windows\system32, where the file does reside.--------SOLUTION (my boss found this, and it worked):This was caused by a recent Microsoft patch. There were apparently also about 40 insta... Read more

A:Excel 2003 Hangs When Trying To Open Or Save As Files - Solved

Hi hotshot309,

Thank you for posting your fix. It helps to see what the fix was.


Read other 2 answers