Search results for query: *

I managed to resolve this by adding the exchange servers to eachothers connection control under the SMTP virtual server. The mail queues then began to flow as expected. Cheers, RedMoo

Hi, I have just installed a 2nd exchange server 2003 SP2 into my domain and i cannot receive any mail except from other mailboxes that reside on this server. I have no problem mailing to accounts external to this server just receiving. When I look at the queues the outbound queue from the...

Hi Skip, Thanks for your post above it has worked perfectly for me. Thanks Again, Redmoo

Hi PHV, That is my problem I need to embed this connection string into my macro as it was one I recorded. The VBA behind my Macro is as follows. Sub Refresh() ' ' Refresh Macro ' ' Sheets("Accomodation Items").Select Selection.QueryTable.Refresh BackgroundQuery:=False...

Hi Skip, That returned the ODBC settings for each of the Worksheets as follows. Accomodation Items!ODBC;DSN=Cork_Reporter;Description=Cork_Reporter;UID=reporter;;APP=Microsoft Office 2003;WSID=CITRIXBLADE31;DATABASE=pims_reporter...

Hi Skip, I tried to run this Code but I got a Run Time Error of 1004. When I go to debug it highlights the following text: Debug.Print _ qt.Parent.Name & "!" & _ qt.ResultRange.Address & ": " & _ qt.Connection If I hover the pointer over...

Hi, I have multiple worksheets which each call a separate MSQUERY statement. I recorded a Macro and I have placed a refresh button in the spreadsheet to call this macro to automatically refresh the document but it asks me to enter my username and password to the SQL Server connection for every...

Hi, I have multiple worksheets which each call a separate MSQUERY statement. I recorded a Macro and I have placed a refresh button in the spreadsheet to call this macro automatically refresh the document but it asks me to enter my username and password to the SQL Server connection for every...

I created the new address list over 48 hours ago and Outlook is not working in cached mode.

Hi, I have created a new address list in exchange and I have full rights over it. Yet when I go to Outlook (2007) It does not appear in the drop down list of address lists. Any help would be greatly appreciated. Regards, Redmoo

I need help writing a script that will log onto a network share from a workgroup pc which is not a part of the domain. This will be part of a scheduled task so I need it to open the connection so I can push my data onto the network where it will be backed up. Any help aprreciated, Redmoo

Tried a new toner in it but same result. It ended up being an issue with the NIC, Which was causing it to hang up during initialization. Quick replace of the NIC and problem solved. Cheers for the help. RedMoo

Hi, I have a HP 2300dn and it will not print anything for me. All that it's saying is "Cartridge installed" on its LCD. I have restarted it on a number of occasions but it still returns this message. Any help appreciated.

xlbo thank you......you just pointed me in the right direction I had never added it into a module and it appears to have done the trick. I'm not the strongest on the VBA side of things so any hints help. Cheers, Redmoo

I have made the function public and it is located within the workbook that I am currently working on. But still no joy. Redmoo

Hi All, I have been trying to implement one of Chip Pearsons functions SumByColor that is created in VBA Editor. I added the code into the VBA editor and then tried to call the function from Excel, It returns #NAME?. Could anyone point me in the right direction with regards to adding a function...

Unfortunately there is no logic in applying the colours. The colouring is representative and not based on the numbers that will be populating the cells. It is almost like Conditional Formating in reverse really. Thanks for your help guys. I will just have to go a different route.

Hi, I am trying to apply a couple of formulas on a row based on the Cell Colour. So lets say in this row there are green, red and blue cells. I am trying to create 3 formulas, one to add the values in the red, one for the green and one for the blue cells. Any help would be appreciated.

Cheers Sawedoff.......showing the values as interpolated does exactly what im after

Hi, I am doing a line graph in Excel and in the data that I am using there are some blank fields. This appears as breaks in the graph. Is there anyway of editing the graph so that it will show only a continuous line and not take the blank fields into account. Cheers