Search results for query: *

Hi I have a back end-front end MS Access database which runs perfectly and very fast on a local server (several PC's linked to a server, all in the same office) However if I try to access same db in another office (we have 10 offices around the country) to do something like a simple query, it...

Hi i have the following records: ROWID,SUPPLIER,VALIDFROM,VALIDTO,VALUE 1, PEPE JEANS, 01OCT09,31DEC09,$1000 2, CK, 11OCT09,31DEC09,$850 3, PEPE JEANS, 10OCT09,31DEC09,$800 4, CK, 12OCT09,31DEC09,$800 5, CK, 20OCT09,31DEC09,$800 6, PEPE JEANS, 01NOV09,31DEC09,$750 So I need to do a search by...

Hi there I have a VBA routine which copies files from my local server to several servers using FileCopy. For some reason the routine seems to "lock" Excel, and if you try to click on the Excel page, it goes blank (although it appears the processing still happening on the background) If you...

Hi there, I hope someone can help I use the following code to copy a whole excel table to a "datarange" , then I loop through it looking for data, etc I use this datarange for Read only, there is no changes needed to the info. DataRange =...

Hi there I need to get each cell value for each selected row in a filtered Excel sheet. for example, after filtering, only rows 35525 and 40125 are shown (match the filter selection) I now need to loop (with VBA) through those 2 shown rows and get the value for range("A35525") and...

Hi there I have two excel sheets open. With VBA code, I search+replace for all rows on the "mainsheet" to look for matching data on "data_sheet" and, if found, data is updated on the "mainsheet". This works well but it is too slow. I do the search+replace with next loops like this: for x=1...

Hi there I have a VBA macro which creates a new excel document (from a "Master Excel doc) and saves it to a set directory. Several people can do this process and I would like to change the "Author" on the properties of the newly created document, just before it is saved, in order to keep a...

Hi I've looked in the forum, but I was unable to find an answer. This is what I am trying to achieve: From a table in Word, instead of opening a Form to select items, I prefer to open a database in Excel so user ... 1. rightclicks on Word (done) 2. selects new Menu Option called "Open Excel...

Hi I've looked in the forum, but I was unable to find an answer. This is what I am trying to achieve: From a table in Word, instead of opening a Form to select items, I prefer to open a database in Excel so user ... 1. rightclicks on Word (done) 2. selects new Menu Option called "Open Excel...

Hi We receive daily .CSV reports from our mainframe. These reports include text fields like this "03/1234". These are PO numbers. The files (which arrive via email with a CSV attachment) are opened automatically by Excel when users double click on the attachments. These fields are...

Hi I have an Excel sheet (1st) which opens another Excel sheet (2nd) and copies certain information from 1st sheet to 2nd sheet. On the 2nd sheet, there is a Combobox. I would like to give that combobox a Value from the 1st sheet. I've tried ExcelObj.Combobox1.value=Range("A1").value but it...

Hi there i have some macros in Word which 1. opens Excel sheet from Word (hidden) 2. Searches through sheet for string 3. if found it returns the values of cells in same row 4. Those values are then used in Word I am currently using a loop to goo through each row. This works well but...it's...

Hi I have used the code from Vroscioli in thread 840925 to open excel from word. Works fine. However i am now trying to continue adding data from another Routine (cmbbox_afterupdate) and there seems there is no reference (I get a "424 Needs an Object" error) How can I give the Excel Objects a...

Hi I have put a number of Templates in ...word\startup folder so they are opened and can be run when Word starts. They seem to run ok HOWEVER when I try to access them via VBA window I get the message "the project cannot be shown/Viewed" I am only able to open normal.dot template file. Also...

Hi I am creating a number of .DOT documents with toolbars+macros and installing them on the Word Start Up folder. Although the documents are viewable from within th VBA project View, somehow I cannot open them and change anything on them. I get a "Project cannot be displayed" message. Any...

Hi I use Sub Worksheet_SelectionChange(ByVal Target As Range) currentcolumn = ActiveCell.Column currentrow = ActiveCell.Row ... to detect the current cell position. However this Sub runs when it jumps to the new Cell. I need to know the position for the Cell the cursor just left... For...

Hi i have an excel sheet which opens at Start Up of Excel. it is located in the START directory. However this file is constantly being updated with new functions, etc Currently we copy the new sheet manually in each PC. I would like to, when opening Excel, BEFORE the sheet is opened by...

Hi there I need to move through each record on a subform sheet. I don't want to use Set dbs = CurrentDb() Set rst = dbs.OpenRecordset(sqlline) Instead what I want is for the cursor to go focus on field1 of record 1, then field1 of record 2, field1 of record 3, etc I need to physically set...

Hi there I need to set a value to a variable when Word opens. All the code is on the normal.dot file I want the variable to be TRUE all the time (by default seems to be FALSE), until people run Forms which are accesible from buttons...at this stage I can then change the variable to FALSE or...

Hi there When I open an excel sheet, automatically Personal.xls opens first, then (on aspearate instance of Excel) the sheet I am actually trying to open, shows up. So I end up with two Excels open at the same time, the personal.xls and the actual sheet I want. i am currently running some...