PDA

View Full Version : 'Update Values: datasheet.xls' problem



j.smith1981
03-03-2009, 02:14 AM
I am right in the middle of polishing off a rather complex macro.

Just im having a little trouble with something I dont really understand, when I try and run it, due to allot of the data being kept on another sheet 'datasheet.xls' and every time it goes to do the vlookup part I put into the macro, it appears to be asking for where the file datasheet.xls file is, I havent put datasheet.xls in any sub directory of where the macro his placed and have used relative referencing for all data.

Is there anyway of making this moore foolproof, just obviously dont want it asking each time as to where datasheet.xls file is, this would be for about 5 columns and about 702 rows so you can imagine how long that would take of doing that procedure.

Has anyone got a solution? I'm out of ideas:banghead:.

Regards,
Jeremy.

Bob Phillips
03-03-2009, 03:10 AM
Too little information.

In what way does it 'ask'? Datasheet.xls is another file not another sheet, so your description is confusing. Are you opening the workbook?

and so on ...

tpoynton
03-03-2009, 11:11 AM
stab in the dark, I've seen that error appear when a worksheet name has unacceptable characters in it, a space in my case.