Hi all, I am looking for a piece of vb that I can't seem to find to start me off. I am looking for a looped code to go through a bunch of workbooks in a folder and: open, adjust column widths in certain sheets, save and close. I have seen a code for this around but can't at the moment.
Please help!!
Thanks,
Here's a rough outline:
*If you want to be more specific we can modify the code
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thx dept, yeah a couple more things with the code I am having some trouble: having multiple sheets and multiple columns I want to adjust.
jpPlease Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
Thx again dept. I am finding the code works, but only adjusts the sheet that the workbook opens on, it doesn't direct to the correct sheet or "Key", "Key1" in my case. I am trying to figure that out for those specific sheets only.
Thanks againPlease Login or Register to view this content.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks