Download through link special character with file name

 · Now, this is working fine because I am using "bltadwin.ruode" for AttachmentFileName. So it takes care of special charactor and display Open/Save option with correct file name. But the problem is SPACE in file name. It is also getting replaced with "+", so if there is a space in file name, when it displays Open/Save dialog, it also.  · However, you're also using the bad file name later as a parameter to File, and that's probably a bad idea. If this is where the exception is being raised, simply constructing your own filename, without the problematic characters, should be enough to solve the problem. Right-click the cell that contains the problem hyperlink. On the shortcut menu that appears, point to Hyperlink, and click Edit Hyperlink. In the Type the file or Web page name box, type the name of the file that you are linking to. If you do not know the name of the file, click File and browse to the file. Click OK.

Set sh = Sheets("Main") 'An array with special characters that cannot be used for naming a file. SpecialChar() = Split("\ /: *? the updated version allows the user to define a file name for the downloaded file. when i download multiple files through link, the files are getting download but it is corrupted. Links are from google drive. We come across files and folders name very regularly. In most of the cases file/folder name are related to the content of the file/folder and starts with number and characters. Alpha-Numeric file name are pretty common and very widely used, but this is not the case when we have to deal with file/folder name that has special characters in them. Where as if you import data like that into Microsoft Access or other databases, you get the option to import anyway, or remove special characters. My only solution to this has been to write an Excel macro to strip out characters not usually liked by databases when importing - and then import the file using python.

To allow for this, the application provides macros for functions that are not invoked when compiling for Unicode. In both NTFS and FAT file systems, the special file name characters are: '\', '/', '.', '?', and '*'. On OEM code pages, these special characters are in the ASCII range of characters (0x00 through 0x7F). Right-click the cell that contains the problem hyperlink. On the shortcut menu that appears, point to Hyperlink, and click Edit Hyperlink. In the Type the file or Web page name box, type the name of the file that you are linking to. If you do not know the name of the file, click File and browse to the file. Click OK. [a-f]* gives you all files starting with a-f for example. If you have wildcard characters within your file names, use the -LiteralPath parameter instead of -Path. LiteralPath takes that path "literal" and does not interpret any wildcards.