Search results for query: *

anyone know? If you have a function as follows: =If(A1=B1,CountA(C1:C1000000),Sum(D1:D1000000)) when excel performs a recalc does Excel recalc both the true and the false portions of the statement or is it the same as the creating your own User Definied Function and only recalcs the True or...

Hey, I have created an outlook custom form and distributed it to users, each time the email is opened the message box asking the user to enable/disable macros pops up. I have changed my Macro security settings from Medium to Low but this always switches back to medium as soon as i try opening...

Hi All, Required: VBA to create instance of Internet Explorer (already done works) VBA to open URL, in this case Facebook users profile (ok done, works) Click like button or Add friend button in facebook? (not found solution yet) Cheers M

Hi All, The following line doesn't seen to work Sub mdl_GetData() Application.Run ("'my workbook.xls'.'my sheet'!cmdBtn_Click") end sub Several things causing issues here: 1 there are spaces in the workbook name 2 there are spaces in the sheet name 3 the code I need to run is held within a...

Please help, I am opening Excel from Access and need to resave the file with another name. Problem is not seeming to work at the moment. Please advise... Pabs Public Sub mdl_OpenSS(myDir As String, myFile As String, myProcessID As Integer) Dim myCurDir As String On Error GoTo myError...

hello, Getpivotdata (GPD) is causing me soem issues. On my pc GPD function is linked between two files. When close the file containing the pivot and save the file containing the GPD function the result is retained. HOWEVER! on a colleagues pc when the above is actioned to the letter, the...

Can anyone help me out. I currently have a query against 2 tables of data taking about 30mins to query. Not efficient I can hear you say, not able to do anything about it unfortunately. I need to extract one field from one record in a recordset of 33million records. Attempts so far include...

Hi All, Im fairly new to Sybase but reasonably familiar with SQL and competent with Access etc. My problem is this, I have an sybase warehouse and an access client end database. my code is... Dim myCnn As ADODB.Connection Dim myRST As ADODB.Recordset mySQL = "SELECT * " mySQL = mySQL &...

Hi All, Im fairly new to Sybase but reasonably familiar with SQL and competent with Access etc. My problem is this, I have an sybase warehouse and an access client end database. my code is... Dim myCnn As ADODB.Connection Dim myRST As ADODB.Recordset mySQL = "SELECT * " mySQL = mySQL &...

Hi, I have a module that has been created by a user no longer with us, thank God. A user has a menu item that executes a procedure. The menu item works fine. The Procuedure is located in the users personal.xls workbook. Now, if I go to tools..macro...Macro's then I retrieve alist of the...

MASTERMIND CHALLENGE... Your starter for 10... Platform being used, Win 2000Pro, XL2K, IE6. I have a hyperlink in a webpage that opens excel spreadsheet that opens in the IE6 embedded excel envionment. NOTE 1: It is possible to change this setting so that the spreadsheet opens in Excel...

Hi all, Using Excel 2K & IE v6, I have built a workbook that works beautifully in native excel. However when I run the process via the web using my IE browser, it opens an embedded version of excel in IE and execute almost all the code apart from the last few lines. Here is the code that is...

In case you have seen this elsewhere, I accidently posted it on the Access VBA section, doh! I am receiving an error message that I am not quite sure why. In a constants module I have my connection string to an ADO-SQL Server 7 table, I have changed some details to protect the innocent...

I am receiving an error message that I am not quite sure why. In a constants module I have my connection string to an ADO-SQL Server 7 table, I have changed some details to protect the innocent.. please help. Public Const myCostsConn As String = "Provider=SQLOLEDB;Initial Catalog=dbase;Data...

If I call a subroutine and the subroutine fails using the internal error trapping, can I pass back to the parent sub an error message or such that can be used later? sub mdl_parent() dim myMsg as string Call mdl_validate1 myMsg = myMsg & 'result from validation 1 error Call mdl_Validate2...

Previously posted in Office Forum but to no avail, maybe here? I have a VBA Form in Excel 2000. The form has a series of Text boxes and combo boxes. When execute the form and press tab to go between each object on the form, then it works fine. A Colleague uses the same for, but for some unknown...

Hello Ladies and Gentlemen, I have my spreadsheet with lots of lovely data being pulled into it from my sexy SQL databases using ODBC connex. I move the spreadsheet to a friends pc who does not have the same odbc connections as I, funnily enough the query falls over. What I need is a piece...

I need Access VBA to evaluate whether a table is open. Your assistance is gratefully appreciated. Cheers, Matthew The only bad question is the question you dont ask!

Access 2000. The help file explains how I can use the worksheet function Rept to repeat a specified string a number of times. however it is refered to as a worksheet function not a query function. I try use it in the formula Field1: rept("0",10-Len([table]![field]) but when I run the query I...

I have a VBA Form in Excel 2000. The form has a series of Text boxes and combo boxes. When execute the form and press tab to go between each object on the form, then it works fine. A Colleague uses the same for, but for some unknown reason when she presses the tab button instead of changing the...