Microsoft Office Forums Is it possilble to transfer data from Excel to Publisher?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2011, 03:14 AM
markhuges markhuges is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 32bit Is it possilble to transfer data from Excel to Publisher? Office 2003
Novice
Is it possilble to transfer data from Excel to Publisher?
 
Join Date: Oct 2011
Posts: 5
markhuges is on a distinguished road
Default Is it possilble to transfer data from Excel to Publisher?

Hello i am new here



i have a excel spreadsheet, which is used for a shop which has simple stock and items

the spreadsheet, has different items, their prices and the stock amount.

it currently takes in customer details, and then selects the items.

The question is that, If i create a template on Microsoft Publisher which is a Template like a receipt

would it be possible to get the data from excel (the customer names and items ) and somehow ( this is the part i dont know or understand) paste that data onto the publisher Template and than print out that receipt.

i have a userfrom and macros recorded, on the excel spreadsheet

would it be possible to create a macro from the userfrom menu - which take the data (customer recipt ) and automatically entere that data on a pre set templete reciept - on publisher


is this possible? Thank You
Thank You
Reply With Quote
  #2  
Old 10-22-2011, 10:34 PM
macropod's Avatar
macropod macropod is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 64bit Is it possilble to transfer data from Excel to Publisher? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Mark,

I'm not familiar with Publisher, but this can be done fairly easily with Word. Is there a particular reason for using Publisher?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-23-2011, 12:31 AM
markhuges markhuges is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 32bit Is it possilble to transfer data from Excel to Publisher? Office 2003
Novice
Is it possilble to transfer data from Excel to Publisher?
 
Join Date: Oct 2011
Posts: 5
markhuges is on a distinguished road
Default

Yes one of the requirments is that it has to be done on publisher

how would you do it on word? and would it be possible to do the same thing on publisher
Reply With Quote
  #4  
Old 10-23-2011, 02:45 AM
macropod's Avatar
macropod macropod is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 64bit Is it possilble to transfer data from Excel to Publisher? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Mark,

For Word, what you'd do is to first define an Excel range that will always hold the data that Word will link to (eg a Sheet named Xfer, in which whatever data are to be linked will appear in A1:C3). Then you'd copy that range and paste it into Word using Edit|Paste Special with the 'Paste Link' option and the paste format you desire. From then on, whenever the data in Xfer A1:C3 changes, the link in Word will update.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 10-23-2011, 03:14 AM
markhuges markhuges is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 32bit Is it possilble to transfer data from Excel to Publisher? Office 2003
Novice
Is it possilble to transfer data from Excel to Publisher?
 
Join Date: Oct 2011
Posts: 5
markhuges is on a distinguished road
Default

@MacroPod - Thank You for that will run a mini test and give feedback Thank You


Yes it does work with word but not on Publisher

i was thinking would it be possible to do that using VBA and doing that process automatically? Thank You
Reply With Quote
  #6  
Old 10-23-2011, 03:31 AM
macropod's Avatar
macropod macropod is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 64bit Is it possilble to transfer data from Excel to Publisher? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Mark,

I don't understand why Publisher is the requirement, since Word can create receipt-like documents perfectly well. Still, that's your (organisation's?) decision. I'm suppose you could automate Publisher from Excel, or vice-versa, but I have no experience with that - only automating Word from Excel, and vice-versa.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 10-23-2011, 04:41 AM
markhuges markhuges is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 32bit Is it possilble to transfer data from Excel to Publisher? Office 2003
Novice
Is it possilble to transfer data from Excel to Publisher?
 
Join Date: Oct 2011
Posts: 5
markhuges is on a distinguished road
Default

Ok thanks, how long and how hard do you think it would be to create a code to automate Publisher from Excel?
Reply With Quote
  #8  
Old 10-23-2011, 05:11 AM
macropod's Avatar
macropod macropod is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 64bit Is it possilble to transfer data from Excel to Publisher? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Mark,

That's rather like asking: how long is a piece of string? It all depends on your familiarity with vba, using vba to automate Office apps, and the Publisher Object Model.

FWIW, here's some code showing how you might update a Word document from Excel. The code copies Range "A1:J10" on the first worksheet as an OLE object to a bookmark named "xlTbl" in a Word document named "C:\My Documents\MyFile.doc", and leaves the document active & visible:
Code:
Sub SendRangeToDoc()
Dim wdApp As Word.Application, WdDoc As String
'Copy range
ActiveWorkbook.Sheets(1).Range("A1:J10").Copy
'Establish link to Word
WdDoc = "C:\My Documents\MyFile.doc"
If Dir(WdDoc) <> "" Then
  Set wdApp = New Word.Application
  wdApp.Visible = True
  With wdApp
    'open the Word Document
    Documents.Open Filename:=WdDoc
    Dim BmkNm As String
    BmkNm = "xlTbl"
    With ActiveDocument
      If .Bookmarks.Exists(BmkNm) Then
        .Bookmarks(BmkNm).Range.PasteSpecial Link:=False, DataType:=wdPasteOLEObject, _
        Placement:=wdInLine, DisplayAsIcon:=False
        .Save
      Else
        MsgBox "Bookmark: " & BmkNm & " not found."
      End If
    End With
  End With
Else
  MsgBox "File: " & WdDoc & " not found."
End If
Set wdApp = Nothing
End Sub
For Publisher, the approach would be similar. See also:
http://msdn.microsoft.com/en-us/office/aa905474.aspx
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 10-23-2011, 05:55 AM
markhuges markhuges is offline Is it possilble to transfer data from Excel to Publisher? Windows 7 32bit Is it possilble to transfer data from Excel to Publisher? Office 2003
Novice
Is it possilble to transfer data from Excel to Publisher?
 
Join Date: Oct 2011
Posts: 5
markhuges is on a distinguished road
Default

Thank You for your help will try that soon around in a week and give feedback
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possilble to transfer data from Excel to Publisher? Wine List, Data Merge - Excel to Publisher - Or other suggestions? daym Publisher 2 05-01-2011 03:45 AM
Is it possilble to transfer data from Excel to Publisher? Transfer Outlook info to Excel methedr Outlook 1 05-24-2010 05:48 AM
Is it possilble to transfer data from Excel to Publisher? How to transfer Word 2003 Tables to Excel? steeleye Word Tables 1 07-10-2009 04:18 PM
Is it possilble to transfer data from Excel to Publisher? How to transfer multiple cells from excel to word by formulas justziggy Word 5 05-23-2009 02:33 AM
TRANSFER DATA TO NEW WORKSHEET BOBN Excel 0 11-08-2007 10:34 PM


All times are GMT -7. The time now is 04:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft