Feb 27, 2017 · yes this code just save the path,but i want to open the selected file.and in case i again run the macro,it should open the excel file in a new workbook.

Dec 23, 2021 · I wanna rename only two files from a folder using macro, Although there are lots files in that folder, but unable to do it. I wanna rename file name from "N2" to "NORTH 2 …

Jul 13, 2018 · The spreadsheet can take a couple of minutes to load at times. Sometimes i just want to quickly check the date of an item in the spreadsheet but it just takes so long. I created a macro that …

Mar 5, 2012 · i dont have any problem opening a csv manually (like file->open or your mentioned import text function). only opening csv via VBA code does not work as it should and i need to use VBA. at …

I'm trying to open an Excel file from SharePoint using VBA. Because the file I'm looking for might be different each time I run the macro, I want to be able to view the SharePoint folder and select...

Sep 20, 2013 · The file could be .doc, .xls, .txt, etc.... rather than my vba needing to know the full path the to application, how could I have the vba tell the machine "please open this file and use your …

Feb 9, 2010 · Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in …

I want to use a wildcard to open a workbook stored in the same folder as my macro workbook. In the folder is a file named 302113-401yr-r01.xlsm. Here is my code: Workbooks.Open …

May 17, 2016 · It opens up the shared woorkbook file and it has selected all of the data on a specified tab. The only problem is I'm unsure on how to write code that will automatically paste this data into …

Oct 18, 2012 · well, I only saw this as your question: "Overall I want a function for a button in my userform to open certain workbooks and either perform some actions, save in a format and then …