First  |  Prev |  Next  |  Last
Pages: 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232
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. 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
First  |  Prev |  Next  |  Last
Pages: 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232