3/16/2023 0 Comments Excel for mac 2018 if then string![]() Otherwise, you will need to provide some other way to get the FQ filename into your code. Documentation on this object can be found at: If you want to provide a way to choose the import file, You can work with the FileDialog Object. If it is in a different folder, you will need to provide the Fully Qualified path to the file and folder. That being said, when you reference a file from your macro, it will generally assume the file you are referencing is in the same folder as the Workbook where you launched the macro. I think people might find it a bit risky to download and open an Excel file that contains a macro. I suggest that you upload a text file of your macro rather than an *.xlsm file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |