ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting info from the clipboard (https://www.excelbanter.com/excel-programming/301127-getting-info-clipboard.html)

DredanZyl[_4_]

Getting info from the clipboard
 
Is it possible to query the Clipboard in Excel VBA? I want to check th
clipboard to see if the last item copied is an Excel range. Then I wan
to check the size of that range (how many rows and columns). How can
do this

--
Message posted from http://www.ExcelForum.com


Rob van Gelder[_4_]

Getting info from the clipboard
 
I believe this clipboard information is stored as binary. AFAIK, there isn't
anything in Excel dealing with it.

It's a matter of learning from Excel SDK and applying. There are some
articles out there on BIFF (Excel's file format)

You may get lucky searching the web for "BIFF" and "clipboard"


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"DredanZyl " wrote in message
...
Is it possible to query the Clipboard in Excel VBA? I want to check the
clipboard to see if the last item copied is an Excel range. Then I want
to check the size of that range (how many rows and columns). How can I
do this?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 07:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com