PC Review


Reply
Thread Tools Rate Thread

Count or Detect Graphic Objects in an Excel Spreadsheet Opened in Access?

 
 
plh
Guest
Posts: n/a
 
      26th Apr 2011
Hi Gurus,
I have an application that opens Excel Spreadsheets in Access and
extracts information to be placed into tables. One thing I need to do
is detect if the spreadsheet contains any drawing objects such as
lines, boxes, bitmaps, etc.
I tried

Dim g As Integer
Dim dG As Graphic
Dim xlWS As Excel.Worksheet

Set xlWS = xlIW.Worksheets(strWSheet)

g = 0
For Each dG In xlWS
g = g + 1
Next dG

But it is telling me that the object does not support that property or
method. Any suggestions? I don't need any elaborate information, just
if they exist or not.
Thank You!
-plh
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Detect if spreadsheet is opened off the web guest Microsoft Excel Programming 3 23rd Aug 2008 10:46 PM
how do i count everytime a spreadsheet is opened =?Utf-8?B?bmlwcGVy?= Microsoft Excel Misc 1 15th Mar 2007 05:23 PM
Excel 2007 - Row 1 graphic objects get included when only copy row =?Utf-8?B?RW1lcnlO?= Microsoft Excel Crashes 0 25th Nov 2006 02:00 PM
Excel stretches graphic objects horizontally when printing Bazip Zeehok Microsoft Excel Discussion 0 4th May 2005 10:11 AM
Is it possible to count how many times a spreadsheet is opened ceepee Microsoft Excel Misc 2 2nd Apr 2004 02:00 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:13 AM.