Search results for query: *

Hi folks I have had a search on the site but I couldn't see anything appropriate. I have also searched the web and the best option is to run a macro to convert numbered bullets to text before a merge (simply "ActiveDocument.ConvertNumbersToText" - I haven't tried this yet as the office I work...

Hi all We have a spreadsheet provided to us from another company. The VBAProject is protected and I do not know the password. On worksheet "Main" there is a shape ("Rectangle 2") which has a macro assigned ("ShowInputForm"). We are trying to automate our process with VBA but we have a...

Hi all I have read a number of posts on various speed issues with multi-user databases, but I haven't found one that mirrors my particular circumstances. At the start of October 2012 our office lost our local server. Our files are now held on a client server in a different part of the...

Hi everybody I was wondering if there is a way to set up a piece of VBA code that runs whenever a new workbook is opened in Excel (I am currently using 2007). Or if there definitely isn't then to know there isn't so I stop trying to find a way! I can't think where it would need to be located...

Hi guys I have inherited over 1000 word documents contain tables. The tables have varying numbers of rows and columns but follow the same general format. I need to read in the information in each row that has, say six columns, but ignore rows where cells have been merged and the column...

Hi all I am trying to use VBA to work with Outlook for the first time. Essentially I want to extract information about emails being sent or received so they can be entered into a ad hoc work flow monitoring system. I have managed to export all the info I need to Excel by referring to...

Hi guys This is also posted in the Queries and Jet SQL forum (in case any answer involves a query, which is possible) I am looking at MS Access 2003 for the first time in many years, and am having a bit of a trouble achieving what I am after. I would like to create a table with a number of...

Hi guys I am looking at MS Access 2003 for the first time in many years, and am having a bit of a trouble achieving what I am after. I would like to create a table with a number of lookup entries where one lookup defines the available terms in the next lookup. An example of what I am trying...

Hi guys I just realised I stupidly posted this in the Visual Basic Databases forum. So, on my second attempt..... As the subject line basically explains, we have some user defined functions in use within the company which no longer work with service pack 3 of Excel. With SP2 they work fine...

Hi guys As the subject line basically explains, we have some user defined functions in use within the company which no longer work with service pack 3 of Excel. With SP2 they work fine. The UDFs are stored in the form of an add-in, which I think may have been written in VB and compiled, just...

Hello all Question: Is it possible using VBA to retrieve information from closed workbooks without opening them (similar to when working with text files via object.OpenTextFile)? If it is, can someone please give me a few keywords to allow me to do some research? The aim would be equivalent...

Hi guys I have data on a sheet called INPUT, which is effectively a record of post received - the date received is in column B / second column. I want to take a copy of filtered information and put it on another sheet for amendment. After amendment changes are posted back to the INPUT sheet...

Hi all Hopefully a quick one. I am struggling with code which refers to Word from Excel. I have the following: Sub importfromtxt() Set wrdapp = GetObject(, "Word.Application") Set wdDoc = wrdapp.Documents("S22 EL.doc") End Sub What is the missing line to select all text in document "S22...

I have a mailmerge document set up with an Excel datasource. The two are linked via a DDE connection in order to preserve the formatting held within Excel (background to achieve this was found in thread68-1341696). Problem is, it's not working! The mergefields are being linked without the...

I have an Excel spreadsheet (2003) which is used to monitor post coming into and out of the office, set deadlines, and monitor completion times. I know the thing should really be in Access but, having to follow orders, it is in Excel. I am hoping I can improve the calculation speed with some...

Hi Guys I have a mailmerge problem. Effectively I have two pages to the document, which are two different (but related) forms, containing data related to a set of individuals. The first contains the data we hold, the second is to be returned to us with data the recipient holds. There are 4...

We have just been upgraded to windows 2003 at work (I realise we aren't exactly moving with the times!). Starting a new email from Outlook, with a non maximised window gives me a bit of a problem: If I am writing more than the window allows to be shown, the window does not follow the cursor...

I hope someone can help. I am running XP Home on my personal PC. Unfortunately when I log on (after windows loads) all I can see is the desktop background - there are no icons, no start menu, no taskbar etc. I cannot even raise the task manager using cntrl+alt+del, so I am left with the...

Hi Guys Probably an easy question: I have a form with a memofield above a subform. I am trying to set a doubleclick event that changes the height of the memofield (so more of the text is visible). This works fine, except when the height is increased the additional space is behind the subform...

I've been using the same spreadsheet for several months and it's grown to about 24Mb. Today, it fails to open - I just get a "not responding" from task manager no matter how long I leave it. There is one particular sheet I need access to and I am at the point where I don't overly need the...