Re: Use VB macro in excel 2007 to Iseries
Use dot instead of slash between lib and file to qualify. You must use the *SQL naming not the *SYS naming when running VBA.
Code:
Cmd.CommandText = "SELECT * from lib[COLOR="red"][B][SIZE="6"].[/SIZE][/B][/COLOR]file "
Comment