Question about Microsoft Office Standard for PC

2 Answers

Visual Basic code to paste all items from Office Clipboard into Excel spreadsheet

The Microsoft Office Clipboard, as opposed to the regular system Clipboard, has the ability to store up to 24 separate items at a time. When turned on, the Office Clipboard is a vertical panel displaying a representation of each of the items contained on it. It has two buttons: One to paste all of its contents at once; the other, to clear all of its contents. I am writing a Visual Basic macro program for an Excel Spreadsheet and I am searching for a command, function, or routine which will paste all of the Office Clipboard items into my spreadsheet at once. When I let Excel automatically record the macro for me and I press the "Paste All" button in the Office Clipboard panel, I can't get the answer I am looking for; when I stop the macro recording process and check the Visual Basic editor, all I see is the "paste" command issued there multiple times, once for each Office Clipboard item. There is no single generic command, function, or routine visible. There must be some hidden code behind the "Paste All" button press event. Can you be of assistance to me? My email address is prince_howie_knighted@yahoo.ca Thanks.

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 175 Answers

Anypasskey EXCEL Password Recovery is Professional utility works on Password recovery, it can recover all versions of EXCEL files quickly and efficiently, and its previous versions and easily get EXCEL password reset. It deserves trying.

Posted on Nov 30, 2011

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 167 Answers

This may sound like a **** solution, but sometimes SENDKEYS can come in handy for situations like this instead of messing with with more advanced solutions. Also you can try to use win32API calls

Posted on Jul 20, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do i get into a spreadsheet when i get a message saying it can't be opened


Hi, what is the exact error code you receive? If you can provide the exact error code or message, will narrow down troubleshoot. To get around the problem, try starting Excel in safe mode. The command is "C:\Program Files\Microsoft Office\Office14\EXCEL.EXE /s".

To run the command:

1. Copy the above command without inverted commas.
2. Click Start and paste by pressing "Ctrl + V" and press the Enter key.

See if this open Excel. Thereafter, exit Excel and try opening Excel again in normal mode without the "/s" switch at the end.

If still having issue, suspect some of the system files may be corrupted. Run Office setup and hit Repair when prompted.

Regards,
Maha

Apr 29, 2014 | Microsoft Excel 2010

Tip

Script to extract URLs in Excel Spreadsheets


The following script could be used to extract the actual URLs from the text link in an Excel spreadsheet. The script writes each URL in the cell next to the text link:

Sub main()
Dim h As Hyperlink

For Each h In ActiveSheet.Hyperlinks
h.Range.Offset(, 1) = h.Address
Next
End Sub

Here is how to use the script:
1. On the "Tools" menu, point to "Macro", and then click "Visual Basic Editor". This will open the Visual Basic Editor in another window.
2. On the extreme left, you will find the "Project - VBAProject". Double-click the icon named "Sheet1 (Sheet1)", "Sheet2 (Sheet2)", or whatever the name of your worksheet. This will open a blank window. Copy & paste the script into this window.
3. Press F5, then click on "Run".
4. Go back to your Excel window. You will now find the URLs listed in the next cell to the original one with the hyperlink.

on Dec 01, 2009 | Microsoft Excel for PC

1 Answer

I just bought a new desktop that has office starter on it. I have office 2007 that i want to load but it is an "update" version. Will this recognize office starter as a registered microsoft...


Microsoft Office Starter is a new product launched by Microsoft that comes only in a version that is pre-installed on certain computers. There are no genuine licensed CD, DVD or download versions of this product. It should therefore actually be Microsoft Office Starter 2010 that you have pre-installed on your computer.

So the simple answer to your question is no. An Office 2007 Update will have no effect on an Office 2010 application. Also, an Office 2007 Upgrade application will probably not install anything at all on your computer unless of course you have genuine licensed versions of Office 2000 or Office 2003 already installed on it that are capable of being upgraded.

Microsoft Office Starter 2010 has a perpetual license (never expires), so it is not immediately obvious why you would feel the need to upgrade it, unless there is a particular Microsoft Office function that you need which is not included in Starter.

Office Starter replaces the various Trial versions of Office that used to come pre-installed on some computers. Office Starter is a reduced functionality version of Office including basic versions of Word and Excel. Neither PowerPoint nor Outlook are available in the Starter format. Word and Excel Starter can be used as they are for an indefinite period of time or can be unlocked to the functionality of various full versions of Office by buying and downloading an activation code from Microsoft. Starter can be used to open any Microsoft Word or Excel documents or spreadsheets and can also be used to perform basic editing of such documents and spreadsheets (a number of sophisticated tools and functions do not feature in Starter and are available only in the full versions of Microsoft Office).

If you do not want or cannot afford to upgrade Starter to a full-function version of Microsoft Office 2010, then a free full-function Office suite application called Open Office is available that is of similar quality to Microsoft Office and can also be used to open edit and manage Microsoft Office documents spreadsheets and databases. Open Office is available to download install and use totally free of charge (like other Open Source applications) from:

www.openoffice.org

Oct 06, 2011 | Microsoft Office Professional 2007 Full...

2 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

1 Answer

Not Enough Memory to run Microsoft Office Excel. Please close other Applications and try again..


Excel running on a 32 bit PC and using a 32 bit operating system can only address 2 Gb of RAM. If your machine has a 64 bit processor (these were being shipped over 5 years ago) it will be possible to install a 64 bit operating system such as Windows XP 64 bit or Windows 7 64 bit. It has been claimed that an Excel 2010 spreadsheet, running on a 64 bit machine and using Windows 7 64 bit, was able to load and use a database with 100 million records.

If you are unable to do this then I suggest that you examine what your machine is running at the same time as your spreadsheet and if any part of the spreadsheet can be off-loaded. By the latter I mean can any of it transferred to another Excel file?

Are you using any links on your spreadsheet, if so can the links be converted into data, e.g. a link to a lookuptable could be converted to data (copy, paste-special, value) and this remove a significant amount of processing load.

Oct 18, 2010 | Microsoft Excel for PC

2 Answers

Whenever I open a new spreadsheet now it automatically opens up a spreadsheet calles PERSONAL. Why is that and how can I get rid of it... I think it started after a did a macro but I am not sure. Thanks,...


You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls 1. Open Excel, 2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor) 3. Click Tools-References to bring up the references dialog 4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located. 5. Click Cancel to close the dialog.

Sep 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

How to connect my database to my project?


use Excel library at following location.

D:\Program Files\Microsoft Office\Office12\EXCEL.EXE
Microsoft Excel 12.0 Object Library

Jan 05, 2009 | Microsoft Office Standard for PC

1 Answer

VBA not working in all Office products


There is setting for VBA in office 2007.
Go to Excel options-->Trust center--> trust center setting and configure the required settings

Jan 04, 2009 | Microsoft Office Standard for PC

1 Answer

Squished Rows in Office 2003


Follow the next steps:
1.- Choose in the menu File.
2.- After Choose the option Sent to.
3.- After Choose the option recipient (attach data).

Nov 20, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Microsoft Office Clipboard operations VBA coding for "paste all" and "clear all"


very interesting problem, i can't seem to find any code that covers this.

Here's a quick (dirty) solution that should work (however if users of your macro are using different resolutions you will want to check for that and modify accordingly)

Basically you tell the mouse the exact position on the screen to move, then tell it to click. A bunch of example on how to do this are here:
http://www.vb-helper.com/index_tips_and_tricks.html#mouse

Jul 22, 2008 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

319 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...