Search results for query: *

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, 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 All, I was wondering if someone shows me in the right direction for easier checking multiple columns in one formula if the balance goes below zero. I used so far : '=OR(SUM($C$69:C69)<0,SUM($D$69:D69)<0,SUM($E$69:E69)<0,SUM($F$69:F69)<0... Is there another simpler way? Thanks Yuri

Hi all, I have external dBase which I use to get reports to excel via Ms Query. I updated to Excel 2010 and now I have all my dbase fields like Names and addresses are showing exactly like in the source (long digit line). Data was converting automatically to text in 2007. Anyone come across...

Hi Everyone, I have spreadsheet link via Ms Query to external database. I can update reports manually or on openning by "Refresh All" but users need it first thing and some not have the link to database. My Question: Is it possible to update data without openning a file at say midnight. My VBA...

Hi all, I am using this code to switch to Manual Calculation and back when Open workbook. Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Calculation = xlCalculationAutomatic End Sub The...

Hi Following the thread68-1637794 I was trying to Enter Formula =TEXT(A1,"YYYY-MM-DD") in parameter's window. But for some reason as soon as I enter formula update does not work. If I enter the same formula in cell and reference to that cell it works fine. I want to know why it's not...

Hi Guys, I have Query in Ms Access 2003 which has parameters set up for Exchange Rates to convert Currency amounts to GBP. I anayse it in Excel 2007 via Ms Query and have a bit of a problem. Query run fine in Access, when I link to Excel it comes with Error: "Too few parameter. Expected 2"...

I am using Excel 2007 and I don't seem to have a box in "External Data Properties" called "Fill Down Formulas In Columns Adjacent To Data" and my Query Tables Does Not Fill Down Formulas When Refreshed. Does anybody know how to fix this? Thanks Yuri

Hi Everyone! I have workbook NR0000529.xlsm. I need to create a lot more copies of this file with the next number: NR0000530.xlsm,NR0000531.xlsm... How Could this be done with the macro. Thanks in advance, Yuri

Hi Guys, I use INDIRECT.EXT which works fine for closed files on network but when I make a reference to a SharePoint saved file it only updates values if the file is open. Any way to fix this as I have lots of files there? Thanks Yuri

Hi Guys! Could you please help me to write a simple code in VBA [word 2007] to replace text between quatation marks? Example: "Matolich Mikhaylovich"<rmatolich.UTG@naftogaz.net>; "Nguyen Bich"<bin@forcetechnology.ca>; and so on Thanks Yuri

Hi Everyone, I have a text which I want to break with the formula: Totsa Total Oil Trading SA, Geneva, Switzerland =LEFT($C40,FIND(",",$C40)-1) - Breaks the first bit. I know about Text to column thing, but I was wondering if you can search for the 2nd comma in a string using FIND? Thanks Yuri

Hi Everyone, When I open document which contains external links in Excel 2007 links are updated automatically and formulas show error until I open source documents. Edit Links: Starup Prompt set to: Don't display the alert and don't update automatic links. Excel Options; Advanced: Ticked...

I Have a List of Items, I set up Data Validation with DropDown List and when I protect worksheet it allows to select from the list but if I lock cells it does not. I don't want to allow people to use copy/paste anything from other places but allow validation selection. Is there any way to do so...

Hi Everyone, I have my "Regional and Language Options, Administrative Tab, Current Language for non-Unicode programs": set to Russian (Russia). All other language settings are English (UK). Now I have a problem displaying [£] sterling sign and sometimes [€] in some programs like Sage or...

Hi Guys, Does Excel calculate dates before 1900? Or how to get around it? Yuri

Hi, I am trying combine two macros together it works until '*? point and breaks. Since I don't know VBA I am struggling to fix it. Any one can help? I need this sheet select Q1 and copy it to A1. Private Sub CommandButton1_Click() Sheets("001").Copy Before:=Sheets(1) Sheets(1).Name =...

Hi Guys, I need help on creating simple macro which will copy a worksheet named "001" with the next sequential number "002" and then "002" to "003" and so on. Thanks Yuri

Hi, Some of my pictures are not showing in preview in "Windows picture and fax viewer". I can't open/edit/delete them too. Can't open with other programs either. Anyone knows what might cause this? Thank in advance Yuri