Search results

Ah right - thanks for the link. I suspect that article is spot on. I am more used to coding in Excel where the reference to the Workbook or Sheet would be superfluous. I will try putting them all back in to be more explicit and see if this resolves it. I did have issues with Excel hanging and...

Thanks for the reply. Yes I didn't have that in originally and can see the difference. I added it in a bit in desperation after getting this error previously. Taking it out doesn't stop the problem.

Hi I have built a bit of code to e-mail a series of Excel files which hold data from different queries.I have built the basic e-mailing into a function and embedded a call to Excel in order to format the spreadsheet as I am using DoCmd.TransferSpreadsheet which doesn't retain any formatting...

Hi Thanks leaving out the parentheses worked a treat. Funny how the helpful VBA prompt as you type the variables in suggests to you that the format requires parentheses. I suspected it would be something basic!

Hi Bit of a beginner so bear with me. I am trying to do something very basic and cannot quite see what I am doing wrong so any help would be appreciated. I have a public sub routine which requires parameters to be passed to it when I call it from an access form. When I try to enter the code...