Programming

Change Data Connection Definitions from local to sharepoint
Hi, I am using Excel 2007 and have created a query tool/workbook that contains a linked table worksheet from sharepoint as the source data (its a custom view/subset of the records data). This worksheet is refreshed from the sharepoint source periodically. I created this tool/workbook on my desktop, and now ... 25 Feb 2010 23:50

Enter data on one sheet and copy to others
I'm not sure if this can be done or not...i currently have a workbook with 3 sheets, sheet one is the master sheet and i have some vba coding that if column a is not blank it copies over to sheet 2, this is working well but now i have added sheet 3 and need the master to copy to it, it's a little more complicat... 25 Feb 2010 21:38

Type checking from VBA to C++?
I'm new to VB/VBA and calling functions in external DLLs from VB/VBA. If I declare a variable in VBA, assign a value and then call a C++ function in a DLL, is any type checking down between VBA and the C++ function? So if I declare a Long identifier in VBA and then call a function that expects an enum type in C++... 25 Feb 2010 17:08

list box controls - text property
I have a userform list box - the data it is using to populate the list box contains part numbers - some of which are text and some of which are numbers. How do I set it so no matter what type of part number is selected, it will show as text? Thanks in advance. ... 25 Feb 2010 17:08

Validate to quarter units
Is there a way to have the cells validate to quarter units? Specifically, I only want users to be able to enter .00; .25; .50; or .75 numbers. -- Thanks Shawn ... 25 Feb 2010 21:38

prevent user from deleting a tab prevent running macro from menu
how can one prevent a user from 1. deleting a specific tab in a workbook? 2. prevent a user from running a macro from the tools menu (where user can only run a macro from a command button)? thanks! ... 25 Feb 2010 14:51

.Formula vs .FormulaR1C1 in 2007
Here's the problem. I have VBA inputting this formula in the same column (col H) of cells: ..Formula = "=if(trim(rc4)=""MS"",""MNGTS"",if(trim(rc4)=""MN"",""MAINS"",""""))" For a single user on Excel 2007 it appears in the cell as: =if(Trim(RC4)="MS","MNGTS",if(trim(RC4)="MN","MAINS","")) When I change... 25 Feb 2010 14:51

Move data from Doc1 to Doc2, end with 2nd doc open
Here's a quick synopsis of my macro - Macro is run from Doc1, which opens up Doc2, then returns to Doc1 & does a series of coping & pasting into Doc2. When the macro is done Doc2 should remain open for the user so they can see the message box, but both documents are automatically minimized when the macro is ... 25 Feb 2010 13:43

Rounding 2 decimal Places
This seems easy enough but I cannot figure out the code and I cannot find an example. I need to round cells so there is 2 decimal places. I just need standard rounding so there is no more than 2 decimal places. This is what I did, but i cannot get it working. Do While I <= 50 round(cells(I,3... 25 Feb 2010 10:18

Autofill
Hi, I am looking for a formula or code to fill in a range of cells with a figure on the 1st of every month, so when 1st March arrives I need cell C1 to enter £100 and when 1st April arrives I need cell D2 to £100 and so on for 12 months. Can anyone help me with this query. Many thanks Mark ... 25 Feb 2010 10:18