when i run the script i get an error message that says that the files can't be opened. i'm trying to get data from the excel files. i've checked the path and it's correct, the files aren't protected or read only or anything either
What is the specific error message? I've had several variations on this over the years. Sometimes it is an invalid file format. Sometimes the file is locked open by Excel. It depends.
NyaMux: Load Postnummer AS #PostNummer, [Nya Mux 5] AS sls_Nya_Mux_5 FROM \\192.168.101.130\QlikView\exempel\NyaMux5.xls] (biff, embedded labels, table is [Mux$]);
if I change the Ip to "D:" it works, but I would like to use the ip and that doesn't seem to work
I'm not sure whether this is just a character that was cut in the copy / paste.. but you seem to be missing the first [ - bracket before the \\ in the example above.