I have has some success in manipulating data in excel via VBA from Access using
Set objXL = GetObject(xls_location)
With objXL
...
This is fine if the file is saved somewhere and I can supply the location. I now need to work on a spreadsheet located on a web server. I access it using FollowHyperlink " .xls) which opens it up in excel.
Can anyone please advise the neccessary commands to now work within the excel sheet. I simply want to find a cell in the spreadsheet based on a control on the calling form.
Many thanx
Georg
Set objXL = GetObject(xls_location)
With objXL
...
This is fine if the file is saved somewhere and I can supply the location. I now need to work on a spreadsheet located on a web server. I access it using FollowHyperlink " .xls) which opens it up in excel.
Can anyone please advise the neccessary commands to now work within the excel sheet. I simply want to find a cell in the spreadsheet based on a control on the calling form.
Many thanx
Georg
