Search results for query: *

I think the issue is in the name of database, so after the change of the name the SQL "where..." requires changing database name. I see if IT can rename it to the old name. this may speed up the change. I posted old and new location. I am not sure where insert it in your macro?

I managed to make it work by making adjustment in SQL statement. But this is not the fastest way to update I had in mind I have lots of queries. Thanks

Hi guys thank you for your replies but I still have a problem reconnecting. doing it Skip's way I am getting an error: "Select command denies user..." as for VBA not enough knowledge to modify. Old Connection: DSN=Cope dBase;UID=cope;DESCRIPTION=UMGI Cope...

I have manually set them up. Location is external and requires ODBC connection. I added link in User DSN using driver MySQL driver 5.2. The new database set in the same way but IP is different.

Hi I have an external database which I use to create reports in Excel via MS Query. Now location of the server has changed and I need to re-assign all my queries to a new location. Is there a painless way to do it in one go? Thanks Yuri

HI Gavin, Check name ranges, occasionally I came across links are transferred with Names. CTRL+F3 and delete or edit names to current workbook. Yuri

Thanks Andy, I certainly will have some fun. I'll give it a try. Yuri

Hi, I have to change manually excel file names from one month to the next. (i.e. Jul to Aug) Is there a Macro to select folder and change selected word in file name and change it to selected new name. Loop this for all files in a folder. I have no knowledge of VBA, appreciate help. Thanks Yuri

Hi, =INT((TODAY()-2)/7)*7-1 always last Friday. Yuri

Hi, The way you can do it is add another column put the numbers next to your 500 row, (1,2,3...500), then copy (1,2,3...500) to further 500 lines and then sort by new newly created column. Yuri

Hi, Try this in data validation (custom) =AND(A1="SOLD",A2<>"",ISNUMBER(A2)=TRUE,A2>0) Yuri

Hi Brendan, Try to play with =VALUE(LEFT(A1,LEN(A1)-1)) - Left() converts number into text. The Lookup values should be the same format in both places. Yuri

Thank you Much appreciated!

=OR(SUBTOTAL(9,$C$4:C4)<0,SUBTOTAL(9,$D$4:D4)<0,SUBTOTAL(9,$E$4:E4)<0,SUBTOTAL(9,$F$4:F4)<0,SUBTOTAL(9,$G$4:G4)<0,SUBTOTAL(9,$H$4:H4)<0,SUBTOTAL(9,$I$4:I4)<0,SUBTOTAL(9,$J$4:J4)<0,SUBTOTAL(9,$K$4:K4)<0,SUBTOTAL(9,$L$4:L4)<0,SUBTOTAL(9,$M$4:M4)<0,SUBTOTAL(9,$N$4:N4)<0,SUBTOTAL(9,$O$4:O4)<0,SUBTOTA...

I have columns from C to T, CF in Column U. Each column is separate account.

Empty column with CF on the side of data table.

This one is good. My idea was to have a column on the side (not actual column) with CF and test if any of the columns goes negative. that's why I used OR(). Thank you

I think I found the solution: I have to use SUBTOTAL() instead of SUM() in both MonthEnd Rows and CF Formulas - seem to be working. Open for more suggestions. Thanks Yuri

That's correct, I have CF on the right hand side, if balance go <0 highlight cell in red. The issue here is =OR(SUM([highlight #FCE94F]$C$4[/highlight]:C37)<0,SUM($D$4:D37)<0 I have to change =OR(SUM([highlight #FCE94F]$C$39[/highlight]:C68)<0,SUM($D$39:D68)<0,

Bank1 Bank2 Today's Opening 100.00 200.00 Wed 01/01/14 Thu 02/01/14 Fri 03/01/14 Sat 04/01/14 Sun 05/01/14 Mon 06/01/14 Tue 07/01/14 Wed 08/01/14 Thu 09/01/14 Fri 10/01/14 (10.00) Sat 11/01/14 Sun 12/01/14 Mon 13/01/14 Tue 14/01/14...