Hi All My company has just moved over to the Hsbcnet banking system, we're having a few problems with creating a upload program to enable us to upload multiple 3 day and 1 day payments, we need to do this a excel file then transfer it in to format that Hsbcnet will accept. Has anyone else ever come across this problem? If so how did you manage to create the file?
Options... It all depends on your Excel expertise. If you can program then either a built-in routine to export the data OR a simple VB script can control Excel and provide more control over the output. If you can't program, you might have to use text formulae to build output strings on a separate sheet to obtain the desired effect. Without the Excel sheet and the HSBCnet specification, I can't be of more help.