| Thread | Last Post | Replies |
|
| Simpler Macro | 17 Apr 2007 20:09 GMT | 7 |
Good Morning, I currently have two separte macros but I'm trying to combine them but it's going to require some different commands. What I need it to do is something like this: start off we are in Summaryworkbook now if there is INV in column
|
| error handling message help | 17 Apr 2007 20:04 GMT | 1 |
I have a macro which enables users to import values into a master log. Each row inserted into the master log has a unique date. Question: I'd like to add some code in which Excel loops through the existing rows in
|
| preventing addIn opening in second instance of Excel? | 17 Apr 2007 19:52 GMT | 3 |
I have an AddIn into which are written a few small details before close (I know this isn't great practice but it saves me having to setup a log file external to the AddIn and the attendant risk that this will be deleted)
|
| Protected project | 17 Apr 2007 19:44 GMT | 2 |
Is there a way to unlock a password-protected VBAProject for a lost password?
|
| Automaton error/Unspecified error | 17 Apr 2007 19:16 GMT | 1 |
I am running a program that takes data from excel files found in a specific folder and uploads certain data to Oracle. About two thirds of the way through I get an automation/unspecified error. Does anyone know possibly why? Checked data type and data in the file the error ...
|
| Date Issue | 17 Apr 2007 18:14 GMT | 1 |
I use this formula to pull specific rows out of a master sheet and sum their totals. In this instance, all rows for the month of January: =SUMPRODUCT(--('Daily Reading Master Log'!B3:B400>=DATEVALUE("01/01")),--('Daily Reading Master
|
| MSXML2.XMLHTTP Works with IE6, IE6 SP 1 but not with IE6 SP 2 - wh | 17 Apr 2007 18:12 GMT | 1 |
i hope someone can give me some much needed insight into this bug. i have been using: Set objHTTP = CreateObject("MSXML2.XMLHTTP") for the longest time and it has never let me down - until recently when i
|
| Putting woirksheet name into a variable | 17 Apr 2007 18:01 GMT | 3 |
I have a form where a new sheet is created in a workbook. Everytime a sheet is created it incraments up (sheet1, sheet2, sheet3, sheet4). I was tring to put the active sheet name into a varable but I do not know the syntax.
|
| Open File - Need an warning to appear if file cannnot be found | 17 Apr 2007 17:56 GMT | 3 |
I was wondering how i would go about adding a warning message that says "File cannot be found" to the following code if the the test.xls file cannot be found? Sub filefile
|
| Selecting the first blank cell in a column | 17 Apr 2007 17:41 GMT | 1 |
I am tring to program in excel and I am having a hard time selecting the first blank cell in a column. There is data throughout and i want the first blank cell to be slected. I have tried using the Ctrl down... Can someone help me out... I know its simple but I am just getting ...
|
| excel formula and vba | 17 Apr 2007 17:28 GMT | 4 |
I have this formula in cell: =SUM(C12:L12)/((COUNTIF(C12:L12,">=0"))*24) I need to be able to "convert" this to vba code. ??
|
| function tweak? | 17 Apr 2007 17:18 GMT | 5 |
I use the following SumProduct formula to search for all values in a specified date range, in this case, for all values in january, then sum those values which fall into that date range: =SUMPRODUCT(--('Daily Reading Master
|
| Hide Cell contents | 17 Apr 2007 16:37 GMT | 1 |
Is there any way to hide / protect the contents of a cell so a user cannot see it at all. I need to enter a file path into a cell (for later use in another macro). We need to hide the path from users so they can't navigate to this path.
|
| Run Time Error 1004: Application-Defined or Object-Defined Error | 17 Apr 2007 16:21 GMT | 6 |
Hello again! Here is my beautiful code revisited, hoping to get a touch of assistance from one of you wonderful Excel VBA experts! I'm getting the error at the "Set oQt" line. Thanks in advance for any help!
|
| FTP a file to UNIX server using Excel Macro | 17 Apr 2007 16:12 GMT | 1 |
i have a requirement where in i have to code a macro in excel which will FTP a file to UNIX server. i am new to working in excel macro's. Could anyone please tell me how do i approach it and if possible possible solution
|