Search results for query: *

Thanks for that idea, Skip - I have never looked at MSQuery before but it looks very interesting and powerful. And you are right, pulling the data would certainly overcome the issues I am experiencing. Plus, the data in Excel can be so easily selected and manipulated - potentially saves me...

Thanks all. The data is a mixture of both numbers and text and neither type updates at all. This is no different to what has been exported to the same spreadsheets in .XLS format for years and they work fine. There are two main differences that I have uncovered, certainly between 2003 and...

Thanks kjv1611 for the idea. Sadly in this case it has not fixed the problem. I am also encountering numerous issues where Access cannot complete it's export and gives a range of error messages, none of which are relevant (eg things like "target object locked", "range not found", "format not...

I have quite a few spreadsheets which are updated monthly from an Access database export. Access does some pre-processing and data selection and exports the raw information to the relevant workbooks. The workbooks have a raw data sheet (where Access has pasted it's export) and a series of...

Hi Skip I send personalised reports to many people each month and the report contains both data and charts. Under VBA I have used the following for years in Excel 2003: Set SourceWB = ActiveWorkbook ActiveSheet.Copy Set DestWB = ActiveWorkbook ' Change...

I am just starting out with Excel 2013 so this might be very basic! I cannot get the copy sheet function to work properly. I am used to it creating a perfect copy of the original sheet including both cell contents and any charts, but in 2013 I only get cells on the new sheet with blank areas...

For certain tasks I need quite a few applications open and it is a pain to get them all sorted out at the start of each session. Is there a way in which I can save a list of all the apps open at a moment in time and later (perhaps another day) re-open them all just as they were by restoring the...

My copy of Excel is crashing if I attempt to open a worksheet that includes a control - eg radio button, click button etc. It will open a workbook but crashes immediately the sheet is accessed. I am sure the controls are the issue since I can cause the crash just by creating a new control on a...

nCotton Ive had this problem where I have copied a control from one page of a tab control and pasted onto page 2. Suddenly the copy is there on page one and two (and on any other pages you may create subsequently). I no longer have the problem by copying and pasting as follows: 1. Copy the item...

I simply could not work without Directory Opus, fantastic flexibility, masses of features and stable. I've used it for 2+ years. User support is excellent too. www.gpsoft.com.au.