The macro cannot be found

I have problem when I wanna open Excel Files. The error 
message is like this :
The macro "C:\Windows\Application 
Data\Microsoft\Excel\XLSTART\Book1'!Test5' cannot be found.

Please help me. Thanks.

10/10/2003 9:48:06 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 21

Does this happen when you're starting excel or does it happen when you do
File|Open from within xl?

Does it happen when you double click on a file (in windows explorer) with xl
open or when excel is closed?

I'm gonna guess that it happens when you start excel (maybe by double clicking
on a file in explorer).

Excel loads files in your XLStart folder and addins that are checked under

It kind of sounds like there's a workbook that's trying to open and that
workbook wants to run a macro in book1 (book1.xls???) named Test5.

If my guess is ok, then I'd move all the files out of the XLStart folder and
uncheck the all the addins under Tools|Addins.  (Keep track of what you did so
that move the good ones back.)

Then one-by-one, move things back and restart excel to test.  If/when you find
the culprit workbook/addin, you can decide what to do later.

Chip Pearson has more notes at:

Anathapindika wrote:
> I have problem when I wanna open Excel Files. The error
> message is like this :
> The macro "C:\Windows\Application
> Data\Microsoft\Excel\XLSTART\Book1'!Test5' cannot be found.
> Please help me. Thanks.
> Anathapindika.


Dave Peterson
ec35720 (10082)
10/10/2003 9:57:50 PM

Similar Artilces:

macros enable
macros are automatically enabled on my pc but when i send my spreadsheet to work i get it asking me if i wish to enable or disable macros. I always want it to be enable. is there a way I can digitally sign my files at work to stop this message to automatically enable macros? Myfanwy tools>>options>>security>>macro security>>select "low" regards Bill K "myfanwy" <> wrote in message news:1e1901c50c3c$70b30a40$a401280a@phx.gbl... > macros are automatically enabled on my pc but when i send > my spr...

macro with F9
I want to a macro to insert the formula =TODAY() and then recalc it to make it a static result that represents the date as of the time the macro is run, not a dynamic formula that would change with each new day. I have recorded a macro to do this. If I run the macro & today is Aug 3, the correct result would be 08/03/2005, not the formula =TODAY(). However, if I run my macro tomorrow, Aug 4, the macro returns a result of 08/03/2005, because the code that resulted from my macro-record has a line in it, such as Select Active Cell. Active Cell = "08/03/2005." I would like ...

Perform a macro a specified number of times
Hello All, I'm working on a spreadsheet that will calculate arrears for a numbe of months. The number of months will change each time the calculatio is run. I need to copy and paste the calculation formulas by using a macro tha will repeat the copy and paste function the number of months. I'v recorded a simple copy and paste macro. How do I modify the macro to read the calculated number of months in specific cell and then repeat itself by the number of months? I hope this makes sense! KLynn "When in danger or in doubt, run in circles, scream and shout." ~Dor Lon -...

I found this great little site
I found this great little site. I signed up two weeks ago and got 2 Disney tickets and this week they are sending me 2 Universal Studios tickets. Here's the link and by the way I am a real person, this is my real email address. I'm not a spammer and didn't appreciate the nasty email I got last time I tried to post this link. Thanks, Lisa ...

OWA giving 404-Page Not Found
Try this (on MXS 2003): send an e-mail. However, in the subject line, make sure the subject ends with a period (for example, put in: etc.). Now open that e-mal up in OWA, and you'll see HTTP 404 - Page Not Found. If you send the exact same e-mail but taking only the period off, the e-mail shows up just fine in OWA. The e-mail with the period shows up fine in the normal Outlook client. Any hot-fixes from Microsoft? I've seen this now on three different installations of Exchange 2003 in 3 different companies that I've been to, so it's nothing unique to where I'm curre...

Macro Warning #2
I've been working on a payroll spreadsheet, suddenly when I open it, I get the macro warning, but I haven't created any macros. Help? Are you using anything from the control toolbox? regardless, open the workbook, press alt + F11, in the project pane to the left check to see if you have any modules, if so right click it/them and select remove module, answer no when prompted, if there are no modules double click each sheet module and ThisWorkbook, delete whatever code might be in those, press alt + Q to close the VBE and then save the workbook. HTH -- Regards, Peo Sjoblom...

Change Date By Macro or Code Leaving Only One Record
Hi, I have a table called RUNDATE which has only one record in the date which my whole program looks at as the running date. I would like to run a Macro on a form or a Code upon which once I press it that single date in that table to change to the next day, lets say from 3/5/07 to 4/5/07 to delete the previous record of the 3/5/07 and to be left only with one record with the new date in this case lets say 4/5/07. Much Appreciated make a query of this single record table field - and then put that query into your form as a can keep it not visible if you wish......

Make a Macro on a Toolbar
Hi, I created a Macro but I want to have it show up on a toolbar. I know that you can create a custom toolbar but how can i add a macro (which I would need an icon) onto that toolbar or any toolbar? Thanks, Sean Sean Tools>Customize>Commands. Scroll down to "Macros" and select the smi;ey-face button. Drag it up to an existing toolbar. Right-click on it and "assign macro". Choose your macro from the dialog box. Note: you can edit the the smiley-face button. There are many other ways to do what you want, the above is the basics. Gord Dibben Excel MVP On M...

Macro for test result Count as pass, fail and incomplete.
Hi all, Please send me a macro to resolve my issue as i have to excecute test cases and after that at the end of the day i need to send the number of count for my test cases as Pass, Fail and incomplete, and right now i'm doing this manually so please send me a macro so that just running that macro i 'll able to count my test result separatly as pass fail and incomplete... Thanx in advance... Amar You have given no information about the data layout, so it is difficult to be specific, but you can probably do what you want with a worksheet function instead of a macro. See Help fo...

Macro writing
I understand the concept of macros, I just don't know how they execute and the possible functions. I would like to import a considerable amount of data from excel into access. The problem I have is that the information I want to import for each record is on two adjacent lines. I need a macro that will move the data contained in just one cell to the end of the row above it and then delete the row that, that information was contained in. Then I need it to repeat that function on every other row. Sounds easy right? Way my luck runs you could do anything you want to do except what I need. Anyo...

import data with macro
I'm trying to import ten sets of data in Excel. I click on import external data and then choose a file and press next. I add a space to separate the data into two columns and then press finish. I was wondering if it would be possible to use a macro to import the data. Possibly import the first one and then have the macro import the next 9 in succession. The files I import are always in succession, but always have slightly different names. For example, the data I collect today will be saved as 718cr1, 718cr2, 718cr3, etc. The last number represents the trial number and the fir...

eBay Appointment Macro
Hi Guys, I have put together a macro that allows you to create an Outlook Appointment (and by extension, to your PDA) for Ebay items that are due to end bidding. The macro even adjusts for local time zones. The way it works is that you simply view the item on ebay, select "email a friend" and enter your own email address. When outlook receives it an appropriate appointment is created. I did this for myself but it occurs to me that there may be others interested in using it. If so, feel free to contact me. I've tested this only with outlook 2003 but would be interested to se...

chart resize macro #2
Hi all, I often have to put a large number of charts in a report that need to be the same size. I'd like to create a macro that automatically resizes selected charts rather than manually resizing each one. I've tried to record a macro where I select a chart and resize it but the resizing part doesn't seem to get recorded. Any idea on how I would do this? Thanks, Josh Sub ChartResize1024x768() Dim oCht As Chart Set oCht = ActiveChart oCht.Parent.Width = 768 '1024*.75=768 oCht.Parent.Height = 576 '768 *.75=576 End Sub Works perfectly. Thank...

Macro Warning Message
Hi I have a weekly sheet where I have inserted a macro button to remove data from a previous week when starting a new one. I want to put a warning message on screen first before the Macro is executed. How do I do this? Thanks Brian You could put the warning in the caption... or you could just get a confirmation after they hit the button to start the macro: Dim Resp as long '... Resp = msgbox(Prompt:="You sure you want to do this?", buttons:=vbyesno) if resp = vbno then exit sub 'get out end if "" wrote: > > Hi > &...

How I write following macro?
Hi. I must prepare macro: that is steps open file (xml) finding in this file strings, that is defined in macro For found strings copy falue, that is in xml structure (beetwen > < for exammple: >100<) paste number in right cell (in to excel file) Open window: save as... thx Tom ...

One of my clients cannot get the change security to low option to stick. Every time she opens the database, she gets assaulted by meaningless security messages because she cannot turn them off. Is this being controlled by the IT department with some registry setting? Pat: It COULD be a Group Policy that their SysAdmin has set. -- Bob Larson Access World Forums Super Moderator ____________________________________ If my post was helpful to you, please rate the post. "Pat Hartman" wrote: > One of my clients cannot get the change security to low option to stick. > Eve...

Sizing individual charts with a macro
Hi, I'm kind of flying along through VB on a wing and a prayer, so would really appreciate some help with sizing individual charts in Excel. I have found some coding for resizing all the charts on a sheet, but really need to be able to click on a chart and resize them individually. I can manage it as long as I have selected the chart with the Select cursor (from the Drawing menu) and it is seen as a shape, but if I am in the chart in editing mode, I get a run-time error 438, and the message 'Object doesn't support this property or method'. I'm in Excel 2003. Ma...

I think I want to make a Macro
Hi Everyone, I generally use excel to make nice forms and basic sorting, and basic calculations. I just exported some data from a data mining program into an excel spreadsheet. I then used this spreadsheet as a linked table for an access database in an update query. I use a patient number field to link my data. I had trouble with this column and the only thing that worked to make the data compatable with my access data was to create a new column and I used this expression =TEXT(B2, "0"). I then had to use this column to link my data. I also have to delete the first column and...

now() using macro
Hi JE McGimpsey The solution you gave to me is working. Thanks for that. You have actually given me code in VBA. IS it possible for you to guide me to use same function using macro and achieveing same result. If you want I can forward you my excel sheet and you can let me know the solution using macro Thanking you in Anticipation!! Not sure what you're after - macros in XL are written/recorded in VBA, so a macro solution is a VBA solution. Since you started a new thread rather than replying to a previous one, I'm not sure what you're even referring to... In article &l...

How to Schedule a VBA Macro?
Guys, ever wondered about setting Alarm or Scheduling VBA macros in MS Excel. Please visit: ________________________________________ Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) ________________________________________ I'd actually start with Chip Pearson's site: On 11/18/2010 07:55, Ashish Jain wrote: > Guys, ever wondered about setting Alarm or Scheduling VBA macros in MS &...

Dates in a macro
I have the code below as well as other code in several macros. What I would like to do is ref. a cell for the date rather than have to change the macro every month. I have check the web and all I can find is information like the code here. There must be a way. I want to ref. cell sheet "01" B1 and sheet "Totals" B1. The cells have the date format as dd-mm-yy. StartDate = DateSerial(2009, 9, 1) EndDate = DateSerial(2009, 9, 30) -- Thank You in Advance Ed Davis You don't need to reference a cell... VB can read the date from your system as needed using ...

Disabling macros is not an option!!
Hi folks Office 97 & NT4 I've been handed a bit of a poisened chalice & like a fool I've taken a here's the problem: Esentially I need to prohibit printing a file unless a small number of fields are completed. This was originally done in MS Word, but nothing stops the users from choosing 'Disable Macros' and printing out as many copies as they like. I've come across XML macros that cannot be disabled, so I think Excel is my only choice (yes?). What I'd like to do then is create a spreadsheet that contains some text fields, which are validated an...

macro applyfilter problem
GENERAL i use four comboboxes (keuzelijst met invoervak) to filter the query for a form; i choose a value from the first combobox ; then the the form should be udated and the 3 other comboboxes values are update to; PROBLEM the form is not updated? the comboxes are! selecting a value from the second combobox - nothing happens selecting again in the first combobox, but a different value from the first time - the form updates but uses the first value? i show all records use the first combobox again with yet another value the form updates with the first value? what is wrong? this is in a co...

Macro/VB coding question
I want a macro to work for a worksheet name which will always be the same directory and file name but the data inside worksheet will periodically change - increase in rows/decrease in rows. # of Columns/Column names will not change. I'm trying to filter for a non-changing set of info, then delete the results. Here's what I get if I record my current run: Workbooks.Open Filename:= _ "***Directory of location and file name here***" Rows("1:1").Select Selection.AutoFilter ActiveSheet.Range("$A$1:$S$746").AutoFilte...

How do I stop macro alerts for a spreadsheet with no macros in it
I have a spreadsheet that had a macro in it at one time but it has been deleted. However, whenever I open the spreadsheet I still receive the macro warning dialg box. How can I get rid of this? DKS044, You also have to remove the modules on which the macros were stored have a look here for details -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "DKS044" <DKS044@discussi...