Set excel cell validation using access generated workbook

  • Thread starter Thread starter Chris Archer
  • Start date Start date
C

Chris Archer

I have a workbook and associated worksheet generated using access that I
would like to set validation onto a range of cells.

The code I'd expect to use directly in excel vba would be:

With ExcelAppObj.ActiveSheet.range(rng).Validation
.Add ....
End With

but this does not work when executing from access. It doesn't flag any
errors, and the objects are all populated.

Any help would be greatly appreciated.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Writing to Excel Error (1004) 2
Opening an Excel workbook with VBA from Access 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
MS Access 4
Import same Excel ranges from many workbooks 3
Getting values from Excel worksheet 4
Using Already Open Workbook 3

Back
Top