Link to home
Start Free TrialLog in
Avatar of InvisibleMan
InvisibleMan

asked on

Opening Excel File modifying column width then saving it in VB.

Ok all I need help here.  I actually have more to do then this questions asks but I just want a simple scenario.

I have been fighting with this since yesterday.  I need to start from the basics.  Does anyone have code that opens an excel file changes the width of a column and then most importantly overwrites the file with the saved changes without being prompted.
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SpideyMod
SpideyMod

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

I am in the process of cleaning up the questions for this member as this member has failed to take care of their opened questions
Experts, please leave your recommendations within the next 3 days.
Without recommendations, I intend to come back here on 2/26/2003 and:
Force Accept answer by TimCottee


InvisibleMan,
You have 16 opened questions and have been asked to take care of them previously.  If you wish to keep your account in good standing, please take care of these questions prior to 02/26/2003.  
Failing this, your account will be reviewed by a site administrator at that point.  I am posting this in ALL 16 opened questions and have submitted a cleanup request in community support.

https://www.experts-exchange.com/questions/20439569/Need-help-with-creating-a-word-template-and-some-simple-fields.html
https://www.experts-exchange.com/questions/20453889/Making-a-image-or-picture-visible-with-code-Tough-Question-need-a-smarty.html
https://www.experts-exchange.com/questions/20388128/Unable-to-Log-On-to-Provider-SQLOLEDB-1.html
https://www.experts-exchange.com/questions/20343921/GREAT-PLAINS-DYNAMICS-HELP-Integration-Manager.html
https://www.experts-exchange.com/questions/20273575/DATABASE-SIZE-SHRINKING-AND-LOG-FILE-QUESTION.html
https://www.experts-exchange.com/questions/20480517/Crystal-Reports-Sum-Question-on-Amount-Field-Help-Please.html
https://www.experts-exchange.com/questions/20475331/Inputting-Text-into-a-Bound-Dropdown-Control-Help.html
https://www.experts-exchange.com/questions/20409250/Opening-Excel-File-modifying-column-width-then-saving-it-in-VB.html
https://www.experts-exchange.com/questions/20336887/Visual-Basic-Grid-Help-Different-fields-from-different-sources.html
https://www.experts-exchange.com/questions/20327829/How-to-know-what-the-latest-DLL-is-registered-on-server.html
https://www.experts-exchange.com/questions/20324132/Class-Modules-and-VB-Application-Question.html
https://www.experts-exchange.com/questions/20390261/Creating-a-HTML-Email-Feedback-Form-Can-it-be-done.html
https://www.experts-exchange.com/questions/20403544/PDF-Files-previously-on-the-Web-allowed-data-entry-now-it-does-not-Help.html
https://www.experts-exchange.com/questions/20519637/Tab-Pages-Not-Ordering-Right-on-Tab-Page-Driving-me-nuts-Help.html
https://www.experts-exchange.com/questions/20457825/Strange-Issue-with-Datagrid-Refreshing-Help.html
https://www.experts-exchange.com/questions/20428768/Tree-View-Help-Please-with-Tree-View.html


SpideyMod
Community Support Moderator @Experts Exchange

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Avatar of InvisibleMan

ASKER

No answers worked but you get the points due to an expert not realizing that many questions I have placed out on Expert Exchange have provided no answers.  Thanks for your input.
InvisibleMan, if it didn't work then you should have commented to that effect and I would have attempted to resolve your issues further. Without feedback from yourself it is impossible to understand whether a proposed solution which does indeed work however may need tailoring to your specific situation has indeed worked in your situation or not.

SpideyMod, please can you modify the grade assigned for this question.
All C grades issued are being changed to A grades.  InvisibleMan, if you have issue with this, please post a comment in Community Support and I will have another moderator or an admin look at my actions.  If the answer didn't work, you should have opted to request a refund instead of accepting an answer which any one of us would have gladly assisted with.

SpideyMod
Community Support Moderator @Experts Exchange