Solved

Error in Macro from Inherited Spreadsheet

Posted on 2014-01-17
2
217 Views
Last Modified: 2014-01-17
All,

See attached - a bit of a monster.

I have removed any sensitive data and made the data anonymous.
So it may be a bit untidy.

1. Click Ctl+k

2. This macro crashes

Compile Error - Can't find project or Library
Peter-Test.xls
0
Comment
Question by:Patrick O'Dea
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 39790319
Can you explain expected result of your macro:
Sub Start_Click()
'  ***************   what the problem ?  6661
Update.DTTo.Value = Date - 1
Update.DTFrom.Value = Date - 1
Update.DTFrom.Day = 1
Update.Show
End Sub

Update - your form, but I can't find fields DTTo and other there
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39790346
Thanks for als315,

I am afraid that I cannot answer your question ..... as I have been asking the same one!

I did not develop the sheet ...... it is an old sheet that has been around for years....long story..
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

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
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…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

910 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

21 Experts available now in Live!

Get 1:1 Help Now