I have a bit of code which specified the path for a file to save to. Unfortunately the path is 166 characters long. The filename is a nifty little 74 characters long. Meaining that the path and filename combined is 240 characters long. Apparantly in Excel there is a limit in VBA of 218 characters for a path and file name string.
Anybody know a quick way around it.
Anybody know a quick way around it.
Comment