Recent content by Geek65

Bump..HELP.... Nobody has any ideas?????????? REALLY wow. bummer.

Definitely. Open your form in Design view. Click on the button you want to edit the code on. Right click and select properties. On the event tab of the property sheet window next to your event procedure click the box that has the three dashes ... and that will take you to the code.

I have a report that I am exporting to Excel saving and formatting using VBA from access 2007. I have one last bit of formatting I want to accomplish. It involves applying .WrapText and .MergeCells. The excel file created from the report accepts the WrapText but will not accept the MergeCells...

I think I had tried that along the way and it was not happy which is why I ended up with the entire objXL.sheets reference. I'll try it when I am cleaning up the code.

Just as an FYI for others seeking to solve ghost instances of excel in the task manager after running Access VBA code make sure any use of or reference to Range, Column, Row or Font is always preceeded by your declaired object. Hope that helps someone. Gday all. Steve

Found it. changed ; objXL.Sheets("TSSRSheet1").Range("K2:O9").Cut Destination:=Range("A2:E9") to; objXL.Sheets("TSSRSheet1").Range("K2:O9").Cut Destination:=objXL.Sheets("TSSRSheet1").Range("A2:E9") She is all happy now.....

Hi all. I am working in access VBA. I am dumping a report out to Excel and attempting to format the worksheet using Access VBA. I can get the code to adjust cell width and close/quit without leaving a ghost excel open in the task manager but as soon as I attempt to move a block of data it leaves...