LINKED xls file prob

Topic

New Reply

Hi use this cod eto have a number of cells in column.

dim cella as long
dim ws4 as worksheet
Set WS4 = ThisWorkbook.Worksheets(“TEST”)
CELLA = WS4.Range(“C” & Rows.Count).End(xlUp).Row

When i open the workbook from a dir C: and start the code all work fine.
But when i depoist in dir of http: and call it via link the code go in error 1004….method global…eccc

why??????

Reply | Quote

Replies

Probably the file opens in Internet Explorer. VBA code in Excel files does not work well when the file is opened in IE.

Reply | Quote