Free Microsoft Excel 2013 Quick Reference

Embedded Excel file in Word

I have an embedded Excel worksheet in a Word file (2003). In the Word file,
there is a table that is linked to the embedded Excel worksheet.

If I double-click on the table, it opens Excel and I can make changes.
However, if I attempt to do that while Excel is already running, I get a
"file not found" from Excel.

I need to widely distribute this file and I want to minimize the
instructions I will give. This will be distributed to finance people who
always have their Excel running.

Is there a work around?

Thanks


Post your answer or comment

comments powered by Disqus
I have an embedded Excel file in word and when I go to print, it is printing with the gridlines. In excel I have the gridlines turned off and it is still not working.

HELP!

Thanks

Embedded Excel objects in Word turning into a jpg problem; sometimes I embed an Excel object into a Word document, and it turns into a jpg. Anybody know a way to deal with this?

I have 4 separate embedded Excel Spread Sheets in a Word 2001 Document. I would like them to transfer data to each other... as in, when one cell is edited, and other "linked" cells are updated immediately.
I seem to get this done for a short period of time by copying one cell, and then "paste special", and then "paste link", and then "Unicode text" (I've also tried just "text").
The two embedded spreadsheets do link and update respective data UNTIL, I press the Save button; after that, they do not transfer data to each other.

When I click on the cell that was pasted too, the Excel formula is as follows:

=Excel.Sheet.8|'C:Documents and SettingsGrapes of WrathMy DocumentsBEO TEMPTemplates for ACT!BEO TEMP.ADT'!'!_1295620705!Sheet1!R2C2'

AND, I created all the embedded Excel sheets IN Word 2001, by selecting the spreadsheet button above, in the menu bar with the 'X' icon.

I've tried on and off for years, and can't do it... so thus, I ask of ya'll. Thank you so much in advance.

Hi, I want to write a VBA macro in Word that open an Excel file, save that Excel file to another file (to another name), and then clear all content of the original Excel file. How to do that? Thanks!

I am being forced to work in Word Perfect 12 temporarily. I can't seem to
open or import any Excel files into a compatible WP program (what would that
be?) or so that they function and can be edited

I have a Word Template that has several embedded Excel spreadsheets in it.
This template is used by people who need to enter data then change it if
necessary. After entering information then going back into Word, some of the
spreadsheets often become "corrupt or no longer available". You cannot get
back into the spreadsheet to edit. And if you change the wrap options, the
embedded object becomes a picture.

Does anyone have any ideas as to what could be happening? I think it happens
after they have edited it a couple of times.

Thanks!

I'm building an Office Application with Excel part of the application. This
is all being done using Office 2000 Professional running under XP Pro (SP2)

I have embedded several Excel tables and associated graphs in a Word
document. I have done this using VBA, sucking in the tables and graphs from
Excel, to bookmarked locations in Word. All works fine except that I have
these surplus table rows appended after each graph in Word, causing
unnecessary page breaks in Word, which then have 2B manually deleted.

I have assigned each table and graph combination a range named in Excel. The
range extends over the table and the graph completely. Does anyone know of a
"clean" way to pluck out Excel tables and graphs for embedding into Word
without all those surplus table rows? eg. Is it possible to just plug the
graph into Word from Excel using VBA?

--

Richard John
rjbpond@bigpond.net.au

I've seen a few posts about issues copying worksheets containing cells with
text values > 255 characters. I have a similar issue but it involved copying
a cell range from Excel and using Paste Special to paste them as an embedded
workbook in Word.

If I copy the cell range from one Excel worksheet and paste them to another
worksheet the cell contents are not truncated. However, when I paste special
into Word as an embedded workbook, the cell contents are truncated.

Is there a way to get the Excel cell range into an embeeded workbook in Word
(or PowerPoint) without having the text truncated?

- Drew

I have a Word Template that has several embedded Excel spreadsheets in it.
This template is used by people who need to enter data then change it if
necessary. After entering information then going back into Word, some of the
spreadsheets often become "corrupt or no longer available". You cannot get
back into the spreadsheet to edit. And if you change the wrap options, the
embedded object becomes a picture.

Does anyone have any ideas as to what could be happening? I think it happens
after they have edited it a couple of times.

Thanks!

I work with a warehouse set up in access. I do my query to get my info. Then
I copy the data to an excell file. I usually do name & address info. The zip
field looks fine in excell, but when I use the excell file in word to do a
mail merge when I match the fields an F7 appears in the zip field & all my
leading zeros are dropped. The only way to keep my leading zeros is to change
the zip field to "text" and key all the zips with leading zeros and then
bring the file into word for the mail merge. Any help would be appreciated.

Embedded Excel objects in PowerPoint Slides crash without fail!!

When I double click the powerpoint slide to get to the editing mode for the embedded Excel object in powerpoint, either powerpoint, Excel or both "Encounter and Error and have to shut down"! My IT dept updated all my drivers, apps, BIOS etc., I keep files and apps open to a minimum...Maybe a memory (RAM) issue? I have 2GB of memory.

There is no 'obvious' cause or pattern to avoid and it crashes as dependable as the sun will come up in the morning. The two apps just don't work together!! Please help!!!

i want to paste part of an excel file into word without the gridlines. I went to help and it says goto tools - options - views - windows options - and click gridline box. this removes gridlines in the excel sheet but when i copy and paste into word the gridlines are still there. How do i get rid of them.

I want to open different Excel files in a different window just as you can
with Word documents. Is this possible? How?

I used to be able to open each excel file in its own window that could be
minimized and maximized on its own. Now all files are opening in one window.
I do not want to arrange the files in that window- I want all files in their
own windows. All file names appear in the taskbar- but they still all open
in the same window when clicked. Strangely enough my MS Word files on the
same computer are still opening in their own windows . . . . any advice?

Thanks

Hi,

I'm having a problem at the moment - I need to do a large find & replace with my excel data. I actually do two, the first one works fine but the second one doesn't;

The first one I just open my.csv file in word, do my find and replace, save again and it opens fine in excel.

The second one though, I need to find and replace the paragraph breaks and replace them with the tag <br />. When I save it again and open in excel, my results are displayed across the top row instead of the column, and they're no longer in a single cell for each record.

I'm guessing it's because I take away all of the blank lines from word but I'm not sure.

does anyone have any suggestions how I could sort it?

Regards,

Saybut.

I work with a warehouse set up in access. I do my query to get my info. Then
I copy the data to an excell file. I usually do name & address info. The zip
field looks fine in excell, but when I use the excell file in word to do a
mail merge when I match the fields an F7 appears in the zip field & all my
leading zeros are dropped. The only way to keep my leading zeros is to change
the zip field to "text" and key all the zips with leading zeros and then
bring the file into word for the mail merge. Any help would be appreciated.

This is probably more than of a PowerPoint question than Excel, but since it is at least partially related to Excel, and there is no PPT forum here, I thought I'd try my question here.

I have a PowerPoint Presentation that has a number of tables and charts were copied in as embedded Excel files. A number of these have confidential information stored on some of the worksheets. I need to send this presentation to the conference organizer, and not have the contents of the embedded files accessible. Typically we just pdf the slides and send that, but in this case we have just been told that they are assembling all presentations into one master PowerPoint file, so all presentations need to be given to them as a .ppt. This is also a long presentation, and it has taken a long time to get layout of all the tables right, so going in and cutting out each table, and then pasting in a picture (and having to do the layout on the slide again) is a definite PITA and I'd like to avoid this if at all possible.

Any suggestions?

Hi,

1. I require VBA code to overwrite excel file in destination folder if exist.

2.
Actually my macro code first sort,save and close the file, then it copy and paste this excel file to destiny network drive.

All things are working here except copy and paste. I am able to copy and then move file to destiny but I want to paste it and not move.
Help in this regard really appreciated

I have posted this question in
http://www.excelforum.com/excel-prog...ml#post1959252

Hi,

I have the following code to send automatic email to n number of people at one short.

I have 3 columns in excel.
Column A - Email addres
Column B - Some numbers ( subject)
Column C - Some Links ( body of the message)

wen i run the macro, email goes to all the email address in column A with the subject in column B and with the links in column c respectively and adds the body of the message in sheet 2.

the program is working fine. I just want to add the code to attach an excel file to all these emails.
Assume I have the excel file in My C drive my documents folder.

The code is below

Thanks to leith for providing this code earlier.

'Written: March 31, 2008
'Author: Leith Ross
'Summary: Sends out emails from a worksheet list. The message body is on
' a separate worksheet. This worksheet is copied to a file in
' HTML format. The file is opened an copied as a string which
' becomes the mesaage body in Outlook.

'Used to find the Outlook icon in the system tray. If present then Outlook is running
Private Declare Function FindWindow _
Lib "user32.dll" _
Alias "FindWindowA" _
(ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long

Sub EmailFromWorksheet()

Dim FSO As Object
Dim HTMLcode As String
Dim HTMLfile As Object
Dim Msg As String
Dim myInstance As Boolean
Dim olApp As Object
Dim olEmail As Object
Dim olPID As Long
Dim R As Long
Dim TempFile As String
Dim Wks As Worksheet

'Outlook constants aren't available using late binding
Const olByValue = 1
Const olCC = 2
Const olFolderContacts = 10
Const olMailItem = 0
Const olFormatHTML = 2

'Starting Row of Email Data
R = 2

'Set some program variables
TempFile = "C:MyEmail.htm"
Set Wks = Worksheets("Body of the Message")

'Start Outlook if it isn't running
If FindWindow("Outlook Notification Area Icon Window", vbNullString) = 0 Then
myInstance = True
olPID = Shell("C:Program FilesMicrosoft OfficeOffice11OUTLOOK.exe", 2)
End If

'Assign variable to the running instance
Set olApp = GetObject("", "Outlook.Application")

'Trap any errors
On Error GoTo CleanUp

'Stop the email loop if cell is blank
Do While Cells(R, "A") ""

'Add URL to the Body of the Message worksheet
Wks.Cells(1, "A") = Cells(R, "C").Text

'Convert the Message worksheet into HTML
With ActiveWorkbook.PublishObjects.Add( _
SourceType:=xlSourceRange, _
FileName:=TempFile, _
Sheet:=Wks.Name, _
Source:=Wks.UsedRange.Address, _
HtmlType:=xlHtmlStatic)
.Publish (True)
End With

'Read the HTML file back as a string
Set FSO = CreateObject("Scripting.FileSystemObject")
Set HTMLfile = FSO.GetFile(TempFile).OpenAsTextStream(1, -2)
HTMLcode = HTMLfile.ReadAll
HTMLfile.Close
HTMLcode = Replace(HTMLcode, "align=center x:publishsource=", _
"align=left x:publishsource=")

'Compose the email
Set olEmail = olApp.CreateItem(olMailItem)
With olEmail
.To = Cells(R, "A").Text
.Subject = Cells(R, "B").Text 'Voucher Number
.BodyFormat = olFormatHTML
.HTMLBody = HTMLcode
.Send
End With

'Increment Row counter
R = R + 1
'Delete the tempoary file
Kill TempFile
'Delete the Published Object
With ActiveWorkbook.PublishObjects
.Item(.Count).Delete
End With
'Get the next email cell
Loop

CleanUp:
'Close Outlook instance if this macro created it
If myInstance = True Then TerminateProcess olPID
'Was there an error
If Err 0 Then
'Delete the Temp File
If Dir(TempFile) "" Then Kill TempFile
'Delete the Publish Object
With ActiveWorkbook.PublishObjects
If .Count 0 Then .Item(.Count).Delete
End With
End If

'Free memory resources
Set olApp = Nothing
Set olEmail = Nothing
Set FSO = Nothing

End Sub

Public Sub TerminateProcess(ByVal PID As Long)

Dim colProcessList As Object
Dim objProcess As Object
Dim objServices As Object
Dim ProcessRetVal As Long

'Connect to the WMI namespace through the local computer "."
Set objLocator = CreateObject("WbemScripting.SWbemLocator")
Set objServices = objLocator.ConnectServer(".", "rootcimv2")

' Terminate the Application by its Process ID
Set colProcessList = objServices.ExecQuery _
("SELECT * FROM Win32_Process WHERE ProcessId =" & Str(PID))

' WMI requires a loop even if there is only one object
For Each objProcess In colProcessList
ProcessRetVal = objProcess.Terminate()
If ProcessError(ProcessRetVal) Then Exit For
Next objProcess

CleanUp:
Set objLocator = Nothing
Set objServices = Nothing
Set colProcessList = Nothing
Set objProcess = Nothing
End Sub

Private Function ProcessError(ByVal Err_Value As Long) As Boolean
Dim Msg As String
If Err_Value = 0 Then Exit Function

ProcessError:
Select Case Err_Value
Case 2
Msg = "Access Denied"
Case 3
Msg = "Insufficient Privilege"
Case 8
Msg = "Unknown failure"
Case 9
Msg = "Path Not Found"
Case 21
Msg = "Invalid Parameter"
End Select
MsgBox Msg, vbexcalamtion, "WMI Win32_Process"
ProcessError = True
End Function

Hi,

I am currently having an issue with VB saving a backup copy of the file i open. I originally had this setup to save a backup copy of my excel file in the same folder as the original file, but I found out that it is saving the file to different locations. it looks like it saves it to the last folder that i was browsing in excel to open another file.
Is there any way to fix this issue?
Any help is greatly appreciated.

Below is the coding that i use.

Private Sub Workbook_Open()

Dim MyBackupPath As String
MyBackupPath = "DO NOT OPEN -"
ActiveWorkbook.SaveCopyAs MyBackupPath & " " & ActiveWorkbook.Name

End Sub

Hi
I want to save an excel file in multiple files.
The data sheet is like that ...
23/4/07 00:00:00 7.72 0.73 6.92 0.63 281.62
23/4/07 00:10:00 7.11 0.56 6.42 0.68 279.88
23/4/07 00:20:00 7.05 0.42 6.66 0.60 281.26
I want to split the file in several files containing only the same date.
Do you know any way?

Thnx in advance

Hi Anyone who can give me a hand?

I am trying to open excel files in a file path which includes folders which also have excel folders i wish to open there are quite a few.

At the moment i am working with this code but it fails to open excel files which are within the folders in the specified file path. Its fine for excel workbooks in the folder specified by file path.

This is the code i am using can anyone help?

Sub RunCodeOnAllXLSFiles()
Dim lCount As Long
Dim wbResults As Workbook
Dim wbCodeBook As Workbook

Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False

On Error Resume Next

Set wbCodeBook = ThisWorkbook

With Application.FileSearch
.NewSearch
'Change path to suit
.LookIn = "L:filesmystuff"
.FileType = msoFileTypeExcelWorkbooks
'.Filename = "Book*.xls"

If .Execute > 0 Then 'Workbooks in folder
For lCount = 1 To .FoundFiles.Count 'Loop through all.
'Open Workbook x and Set a Workbook variable to it
Set wbResults = Workbooks.Open(Filename:=.FoundFiles(lCount), UpdateLinks:=0)

'DO YOUR CODE HERE

wbResults.Open SaveChanges:=True

Next lCount
End If
End With

On Error GoTo 0
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub

Is there VBA code to click 'yes' to save data on clipboard when closing an Excel file in a macro? The macro allows to choose a unique file each time and copies specific information and I want the macro to close file but keep the info on the clipboard to paste into the main data file where the macro is stored. I cannot seem to find the code to click 'yes' for this option. Any suggestions??

Thanks,
Colleen

I have been trying to wrap my head around this one, and I just can not seem to get it to work.

Bottom line up front: How do you get one embedded Excel object in
Powerpoint to refer to another Excel Object in another Powerpoint
Presentation?

Situation: I have several people that send me weekly stats for their
companies on Power Point Slides with the information being stored in Embedded Excel Workbook objects. Once a quarter I have to do a complete rollup of their latest information. Right now I am having to hand jam the numbers. Is their a better way?

Thanks in advance

Stephen


No luck finding an answer? You could always try Google.