filedialog

Hi all, I have a macro where i'm trying to convert an excel file to csv with semi-colon separator. I thought the method was to convert to csv, and secondly to replace coma by semi-colon but it's not working. It seems we can force the separator somehow, but I don't know how to do it inside my...

I have a model that I run off of Excel 2003; however, I have about 25% of the users with 2000. I used the following code that works in 2003, but didn't realize the FileDialog doesn't work in Excel 2000 (get the variable not defined error). Are there any quick ways to fix this code so it will...

Hello, I want to open Save As File dialog box in Excel. I need it to have these features: 1) ability to add filters (msoFileDialogSaveAs does not support it) 2) ability to change Save As button text 3) Unicode support I was able to get all my mentioned functionality with...

When using the file picker or open dialog via the FileDialog property you can select multiple files to open, is it possible to restrict users to only selecting one file?