Search results for query: *

tf1 Thanks for your responce I have found a conflict (blue tooth add in) and now rectified this and other problems. Thanks again Davo

Hi All I have just purchased MS Office 2007 and have found that a basic feature is not availabe. When I use "save as" in Exel 2007 it displays folders but does not display any existing files of the same extension. Can this be rectified or is it something that I must live with. Thanks in...

fneily Thank you for your prompt reply It's now obvious that I have been approaching this problem incorrectly Thanks again Davo

In my DB I have 2 tables "Customers" and "Job_Input" The "Customers" table is updated daily and each customers is identified by a JobNo. The "Customers" table is a contiuous form which displays todays customers, each customer has a command button ("Update"). The objectives are to: 1. Open...

Thanks PH The line I deleted was xlWkbk.Close error possibly because workbook is closed by the macro. Hopefully one day I'll get to the point of not missing the obvious Thanks again PH for all your help davo

Deleted the following line all is working ok now, exel closes and no errors. Is there a way to run exel in the background to avoid seeing the changes implemented by the macro. THanks again PH for your help. davo

Thanks again PH for your quick responce and advise. I have inserted the as suggested still not closing, get the following error, "Automation error, the object invoked has disconnected from its clients". Is the following what you are advising. Private Sub ImpCust_Click() On Error GoTo...

Thanks PH for your quick responce and advise, I have tried this line in several locations in my code but to no success. Thanks in Advance davo

Thanks for the help PHV. Another action I am trying to achieve without any success is closing The application of exel that I opened with my macro. Is it possible to close the exel I opened without closing another opened exel application. ie if I have a workbook "Expences" open then I open...

I have found the following code and it opens the exel workbook (CustMacro.xls)which contains a macro (Auto_Open)to transpose layout to match MS Access fields. The macro does not auto run when the workbook is opened, The macro will auto run when I open the workbook from MS access using a hypolink...

I am having a problem trying to run a macro to transpose an Exel worksheet then import into MS-Access. I have compiled an Exel macro which transposes the data to suit MS-Access this works fine. I can then import the spreadsheet using MS-Access macro action "TransferSpreadsheet" this also works...

Thanks for your help REMOU. I now have that working fine. How can I run a macro from a command button in Access to transpose and then import my data. I can open Exel with command button set to "Application, run Exel" is there a command line to add that will then run my transpose macro. Set oApp...

SELECT [CCodes].[CCodeID2], [CCodes].[CCode], [CCodes].[Description], [CCodes].[Payment] FROM CCodes; Private Sub CCodeID2_AfterUpdate() ' Update WIP based on value selected in CCode2ID combo box. Me!Descript2 = Me![CCodeID].Column(2) End Sub Thanks Geoff

Hi I recieve my daily work via the internet and have the option to export to Exel. The issue that I have is that the information that I require is in rows not columns. ie ProjectNo, Customer, WorkDescription etc. are setout in rows with the info in the columns. Is it possible to import the...