Programming

Pull out lastname
Cell A1 = "John Doe" (without quotes) In a macro, I have the following: name = Range("A1").Value How to I pull out just the last name of the person in the variable name and place it in the variable, lastname? Thanks, Les ... 12 May 2010 21:27

Run a macro upon saving
Probably a simple one - I am trying to set up a macro to run when the user saves the file via the save icon. I have the macro set up to generate an email with the file as an attachment, but would like the macro to run on save. Thanks. ... 12 May 2010 18:07

Call List Macro
I have a master sheet of contacts and daily dated sheets following the master sheet. All sheets are configured alike with: A is status, B is company, C is contact, D is telephone number, E is street address, F is city, G is state, H is zip, I is Source, J is type, K is product, L is last date contacted, M is r... 12 May 2010 17:00

Issue with expired digital certificate ..
Hi, We have protected all our Office add-ins with a digital certificate generated by our systems team. Now the certificate has expired and out IT department created a new certificate with the same name and DN. still my old excl files throw error about the certificate expiry. Is there any way I can use the old... 13 May 2010 20:30

Open workbook without running Workbook_Open Event
I'm using Excel 2007. How do I open a workbook (the workbook is a .xls 97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down the SHIFT key while opening as this worked in previous versions of Excel, but the event still runs (unfortunately, there is an ActiveWorkbook.Close at the end of m... 13 May 2010 11:37

treeview control problems
All, I am trying to get my Excel application to work on a new PC. All of the references have been established, particularly MSCOMCTL.ocx which contains the treeview control. However. when I go to the toolbox and try "Additional Controls..." the treeview control does not show up. I am using Excel 2007. Any t... 12 May 2010 14:45

What kind of workbook function should I used?
I would like to save and close excel file after not active for 15 mins, to define not being active is shown below: 1) not page up / down action 2) not switching any worksheet by clicking it .... When the file is automatically opened based on schedule, I used to read this report, as I sit in front of PC, I will ... 12 May 2010 15:53

Add-in doesn't load properly
If I start Excel up from the Start Menu, everything is fine. My add- ins work with no complaints. If I start Excel by opening a spreadsheet, though, the add-ins don't load until I invoke their menu item, and then I get a macro security message box. Am I doing something wrong, or is this normal behaviour? Phil Hi... 13 May 2010 06:07

macro based on text or number
I want to do an if statement within a macro that will copy and paste to another cell, a field that is text. Anything numerical should be skipped. How do I do this? ... 12 May 2010 14:45

Renaming tabs
I am running monthly financials in FRX and creating worksheets into excel. The starting names are different for each property but the tabs need to have the same names. Is there anyway to write a macro by placement of tab to name the tabs in each separate worksheet over and over again each month? There are 7 ... 12 May 2010 15:53