Search results for query: *

I want to use the indirect function to obtain data from another workbook on the network. workbook on my pc = local.xls workbook on server = P:\test\server.xls (P: is a network share with all necessary permissions) server.xls has 3 worksheets named QLD NSW VIC cell A1 in QLD = 5 cell A1 in NSW =...

I have some code that I have been running everyday for over a year. Yesterday it started erroring. (Nothing new installed, nothing has changed in our environment) the only thing I can see different is windows update has loaded some SP2 hotfixes (I do not have SP2 installed). I have not tried to...

Hi, From excel, I need to open outlook (2002), and copy all emails from the inbox for the previous month, into excel. If I do this manually, it automatically pastes the header only information into excel, (1 row per email) which is exactly what I want. I just need to know how to do it in vba...

I need to automatically color a point on a bar chart if the source data value is <60. I cannot find how to get the point.value I can get the point.datalabel.text but then cannot match it to a value. something like: if dp.value <60 then dp.interior.colorindex = 3 end if Please help.

Hi All, Can someone please explain why, when using an array formula, if I try and reference an entire column it fails with a #NUM error, if I use a range it works ok: Example: this is entered on one line using ctrl+shift+enter &amp; errors =SUM(IF((All!B:B='LA...

Using the code directly from vba help in excel but changing true to false For Each sh In Sheets sh.Visible = False Next sh causes runtime error 1004 I am assuming that this is because you cannot set all sheets to hidden (please someone confirm if this is the case) What I want to do is open a...

Hi guru's. A challenge !!!!!!!! I want to be able to retrieve all computernames and current logged on usernames for all the pc's on our network (approx 30 pc's all running tcpip) and return the info into an excel worksheet. I have no idea how difficult this is or where to start, so if you think...

I want to add the code 'module2.selectsheet' to a sheet called &quot;Index&quot; On workbook open some code runs to see if the sheet &quot;Index&quot; exists, if not it creates it. If it gets created I need to add module2.selectsheet to the Private Sub Worksheet_SelectionChange(ByVal Target As...

Hi, I need to do a countif using 2 sets of criteria. Column A has dates, Column B has either &quot;In&quot; or &quot;Out&quot; I want to do a countif that will count the number of entries for a date that I specify and that has &quot;In&quot; in column B. I have tried some variations...

Hopefully this is a quick and easy question. Using conditional formatting, how do you use wildcards. ie: if i want to apply a format if cell A1 contains &quot;pen&quot; i can use =$A1=&quot;pen&quot; which works if the cell content is &quot;pen&quot; but wont work if the content is...

Hi All, does anyone know if there is a way to change the font colour for different files in windows explorer view. ie if you go to MyDocuments and have 15 files in there, I would want to be able to right click on a file and use properties (or something similar) to change the font colour to red...

Hi Guys, I am probably in 5000 feet over my head here but.... I need to pull data from an email tracking program using SNMP. I have no idea where to start, how to connect into the data source or pull the necessary fields back. Can anyone give me a steer in the right direction or point me to any...

I am using a vlookup in excel2002. It works fine, but when it doesnt match the criteria you get #N/A, is there any way to suppress this or make it 0 (Zero). Thanks

Hey Gurus, This is not a vba question, just an excel issue. This has just started happening (for no apparent reason). If I open excel (a new or exisitng document) and click any cell and then try and autofill it down (or up or sideways) it immediately crashes excel. It doesnt matter if there is...

Hi, I have a multicolumn listbox on userform1 that gets populated from the userform activate event. The list has 3 columns (Col0,Col1,Col2)ie: Col0 Col1 Col2 Item Cost Qty Eggs $1.99 Bacon $4.50 Col2 (Qty) is blank. If a user selects an item I want to change the entry in...

Hi, I need to get number of items received into a specified inbox yesterday (it will always be for the previous day) in outlook 2002, into excel. ie: if i received 20 emails into specified inbox it needs to return the number 20 so that i can use that in my sheet for further calculations. I was...

Hi, I am being spammed on my static ip with netsend messages. Can anyone advise how I can block net send. Thanks

I am trying to do a countif that will look for an entry in column D on multiple sheets and return the count value. The formula: =COUNTIF(Sheet1:Sheet56!D:D,A1) but i get a #VALUE! error if I just look at one sheet ie: =COUNTIF(Sheet1!D:D,A1) it works fine. Anyone know how to get it to look at...