Solved

How do I recover a vba project in Excel?

Posted on 2014-11-12
13
130 Views
Last Modified: 2014-11-13
I am not sure what I did but a VBA project that listed in my excel workbook went missing.  I can see the project in a directory. How can I add the reject back into the Excel  workbook.
0
Comment
Question by:rhservan
[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
  • 7
  • 5
13 Comments
 
LVL 30

Expert Comment

by:gowflow
ID: 40436995
not clear what you mean by 'I can see the project in a directory' ?
In what form ? what is the file extention ? try putting .xlsm as file extention if it was originally an Excel VBA macro.
gowflow
0
 

Author Comment

by:rhservan
ID: 40437017
That is a good possibility.  Not in the office at this Time will follow up later.  Thais for quick response.
0
 
LVL 30

Expert Comment

by:gowflow
ID: 40437023
Your welcome keep me posted.
gowflow
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 24

Expert Comment

by:Eirman
ID: 40437234
Sometimes you wind up saving code as a separate module (usually called module 1, module 2 etc.) rather than within the intended worksheet.  If this is your problem do the following ...

> Double click on the module on the left
> Highlight/select all the code and copy it (ctrl + c)
> Double click on the intended worksheet on the left
> Paste the code in on the right (ctrl +v)
> When you are happy everything is working okay you can delete the module provided
   there is no working code remaining (ignore the export option).
> If you are worried about deleting the module, just comment out the code
   and check that everything is still working.
0
 

Author Comment

by:rhservan
ID: 40437545
Yesterday everything was working fine. No changes have been made to any code for a couple of years.

I may have been prompted regarding macros and replied incorrectly. But I really can't tell you for sure.  Just the xla file is missing from the workbook.



The missing file in the workbook Is an xla file.  
The workbook is an xltx file.
These are the original and the current file extension.

I can see the missing .xla file in the directory.

Other xltx files may have been affected.
0
 
LVL 30

Expert Comment

by:gowflow
ID: 40437596
.xla is an addon file
although it is there if it does not show on your workbook when you open it this means it is not activated.

Depending on the Excel version you have it differs to explain how. Presume you have Excel 2003 but will leave you to advise.
gowflow
0
 
LVL 30

Expert Comment

by:gowflow
ID: 40437606
It is definitively an Excel 2003 or prior.

Do this.
1) Open Excel blank
2) Open the Tool menu and Choose Addin
3) From the Addin list check which one is the one that need to be ticked I am sure you know which one is missing.
4) tick it and close the workbook.
5) Open any of your workbooks and it should work now.

gowflow
0
 

Author Comment

by:rhservan
ID: 40437720
Sorry no tools on menu.
0
 
LVL 30

Expert Comment

by:gowflow
ID: 40437723
What version of Excel !
gowflow
0
 

Author Comment

by:rhservan
ID: 40437842
I think this may make it a little more complicated:

this is in an application named SAP BPC.  And they have locked out Tools from working on the menu.

They have excel 2007 installed. They are using Excel 2007 and although I can add the Tools under customization it does not show up.
0
 
LVL 30

Expert Comment

by:gowflow
ID: 40437985
For Excel 2007 do the following

1) open Blank Excel
2) Press on the Office Logo Top left corner then choose Excel Options
3) In the Excel Options Left Pane Choose Add-In
4) In the Buttom of the Screen you have a combobox that should say Excel Add-In and beside it a button GO. Press on GO
5) Now you will have the Addin Form pop-up look in the list for your corresponding addin and tick it and press ok. Close Excel and Exit
6) Open your workbook and check that it is working.

gowflow
0
 

Author Comment

by:rhservan
ID: 40440536
Okay goflow, I understand and applied your recommendations about adding an add-in above.  I was able to browse for the add-in and place a check mark on the item.  
However, it does not show up in the VBA Project list.  Please advise.
0
 
LVL 30

Accepted Solution

by:
gowflow earned 500 total points
ID: 40440659
Your add-in should be in this directory:
C:\Users\<UserNameLogedIn>\AppData\Roaming\Microsoft\AddIns

<UserNameLogedIn> = the user name you log in Windows.

gowflow
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

696 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