Microsoft Developer Network >
포럼 홈
>
Visual Basic for Applications (VBA)
>
File Search and Insert using VBA
File Search and Insert using VBA
- I am looking for a simple way to search for a file named the same thing as a variable that I have already determined and then insert that file into an excel file. I have tried to use the application.filesearch, but I have not been able to get this string to actually display or insert the files it has found.
답변
- I think I've got it with ActiveSheet.Pictures.Insert(.FoundFiles(i) and the application.filesearch application. Thanks to all who have viewed this.
- 답변으로 표시됨Tim LiMSFT, 중재자2009년 8월 5일 수요일 오전 7:39
모든 응답
- I'm using excel 2003 by the way.
- I think I've got it with ActiveSheet.Pictures.Insert(.FoundFiles(i) and the application.filesearch application. Thanks to all who have viewed this.
- 답변으로 표시됨Tim LiMSFT, 중재자2009년 8월 5일 수요일 오전 7:39
