🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 04-22-2022 01:16 AM
(607 views)
Hello. I appreciate you help me find answer for the bellow question:
What statement removes the library reference from excel workbook?
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is this what you mean?
/* assign library X to excel file */
libname x excel 'C:\Temp\temp.xlsx';
/* remove library X */
libname x;
/* or */
libname x clear;
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is this what you mean?
/* assign library X to excel file */
libname x excel 'C:\Temp\temp.xlsx';
/* remove library X */
libname x;
/* or */
libname x clear;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
LIBNAME both assigns and clears the connection to DB, file or folder.