![]() ![]() Nextrow = Database.Cells(Rows.Count, 1).End(xlUp).Row 1ĭatabase.Cells(nextrow, 2) = objfile. Set objFolder = objFSO.GetFolder("C:\Users\SHMEHTA\Desktop\CFD Tool For Request") ![]() Set objFSO = CreateObject("Scripting.FilesystemObject") I have written the code to get file name from the folder in master data base file as shown below but i am not able to figuring out how to open that file copy and paste in this in sequence Paste the file link in the email and in the link, change edit to copy. Ideally would allow choosing default settings for each content type. Creating a Makefile is often an adventure. Could work by simply right-clicking on a folder in File Explorer and picking a Paste to File option. I want to do this process in sequence like 1st enter the file name which is opened in master file, then copy specific cell value from the opened excel file
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |