Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Application

Posted on 2009-05-07
1
Medium Priority
?
163 Views
Last Modified: 2013-11-25
I have an excel file contains:
1- macros
2- Modules
3- Special tool bar
i tried to save the file on other computer, ibut it dosn't work
is there any tool or program been used to for example export an excel and all its related files,
i tried also to talk all the files and folders contains the VB but also some of them don't work
note
when i open the original files then see the VB Editor i can find, Module, Sheet, Forms

the file has been created on Microsoft Excel 97-SR-2(i)
but when i saved the file on a USB and then open the file again i coulldn't see the modules that i have seen on the original
0
Comment
Question by:Hateli09
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
Brian Withun earned 1500 total points
ID: 24325634
Do this:

1) Open your excel workbook, and have no other workbooks open
2) Press ALT-F11 to bring up the VB Editor
3) View the VB Project Explorer
4) Identify EVERY project in the Project Explorer.  There may be only one (your workbook) but I suspect there are more.  You'll see things listed there for every AddIn which is active.

I'm wondering if you have some AddIn that is providing the toolbar and related macros.  By moving your workbook to another computer you will not be moving the AddIn.  When you open your workbook on any other computer you'll be missing the functionality provided by that AddIn, such as the special toolbar.

Brian Withun

0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
New style of hardware planning for Microsoft Exchange server.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question