Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

Excel Application

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
Hateli09
Asked:
Hateli09
1 Solution
 
Brian WithunCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now