objects

Hello, I have a very strange problem that has come up in my excel file. When it was opened the other day, it was completely different! I am using Excel 2013/Windows 8, Btw. All the shapes that I have inserted to use to assign macros are gone. The macros within the modules are still in <acronym...

Is it possible to secure an embedded object within a cell in excel so that it doesn't move when you change margins or add rows/columns?

Hello and thank you for your expertise. I am trying to activate Chart 39 on sheet1. Sheets("Sheet1").ChartObjects(39).Activate When I run my macro, this line errors out and I get an Application or Object defined error. I don't believe the problem is with the Sheet. If I change the...

I am still on my search to make an Excel spreadsheet Pop! I love shapes because I have a lot more control over them as well as Images, unlike a cell I can make them look the way I want them. The problem is that I want the Shape or Image to fit the cell so it does not look like a Shape or Image...

I have a Data sheet filled with resources. Each resource has a name, location, and title. I made a class called Resource [see below]. I'm trying to iterate through the Data sheet and store all the resource information into objects, which are then stored in an array. So there's a Name column...

I have in the past been able to save workbooks with personal embedded objects (e.g., logos). In Excel 2010, when I attempt to save a workbook with an embedded object, I get an error message that says "Errors were detected while saving...". When I research this error one of the reasons listed...

I posted a previous question regarding writing of a Macro for copying and pasting the last line of data in a table on one sheet to the first empty cell of a table on another sheet, however within a weeks time haven't had much luck with responses. So I purchased the Mr. Excel Library book for VBA...

Hi all, I'm sure this is relatively simple but I'm having a few issues wrapping my head around it. Basically I have a sub which I want to control several labels - the labels all share the same naming convention, for the most part it's just a number that changes. Basically I want my sub to...

Hello, Could someone provide me some direction in developing a macro for copying elements from one worksheet to multiple other worksheets. A little description of what I would like to accomplish: I have 10 columns of data in sheet 1 of a workbook. What I would like to do is copy columns...

I have several Worksheets in a Workbook and each of them contains embedded Word objects. I am pulling data to the Worksheets from an Access table and have no problem loading up actual Excel cells. However, I want to be able to copy from the Access table directly into one of the Word objects...

Hi... I created a VB project using Excel 2007. Except for some errors in my code, the project launches correctly. I copied the spreadsheet to my system running Excel 2010. When the code first tries to show UserForm1, I get "Could not load an oblject because it is not available on this...

Hi all, I'm looking for a simple vba code that will put all object names from a sheet into a list in column A. For example, the list would look like: ComboBox1 ComboBox2 ComboBox3 SpinButton1 SpinButton2 ... I've been searching for a while with no luck. Anyone have any ideas? Thanks!

I'm just starting to learn how to create custom classes and objects and I don't fully understand it all yet. I want to create multiple objects from my custom class. But, I don't know how many I will need (it will be different each time I run the program). Because of this, I can't create object...

Hi I have two functiions, Cheque() whic simple check the reorcd in the table , whic reports need to sent email, The 2nd function GenerateEmail() which giving me the error. "Method or Data Member not found. I though the reference library missing but I already added the following library...

Greetings all ... I constructed a db in Access 2003, with many jpegs as well as AVI files inserted into the table fields as OLE objects. Most of the picture files (BMPs especially) as well as all the AVI files actually showed properly in a form in Access 2003. When I open the same db in 2007 or...

I would like to store user input as an array. I'm using Excel 07 on a PC running WinVista. I'm making an application with UserForms. I want the user to be able to select a day on the calendar (works fine, no problem there), and then in a text box they can enter an item (I should be ok this...

Is there a way to set the property of multiple UserForm objects at once. I'm thinking an array but not to sure how to set it up. Below is an example of the code I think could be shortened up using an array or something: btnTest.Visible = False lblTest.Visible = False txtTest.Visible =...

I'm trying to utilize Excel (2003) to build a flow chart so that the user will answer some quaestions and the flow chart will change the objects color to display the flow chart path. I can send a copy of the excel file if it will help to clarify my question. I'm hoping I can get some help on this.

Hey peoples. All my googling hasn't helped figure this out: I'm comparing 2 excel books, and placing the differences in a third. Code starts off with: Dim xlapp As Object, oldxp As WorkBook, newxp As WorkBook, resultswb As WorkBook, _ xlsheet1 As Worksheet, xlsheet2 As Worksheet, resultsws...

In Excel 2003, I could record a macro while creating objects and all worked well. Unfortunately, 2007 is a different animal! When I record a macro, everything is recorded EXCEPT the act of creating objects. There must be a setting somewhere in 2007 that causes the action of creating objects...