Sorting XL spreadsheet from Access

G

Greg

Hi all,

Has anyone ever tried to sort data on an Excel
spreadsheet from Access? If so, how did you do it? I
have not been having much luck - Access does not like the
VBA calls to excel - it doesn't like the Range call...
Thanks in advance!!

Regards,
--Greg

objActiveWkb.Application.Selection.Sort Key1 = Range
("G2"), Order1 = xlDescending, Header = xlGuess,
OrderCustom = 1, MatchCase = False, Orientation =
xlTopToBottom
 

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

Runtime error 1004 Application-defined or object defined error" on data sort 1
Code to sort rows getting hung up by merged cells 0
Simple Do... Until problem 4
SpecialCells(xlCellTypeBlanks) = error 1004 No cells found 5
Sorting columns of data 1
Sort in hidden page crach 8
Problem sorting a range of columns using VBA 1
Sort Marco won't work in 2010 5

Top