Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Salut39

    Excel 2010 Re-assign MsQuery Connecton to Database

    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?
  2. Salut39

    Excel 2010 Re-assign MsQuery Connecton to Database

    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
  3. Salut39

    Excel 2010 Re-assign MsQuery Connecton to Database

    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...
  4. Salut39

    Excel 2010 Re-assign MsQuery Connecton to Database

    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.
  5. Salut39

    Excel 2010 Re-assign MsQuery Connecton to Database

    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
  6. Salut39

    Data=>EditLinks=>ChangeSource only changes some links

    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
  7. Salut39

    VBA Modify Excel File Names in the Folder.

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

    VBA Modify Excel File Names in the Folder.

    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
  9. Salut39

    Excel to work out date for the most recent Friday

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

    Excel - how to insert multiple rows at one time!

    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
  11. Salut39

    Format dependent on another cell

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

    Excel vlookup

    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
  13. Salut39

    Excel 2010 Test Multiple Columns Balance

    Thank you Much appreciated!
  14. Salut39

    Excel 2010 Test Multiple Columns Balance

    =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...
  15. Salut39

    Excel 2010 Test Multiple Columns Balance

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

    Excel 2010 Test Multiple Columns Balance

    Empty column with CF on the side of data table.
  17. Salut39

    Excel 2010 Test Multiple Columns Balance

    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
  18. Salut39

    Excel 2010 Test Multiple Columns Balance

    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
  19. Salut39

    Excel 2010 Test Multiple Columns Balance

    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,
  20. Salut39

    Excel 2010 Test Multiple Columns Balance

    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...

Part and Inventory Search

Back
Top