I have vba code that performs a Save As, creating and naming new files. The new files should not have any read/write restrictions. They should be available for anyone to open, read and make changes. What should the code say to remove read/write restrictions on the new files?
Thank you
I have a Zip file that contains more Zip files (Zipception?).
ZipFileParent\
ZipFileChild1
ZipFileChild2
ZipFileChild3
ZipFileChild4
ZipFileChild5
Basically I need to read/edit the comments for the ZipFileParent, as well as the ZipFileChilds. I'm pretty experienced...
I'm looking for a way to open excel and write to it from another VBA enabled application. I can open the file I want using:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.Workbooks.open ("C:\BoxSizes.xls")
And I can loop through the solidworks files...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.