Programming

Run Code in Another Workbook
Looking for automation code to have in a "Template" Workbook that will run code in an Excel File received from Management. This code would make a DBF from the Excel File received from Management. TIA - Bob ... 12 Nov 2009 11:45

2003 works, 2007 doesn't: "Method 'Select' of object 'Shape'Fail
See my response to your earlier post. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ MikeZz wrote: Hi, I have a script that draws about 800 lines on a worksheet from various cells to others. I got the basic routine of the internet and it works perfect in ... 7 Nov 2009 17:24

Copy Data from Sheet 1 to Empty Cell in Sheet 2
I'm getting a little frustrated with this simple problem, but don't have a lot of time to spend reading massive Excel books to figure it out. I hope someone can help me! Here's the goal: To take data from a cell in Sheet1, paste it into a cell in Sheet2. If the designated cell already contains data, then paste ... 4 Nov 2009 14:13

Upload Excel Workbook On SharePoint
Hi, I want a VBA code which can upload a excel workbook on share point. Please help Regards Heera Chavan ... 3 Nov 2009 06:01

code problem not working HELP
I am still learning this code stuff so any and all help will be appreciated with some detail on the code problem I am having. There are 2 problems: 1- I am trying to create a userform where only the form shows when I open the application. The code I have below opens the application and then opens the form but ... 2 Nov 2009 20:12

Item Count vs Item Cost
I would like to put the cost of an item in a cell and have the sum of the costs in a cell to the right but at the top of the column I would like to have a total item count for all the items in that column would look something like this, with Col A items worth $15.00, Col B $10.00 and so on. A B ... 1 Nov 2009 09:59

Sorting Data
I got data in column A and B like see below. As you can see below I got file paths listed in both columns. A B……col C:\David Terry C:\Dean Smith (MC) - 23 C:\John Owen C:\Michael Ja - 778 C:\Michael Ja C:\Daivd Terry (ds) C:\Ali Smith C:\John Owen - x23 ... 1 Nov 2009 05:40

How to re-enable events after a VB error in Excel?
I have a VB application in Excel (in Office 2007). If an error occurs, and the error is caught and err.clear executes, then all is fine. If it is not caught, or if I stop the function at this point (with the Reset button), events no longer trigger event callbacks! I added a global function that does: App... 18 Nov 2009 10:04

Cannot seem to Cancel EXCEL App Right Click Event using C#
"Nick Biggs" wrote: And here is the fixed code... Question is this... should the Excel10EventHelper class that is inheriting from IExcelAppEvents10 also be inheriting the interfaces [DispId] attributes or not ? Nick using System; using System.Runtime.InteropServices; using Excel=... 28 Oct 2009 05:12

Can I stop the change event being triggered?
On my user form, I want Control1 to effect the value of Control2, but when it does, I don't want the change event for Control2 to be triggered. Enable events doesn't work Can I temporarily switch off the change event, then change the control then switch it back on? thanks M ... 27 Oct 2009 11:25