Skip to Content
author's profile photo Former Member
Former Member

Viewing the VBA Code and Retaining during the code

Hi Experts,

Where can i view the VBA Code and Macros used in the Workbooks (If any). We are migrating the workbooks and we have some VBA Code used for formatting the workbooks. And after migration we lost the formatting features in the workbooks. How can i retain the earlier formatting. Anyone who was involved in a similar me share your experiences.

Thank You!

AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 15, 2008 at 03:37 AM

    Hi,

    Migrating the workbook to 7.0: I did this, in following way:

    -save it. At this stage the format is going to be exactly same as 3.x workbook. If you start refreshing, you loose format.

    -Go to design mode and deselect 'apply format' option and save it again. Here you can see that you have lost the format.

    -Format it again and save it.

    -This should work now when you refresh. Refreshing takes.

    Pls chk this links;

    /message/3502939#3502939 [original link is broken]

    /message/3693377#3693377 [original link is broken]

    /message/3502939#3502939 [original link is broken]

    http://www.techonthenet.com/excel/macros/refresh_pt2.htm

    http://www.dicks-blog.com/archives/2004/09/27/ask-to-refresh/

    where-are-the-bex-variable-stored

    http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/frameset.htm

    Hope it Helps

    Regards

    CSM Reddy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.