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...
if the conditional formatting needs to be copied down to a defined range you might think of using the R1C1 format of cell referencing rather than using A1, to chenge this go to Tools options and change the setting in there. For the cell to the left of the current cell this would be...
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...
Hi Skip,
We both have full access to the same network location.
He has manual calc set with reclac on save switched on, if I have the same we still get the same scenario.
Any other thoughts? otherwie we shall create a messy workaround?
Cheers
Matt
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...
Has the macro got a step where a filter is applied and then the visible rows are deleted?
2003 does not work so well with this. Can you post the code?
Cheese
Matt
ColA ColB ColC ColD
a 1 =COUNTIF($A$2:A2,A2) =+A2&C2
b 2 =COUNTIF($A$2:A3,A3) =+A3&C3
c 3 =COUNTIF($A$2:A4,A4) =+A4&C4
d 4 =COUNTIF($A$2:A5,A5) =+A5&C5
e 5 =COUNTIF($A$2:A6,A6) =+A6&C6
f 6 =COUNTIF($A$2:A7,A7) =+A7&C7
g 7 =COUNTIF($A$2:A8,A8) =+A8&C8
h 8 =COUNTIF($A$2:A9,A9) =+A9&C9
a...
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...
Approach from a slightly different angle...
Sort the data in this order...
Date Sort Descending
Account Sort Ascending
District Name Sort Ascending
District ID Sort Ascending
Area ID Sort Ascending
then in cell F2 enter the following...
best option for you
save the macro and word document in a development area as a normal word document.
Save the macro and word document in a suitable network location as a document template.
In word go to [tools]... [templates and add-ins]...[Add]...
This creates a central macro which...
the dates required are in julian format, so by putting the real date into the datevalue function it is then converted into the julian date format required.
Cheers
Matt
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.