Hi

I'm using Office 2000 and Visio 2000 in a networked Windows 2000
environment. We are finding that more and more time is being spent rotating
spreadsheet data that originated in Excel in order for it to fit on a
portrait page in Word. At the moment the production department are being
burdened with this task. They use the following steps:
- Create a pdf of the spreadsheet table
- Open and rotate in Illustrator
- Paste into Word.
Not everyone in the office has access to Acrobat or Illustrator so we've got
a real bottleneck situation brewing! What I'd love to do is set up a macro
which :
- In Excel the user selects data
- Use the Copy Picture command to put spreadsheet table on the clipboard
- Open Visio (if not already open)
- Create new blank drawing
- Paste the picture from the clipboard
- Use the Shape menu, Rotate Left command
- Use the Copy command to put the rotated picture on the clipboard
- Switch to open Word document
- Paste the picture at insertion point

Is this possible? I've set up some templates in Word before but never used
vba with visio. Any ideas/ guidance would be greatly appreciated.

Thanks
Preeti