Recent content by SSHA_SP

I went about it this way in the end, I dont know if its the best way but it does exactly what I want: Option Compare Database Function ExcelExport() Dim lngFieldCounter As Integer Dim strPath Dim fso Dim f As Boolean Set fso = CreateObject("Scripting.FileSystemObject")...

Thank you for the help I'll give that a go tomorrow.

Ok sorry not trying to insult your intelligence. No I cant think of a way of bringing them all together. I was just hoping there would be some code I could use that would copy Query 1 into Sheet 1 A1. Then I could tailor this to suit. I know this is quite a lengthy way of doing things and...

No there all separate entities. I guess I could lump them all together in a form/report if that makes it easier? Thanks

Hi, More simple questions for you experts (apologies in advance) I have a selection of Access Queries which are currently been manually pasted into various locations of an Excel template located (C:/MyDocuments/Weekly Report.xls): [Query_Sales_000] pasted into “Sales Sheet” cell “A1”...

Kiwiman you have nailed it!! Thank you ever so much and to all those who offerred advice.

Thank you I will try that tomorrow I never imagined it would be so long winded. I have typed up my original question, hopefully it makes more sense. Thanks

The source data is from an excel ss. I didnt want to convert it within excel as I was hoping to just link the ss to the database. Its Shows 7th May but would have a lenght of 8 as there is a blank space at the front.

many thanks

I appended the data into a table and tried to change the value but it just resulted in errors. What is the easiest way to split number and text Eg: "13th" = "13" "th" separate fields?

The date is seen as text so it wont work in its current format. Thank you for the suggestion though

Hi, I'm trying to get around an issue I'm having with a set of data that has a [Date] in a text string format (See below): 14th January 2009 (17 characters in length) 7th March 2009 (15 characters in length) 2nd September 2009 (19...