Search results

I have an app that dumps time fields into Excel in format hh:mm. The problem is that the app can generate negative time e.g. -09:23. When dumped into Excel, Excel place a = sign in front and displays #VALUE!. If you click on the cell the value is displayed as =-9:23 but I cannot access the value...

Thanks David Makes sense. I have never used the CopyFromRecordset so am keen to try. Thanks for the help. Glen

100% correct. Don't tell me there is an easier way?

Thanks David I am using the above snippet as it stands in a test sub and it will not work. Not sure how the rest of the 6000 plus lines would go down? However it appears there may be a problem using the Copy After function if Excel is not opened. I used the following code in blue to force the...

Here is the code I am using in Access 2007 to manipulate Excel. The sheets are renamed, but the workbooks remain hidden, and will not copy. It fails on the Copy After command. I am using Excel 2007. Any idea what is wrong? .... DoCmd.TransferSpreadsheet acExport, 10, "tbl_A, "C:\A.xlsx, True...

Thanks. I had to force the second visible because when the workbook saved, it made it hidden. Not sure why, and the only way was to make it visible twice. However I will try your code and see if it also remove the hide problem.

I had a similar problem. It was caused by making the Excel application visible during testing so the effects could be checked live. The Excel workbook saved and closed but the Excel app remained open. The only was around this was not to make the workbook visible. Code used to make work book...