Solved

How do I recover a vba project in Excel?

Posted on 2014-11-12
13
116 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
  • 7
  • 5
13 Comments
 
LVL 29

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 29

Expert Comment

by:gowflow
ID: 40437023
Your welcome keep me posted.
gowflow
0
 
LVL 23

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 29

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

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 29

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 29

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 29

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now