Search results

  1. R

    Method cells of object _Global failed

    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...
  2. R

    Passing variables to a sub routine

    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...
Back
Top Bottom