Hey all.
I have this code to save to xlsx. The problem is that the exported file is saved with links. How can I have the same function breaking the links in the exported file?
Thanks
Please Login or Register to view this content.
Hey all.
I have this code to save to xlsx. The problem is that the exported file is saved with links. How can I have the same function breaking the links in the exported file?
Thanks
Please Login or Register to view this content.
Hi,
One way.
Add: Dim x As Long, lnks As Variant
Then immediately before the SaveAs code
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks