Over 1 million tech questions and answers.

Excel Macro to open, save embedded pdf and word files

Q: Excel Macro to open, save embedded pdf and word files

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?

Thanks!

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Excel Macro to open, save embedded pdf and word files

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

RELEVANCY SCORE 110.8

I am working in Excel and would like to open, print, and then close an embedded Word document with a button.

Can anyone help?

Thanks for your time!
 

A:Solved: Excel Macro to Open, Print, and Close an Embedded Word Document?

Read other 16 answers
RELEVANCY SCORE 93.2

Hi all

Excellent site! I know I should check for duplicate queries, but couldn't find the search feature as I'm new here and this is my first ever post...

I have two files 'Expenses Analysis' and 'Expenses Form' whereby the user fills out his / her expenses in the analysis file and then transcribes the summary figures into the form on other file, which is then sent off to the finance department.

I've created a simple macro that transcribes the figures between the files when they are both open, but I want it to be clever (=more fool proof) than that. I would like to embed the Expenses Form file into the analysis file, and get the macro to launch the file and enter the figures in one go. (I need to do it this way, rather than combine the functionality, as the Expenses Form is owned by another department and I can't unprotect it etc... ).

Sounds very simple, but I've trouble finding resources on it, as it seems people misuse this functionality for viruses and the like . If another could help me, I'd be much obliged!

I would like to find a way of launching Expenses Form from the Expenses Analysis file, bearing in mind that both files contain macros and a security warning pops up in between.

Kind regards

Neil
 

A:Opening embedded files in Excel using macro

What application are you using? Can you post some sample files?

Rollin
 

Read other 3 answers
RELEVANCY SCORE 83.6

Hi All,

I work on a web application that has Excel and Word documents in it.

At the moment when a user opens these documents in IE9 they get presented with a dialog box asking:

What do you want to do with "filename"?

The user is presented with Open, Save and Save As as the options.

Unlike previous versions of IE there is no check box to tick to remember the user's choice so it comes up every time.

I really need to get rid to this box. Does anyone know how to disable it?

Thanks

Tom

A:How to get Excel and Word documents to open without the Open,Save,SaveAs box opening

Hello and welcome to the forum.

Click Start => My Computer => Tools => Folder Options => Click on File Types tab => In the file types list => click Excel => click Advanced => UNcheck clear the Browse in same window check box (or click to clear the Open Web documents in place check box) => Click OK

Read other 3 answers
RELEVANCY SCORE 83.2

Using Excel 2000, I want to write a macro that opens a specific word doc. I can manage in VB to open a blank word doc...but what is the command for a specific document?

thanks
 

A:Excel 2000: Macro to Open Specified Word Document

Sub OpenWordDoc()

Dim AppWord As Object
Set AppWord = CreateObject("Word.Application")
AppWord.Visible = True
AppWord.Documents.Open Filename:="c:\path\filename.doc"

End Sub
 

Read other 1 answers
RELEVANCY SCORE 81.2

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
RELEVANCY SCORE 79.2

Hello!
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
RELEVANCY SCORE 78

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
RELEVANCY SCORE 78

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
RELEVANCY SCORE 77.2

Just started having trouble opening and saving word files on Mac

Read other answers
RELEVANCY SCORE 76

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
RELEVANCY SCORE 75.6

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.

rigel

Read other 2 answers
RELEVANCY SCORE 75.6

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
RELEVANCY SCORE 75.2

watch out for this new malware attack method by email
http://myonlinesecurity.co.uk/invoice-519658-colin-fox-pdf-malware/

This email contains a genuine PDF which has embedded scripts that will infect you. So far none of the automatic analysis tools can find any malicious content but it is trying to send multicast messages.

I am being told that this evil pdf when opened in adobe reader drops a word document containing macros, so DO NOT SAVE OR OPEN THIS PDF FILE: Just delete the email and any attachment as soon as it appears in your inbox. There appear to be several different versions of the PDF malware dropper although all are named the same and every copy that I have seen is the same file size ( 23kb) The malicious Macro inside the dropped word document ( VirusTotal) from one of the malicious PDFs downloads and executes -> hxxp://bepminhchi.com/83/61.exe ( virus total). There will almost certainly be different download locations depending on which version of the PDF you originally received.

Luckily enough Adobe reader in recent versions has Protected view automatically enabled and unless you press the button to enable all features, you will be safe from this attack
If you do enable all features, then you have a second chance to protect yourself, by pressing either cancel or never allow opening files of this type on the pop up warning. Pressing allow WILL almost certainly automatically open the word doc and run the malicious macro so infecting you. Make sure Adobe ... Read more

Read other answers
RELEVANCY SCORE 74.4

I have older computer running Vista. The system info is as follows:
-------------------
Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft® Windows Vista? Business, Service Pack 2, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU P9400 @ 2.40GHz, x64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1999 Mb
Graphics Card: Mobile Intel(R) 4 Series Express Chipset Family, 775 Mb
Hard Drives: C: 74 GB (17 GB Free); D: 74 GB (45 GB Free);
Motherboard: Dell Inc., 0D201R
Antivirus: None
--------------------

Suddenly it won't all word, excel, pdf, jpg files with message "the file format is not supported or the file is corrupted". I checked the system and found all those files were modified around 7:30PM, March 3, 2017. I copied the files to another good computer and they cannot be opened too. I created new files on the infected computer and they are ok to open.

I read some old post regarding the Ransomware, but on my computer I didn't find any decrypt instruction files, I also ran the IDTool and it didn't report anything.

I don't have regular backup of the files, is there any possibility to identify the virus and recover the file? Thanks!
 

Read other answers
RELEVANCY SCORE 74.4

I had recently installed Norton Antivirus for my PC. After installing this, I was unable to open any Word or Excel documents that are saved under my C: or A: drives. The error message I'm getting is "The file(filename) is not available". My operating system is Windows XP-Pro. And I'm using Windows 2002. Thanks for any help.
 

A:Cannot open Word or Excel files

http://support.microsoft.com/default.aspx?kbid=835404
 

Read other 1 answers
RELEVANCY SCORE 73.6

i am running win xp pro. i have office pro 2003 installed with all the latest updates. The problem comes when i try to open a word or excel file from my desktop or even one of my other drives. Meaning just being able to double-click on the document and having it open. When i do this the folder that the document is in wont respond. Then the folder freezes and i must use task manager to close the folder. Keep in mind that i DONT receive any error messages when double clicking the the file.
i can however, go into start >programs >microsoft office > (word or excel) and open the program there, then open the document. but i shouldnt have to do this.
i have tried to run the repair to no avail. i have uninstalled and then reinstalled office with no luck. Norton windoc found problems (missing files) with my .net framework, so i uninstalled and then reinstalled that. That fixed the .net missing files but not my office problem.

Help me please cuz this has a tendency to be very frustrating!!!!! Tendency meaning every time i try to use the program.
 

A:Excel and word wont open files

Read other 15 answers
RELEVANCY SCORE 73.6

Office 2003 on XP.

If I double-click a .doc or .xls file, I get a brief "Preparing to Install" window that goes away in a second or so. The app then opens to an empty screen. If I then click File/Open, I can drill down to my file and open it that way.

Anyone else have this problem? What did you do to fix it?

Thanks in advance!

A:Word and Excel won't open files directly

This is a long shot, but you may have to associate the files with the program they were meant for. On eway to do this is to open my computer, not any office program. Find the file (files) you want, right click and choose "Open With" and pick the correct program in the list.

In the future your files should open with the right program without any additional efftort.

Let me know if this works.

Read other 3 answers
RELEVANCY SCORE 73.6

I don't know what happened. I can't open any Word / Excel file on my PC. I get the message "Unable to Read File".

Moreover, my Norton anti-virus is gone from my menu bar. I can't run it at all.

What must I do?

Thank you.
 

A:Solved: Help - Cannot Open Word & Excel Files!

What operating system? What version of Office? Did you do anything recently - any new programs installed/removed?
 

Read other 2 answers
RELEVANCY SCORE 73.6

Hi
First time I have asked a question so hope someone can help. Can't identify when it first started to happen but recently all excel files seem to have converted to word files. If word is already running and I try to open an excel file it opens in word and office tries to reinstall.
All excel files are displaying as word files in my documents folders. if I open excel and then open the files they do open and I can then save them in the correct format and they stay in that format.

Hope this makes sense.
 

A:excel 2007 files open in word

Read other 8 answers
RELEVANCY SCORE 72.8

I have Word and Excel 2013 installed and it works fine but will not open a file if I double click on it. I get the error message shown in the attachment. Can anyone suggest how I can correct this? I have checked the default programs list and (e.g.) Excel is identified for xls or xlsx files.
Up to today I had 2010 and 2013 both installed on this machine and used 2010 typically. I deleted 2010 thinking it might correct this but it did not.

Thanks in advance.
 

Read other answers
RELEVANCY SCORE 72.8

I've been trying to resolve this very slow opening problem, but no success.
Tried "detect and repair", this worked but after restart or shutdown the problem came right back.
Any suggestions for a fix, hopefully short of reinstalling MS Office, would be greatly appreciated.

OS XPPro SP3 fully updated
MS Office 2003 fully updated

Thanks in advance
 

A:MS office files, Word and Excel, very slow to open

Sounds like a machine error... Tell us about your computer, connection, antivirus, and antispyware in some detail... We would like to know brand, or motherboard, age, and configuration... as well as your spyware and antivirus
 

Read other 5 answers
RELEVANCY SCORE 72.8

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

Read other 16 answers
RELEVANCY SCORE 72

I've got three Word 97 files, each with an Excel spreadheet in the top 2/3 of the page, with the rest of the page being regular Word text. THe font being displayed in the Excel portion appears crunched together, larger, and bolded. When I select the cells to edit it they are all set at Arial 10 pt. It looks fine when working in the cells, but as soon as I click out of that Excel frame the font reverts to the mess I first described.

Is this something that I must live with or is there a setting somewhere that is causing this conversion?
 

A:Word 97: Embedded Excel Frame

Read other 8 answers
RELEVANCY SCORE 72

I embedded an Excel Bar Chart in an MS Word doc (both Word & Excel are 2003 versions) - I placed a second bar chart in the MS document as a picture. Both charts have a parchment color for the plot area - and red colored bars. When I click on 'print preview' in the Word doc the plot color shows as parchment. However, when I print the Word doc the plot area prints as grey (although the red bars print as red). I've tried everything I can think of but the plot area still prints grey. {If I print the charts from Excel where they were created the color prints fine - parchment background.)

Any ideas? THANKS
 

Read other answers
RELEVANCY SCORE 72

I embedded an Excel Bar Chart in an MS Word doc (both Word & Excel are 2003 versions) - I placed a second bar chart in the MS document as a picture. Both charts have a parchment color for the plot area - and red colored bars. When I click on 'print preview' in the Word doc the plot color shows as parchment. However, when I print the Word doc the plot area prints as grey (although the red bars print as red). I've tried everything I can think of but the plot area still prints grey. {If I print the charts from Excel where they were created the color prints fine - parchment background.)



Any ideas? THANKS

 









  • RELEVANCY SCORE 72

    I am inserting a spreadsheet into a word document (not linked) using a custom VB6 application (ActiveDocument.Shapes.AddOLEObject...). After I insert the spreadsheet I would like to be able to reference it as an object so I can add/delete rows, set cell values, etc. Can this be done? Any references to code examples using VB or VBA would be appreciated.
     

    Read other answers
    RELEVANCY SCORE 72

    Hello,

    I am using Windows Vista & Word 2007 + a Pocket PC-Smartphone.

    When I used Word 2003 I could create files & save them to my phone.

    Now that I'm using Word 2007, it wont let me save files to the phone, though I can open files CREATED on the phone.

    What am I doing wrong?

    Thanks!!
    Wes
     

    Read other answers
    RELEVANCY SCORE 72

    When I open word or excel from the task bar 3 out of 4 times two screens will open.
     

    A:Word/Excel 2000: Two Files Open when launched from taskbar

    Read other 10 answers
    RELEVANCY SCORE 72

    I can't open MS Office application files from the Explore window or from Desktop.

    The MS Office applications icons, such as WORD or EXCEL, have been replaced. All my Word files now bear the Wordpad icon and when clicked open as such. My Excel files now bear some other icon that no application on my machine can open.

    However, when I open an office app, such as WORD or EXCEL, and then try to open a related file that now has a funny icons, they open properly.

    Have MS xp; Excel 2002; Word 2002.

    Grateful for advice.

    A:[SOLVED] Can't open Word or Excel files from Explorer window

    You probably need to set the file assocations.

    If you go into your Control Panel > Folder Options > File Types (tab), then scroll down until you locate those file extensions (.doc, .xls, etc...).

    Alternatively, there is probably somewhere in Microsoft word, or excel where you can automatically set file associations, but it would depend on which version you have.

    Read other 2 answers
    RELEVANCY SCORE 72

    Hello all,

    I needed some help here, one of my friend having the problem which is his microsot word or excel files open in read only file.

    He using Windows Vista and Microsoft Office 2007.

    Anyone here can help me on this?

    Thanks

    A:microsot word or excel files open in read only file

    Try reversing the steps in this procedurehttp://office.microsoft.com/en-us/excel/HA101527191033.aspxAlso read the comments section

    Read other 2 answers
    RELEVANCY SCORE 71.6

    I work in an office with some "stupid" people so need to write a macro that will convert word (2003) .doc files to .pdf (Adobe Acrobat 6.0 Professional) when they go to save these important documents. Is this possible & how do i use the macro? I know it is possible to select it as a print option but they aren't able to
    Any help would be more then welcome.
     

    A:Macro to Save Word as PDF?

    Read other 16 answers
    RELEVANCY SCORE 71.6

    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,

    Bill
     

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

    Read other 11 answers
    RELEVANCY SCORE 71.2

    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

    Read other 7 answers
    RELEVANCY SCORE 71.2

    Okey here is what i need help with, ive tried everything i can thing of.

    My excel document has 3 sheets, and i have a macro to compile some logs on the first two.(excel macro).

    on the last page i have an embeded word document, and i have a macro written for it on my pc.

    The problem is i need to distribute the 3 page log to a lot of people, and when i send it, it doesnt send the macros for the embeded word document.

    any help would be greatly appreciated .
     

    Read other answers
    RELEVANCY SCORE 71.2

    I have a MS-Word document (Office 2000) which has some embedded spreadsheets. Can I access individual Excel cells (location is relatively static) and copy the data from the cell into a location in MS-Word (using bookmarks, etc.) ?

    In another word document, I have multiple embedded spreadsheets. Can I reference cell information in one embedded spreadsheet from another embedded spreadsheet? Eg. each spreadsheet has a subtotal cell and the final spreadsheet of the document is supposed to list all the subtotals and then calculate the overall total.

    Thanks

    Phil
     

    A:Referencing embedded Excel Cell in MS-Word

    Read other 7 answers
    RELEVANCY SCORE 70.8

    This is sort of relates to my other thread, but is for word this time so I figured it deserves its own thread.

    I need a macro in MS Word, that will, before saves, update footer fields. This is mainly to automatically update the timestamp without having to go into print preview.

    the update all keyboard command does not apply to headers / footers it seems.
    I found a macro that will update all including headers and footers.

    Sub UpdateAll()
    Dim oStory As Range
    Dim oField As Field
    On Error Resume Next
    For Each oStory In ActiveDocument.StoryRanges
    For Each oField In oStory.Fields
    oField.Update
    Next oField
    Next oStory
    On Error GoTo 0
    End Sub

    I just need to a macro to launch the above macro before every save.

    Thanks.
     

    A:Solved: MS Word Macro - Before Save

    Read other 16 answers
    RELEVANCY SCORE 70.8

    My sense is this is a pretty simple request, but I'm completely illiterate when it comes to VB.

    I have an excel spreadsheet with a number of data points. I'm looking to export the entire sheet to a CSV file and send it via Outlook. Any suggestions?
     

    Read other answers
    RELEVANCY SCORE 70.8

    I have a macro that saves my 40 page workbook to a PDF. The problem is that it places blank pages between each worksheet in the PDF.

    Is there a way to stop the blank pages from occurring?

    Here is the code I am using:
    Code:

    ThisFile = "C:\" & Replace(ActiveWorkbook.Name, ".xls", "") & ".pdf"

    ActiveWorkbook.ExportAsFixedFormat _
    Type:=xlTypePDF, _
    Filename:=ThisFile, _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=False


     

    A:Solved: Excel Macro -> Save As PDF

    I found the answer on Adobe's website. The site indicated that the blank pages were a result of all the sheets having a different print quality.

    Once I changed all the sheets to have the same print quality, the blank pages did not appear in the PDF.
     

    Read other 1 answers
    RELEVANCY SCORE 70.8

    I am trying to automate a spreadsheet that all our employees must update each day.

    I would like the file to close after a set period of time (1 Minute)
     

    A:Save and Exit by Macro in Excel

    I've always steered clear of this as I've heard it's a killer on resources. Plus I wouldn't know where to begin.

    So here is some code from the outstanding Tom Ogilvy to get you (or it) started -

    Public NextTime As Date
    Public EndTime As Date
    Sub StartCount()
    EndTime = Now + TimeValue("00:01:00")
    NextTime = Now + TimeValue("00:00:01")
    ActiveSheet.Range("A1").NumberFormat = "hh:mm:ss"
    ActiveSheet.Range("A1").Value = EndTime - Now
    Application.OnTime NextTime, "Continuecount"
    End Sub

    Sub Continuecount()
    NextTime = Now + TimeValue("00:00:01")
    If EndTime - Now < 0 Then Exit Sub
    ActiveSheet.Range("A1").Value = EndTime - Now
    Application.OnTime NextTime, "Continuecount"
    End Sub
     

    Read other 3 answers
    RELEVANCY SCORE 70.4

    Q: Has anyone seen this problem and is there a patch or setting for Word XP that fixes it?

    We have a document created in Word 97 with an embedded Excel Spreadhseet object displaying a chart.

    When we open the document in Word 97, everything is normal.

    When we open the document in Word XP the chart is rotated 180 degrees around the vertical axis. The chart is right side up, but the left side of the chart is on the right and all the letters are reversed.

    When I double-click the object to edit it the chart flips around to normal. When I exit edit mode (without making any changes) it flips back.

    When we convert the Excel Worksheet object to an Excel Chart object in Word 97, save the file, and open in Word XP the chart displays normally.

    The problem is that we have an automated PDF converter that uses Word XP, so when we create the PDF, it is created with the reversed chart. We are not staffed to open every Word 97 document and convert spreadsheets to charts. How can we fix this without installing Word 97 on the converter?
     

    A:Embedded Excel Object flipped when opened in Word XP

    Read other 7 answers
    RELEVANCY SCORE 70.4

    Hi

    We have a problem here at work that no one has been able to figure out. I thought someone in here might have an idea:

    Our Budget Analyst print "Budget Books" every year. These are Word documents with embedded Excel Spreadsheet links. The links are set to update automatically, but we've tried manual etc. with no luck. The links to the spreadsheets are good and accurate, when you go into print preview everything shows up correctly.

    When you actually print the document, say it's a 9 page document, typically at least one of the pages will have either the wrong spreadsheet linked to it or there will be huge letters printed on top of eachother where the spreadsheet link should be.

    You go back to look at the document and it's fine, the print preview is still fine, the links are up to date and correct. I tried running a manual link update just before printing and this didn't fix it. The problem is not just one link, everytime you print it, it may jump around and just change where the spreadsheets are printed or put those big letters in different spots.

    We are printing to a HP 5si networked printer, NT 4.0 server, NT 4.0 workstations with 384 mb of RAM each.

    The only way we've been able to fix this is to have the budget analysts block, copy and paste their links again before printing.
    Or break the 9 page document (or however many pages) into 9 one page documents.

    Anyone have any ideas?

    thanks
     

    A:Printing Word Docs with Embedded Excel Links

    If I'm hearing you right, I've helped someone with this before. It's not the greatest, but it SHOULD work.

    I suspect that you are using, for instance, one workbook to link to. Office doesn't like using more than Sheet1 to integrate with other apps. For instance, if you do a mailmerge, you'll have fun getting it to link to sheet2.

    If these are financials of some sort, then I imagine that your ranges don't *change size* much. Good.

    Create a new workbook for each of the Excel *ranges* you want to put into the doc file. In THEM, paste links from your *real* workbook. Link your Word doc to each of these new workbooks. That way, one workbook per link. You *should* get better results. I helped someone else do this, and they got better results.
     

    Read other 1 answers
    RELEVANCY SCORE 70.4

    I run a weekly excel 2007 macro that converts a spreadsheet to a Word document, but it stops after row 29 of data. Any spreadsheet with 29 rows or less works fine. If I have 34 rows of data, the macro hangs. See below for script. Any help would be appreciated.

    Public Sub AddControls(WrdApp As Word.Application, CurRow As Integer)
    Dim OptChecked As Boolean
    Dim GrpName As String
    GrpName = "Grp" & CurRow
    'Calculate the colors based on the cell information.
    CurRange = "F" & CurRow & ".." & "F" & CurRow
    Range(CurRange).Select

    If InStr(1, UCase(ActiveCell.Text), "X SRM") > 0 Then 'SRM
    OptChecked = True
    Else
    OptChecked = False
    End If

    SetCellBG WrdApp, True
    WrdApp.Selection.TypeText Text:="Governance:" & vbCrLf

    Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
    With RadioObj.OLEFormat.Object
    .GroupName = GrpName
    .Caption = "SRM"
    .Font.Name = "Arial"
    .Font.Size = 8
    .Value = OptChecked
    End With

    If InStr(1, UCase(ActiveCell.Text), "X PPO") > 0 Then ' PPO
    OptChecked = True
    Else
    OptChecked = False
    End If

    WrdApp.Selection.Collapse Direction:=wdCollapseEnd
    WrdApp.Selection.TypeParagraph

    Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
    With RadioObj.OLEFormat.Object
    .GroupName = GrpName
    .Caption = "PPO"
    .Font.Name = "Arial"
    .Font.Size = 8
    .Value = O... Read more

    A:Excel Macro - converting excel to word doc - stops after row 29

    Read other 13 answers
    RELEVANCY SCORE 70

    Good Evening,

    I am trying to save a workbook using a macro, but I can not get it to save in a folder called Sugar_cookies. It just saves in the specified drive. Any idea what I do wrong?

    ActiveWorkbook.SaveAs Filename:= "N:\Sugar_cookies" & DateDay & addinfo

    Thank you,
    codedreamer
     

    A:How to save excel in a specific folder using a macro

    Read other 6 answers
    RELEVANCY SCORE 69.6

    I have a MS Word document with embedded Excel objects. If I open the embedded object, any cells with > 256 characters are truncated. Rumor has it that there is a registry entry that can be edited to account for this.
     

    A:Word 2000: Truncating Data in Embedded Excel Cells

    Read other 6 answers
    RELEVANCY SCORE 69.6

    Windows XP - Office 2003 & Office 2007 - Sharepoint (not the current version) - McAfee Virus Scan

    We have users who use sharepoint to open word docs. The Word docs were created in Word 2003 and when they were created they embedded Excel 2003 sheets.
    We have since upgraded to Office 2007 and now SOME but not all users try to go into sharepoint and open those word docs and then try to open embedded excel sheets they are getting the message:
    Microsoft Office Word Can't start the application required to open this object.
    An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?
    If we say NO it gives another error message:
    This object is corrupt or is no longer available.
    If we say YES to repairing the feature then it goes through the install process and we have to restart.
    This does not fix the issue.

    I have tried several things to fix this and none of them have worked.
    I have tried enabling the macro security and link security among other things.

    I have searched this site and googled it and am not finding the exact issue or a resolution to this issue.
    Can anyone give me any sound advice? or something else to try.
     

    Read other answers