Over 1 million tech questions and answers.

Solved: Problem with Excel 2003 macros in Excel 2007

Q: Solved: Problem with Excel 2003 macros in Excel 2007

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks

RELEVANCY SCORE 200
Preferred Solution: Solved: Problem with Excel 2003 macros in Excel 2007

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Problem with Excel 2003 macros in Excel 2007

Read other 8 answers
RELEVANCY SCORE 125.2

Hi can anybody tell me hoe to copy macros from excel 2003 to excel 2007?
The excel 2003 is running under windows xp and the 2007 under windows vista.
(The two versions of excel are installed at differnt computers)

A:Copy Macros From Excel 2003 To Excel 2007

I don't know Excel 2007 nor Vista.
But the usual way to copy macros brute force would be to open the VBA toolbar, get into the Modules, select each, and Export one by one. Then import into 2007 modules if Excel 2007 VBA permits that.
If export/import doesn't work, you can always copy out the entire text into Notepad text files, and copy/paste from the Notepad into your 2007 Excel.
If the VBA language or object model has changed between 2000 or 2003 and 2007, then some tweaking might be in order, but I suspect they left it alone, and the error messages, if any, might suggest what to fix.

Since these are different computers, either network them and share some common directory, or use USB flash drive for transfers of the, say, Notepad files.

Export is good, because it names the modules. They get saved someplace in your local settings. Notepad will not name, and doesn't matter really.

Read other 3 answers
RELEVANCY SCORE 122.8

Hi all

I can provide the code if necessary, but this issue is really confusing me, and seems to be more to do with the differences between how excel 2007 saves files.

I have written a dozen macros in VBA (Excel 2003) and recently upgraded to 2007. When in run the macros
in 2007, they run fine.

HOWEVER - when someone who is still on Excel 2003 uses the files after me, they get error messages, even though the code was written for 2003, and is completely unchanged.

Compile Error : Cant Find Project or Library

the Debugger then highlights the following line of code

Dim currentDate as Date
currentDate = Date (the Date section is where I am getting the error)

That line of code works in Excel 2003, if the file has not been saved by Excel 2007.

Anyone have any ideas?

At this I am considering downgrading my Excel back to 2003 version.

Any help would be appreciated
Thanks & Regards
Patrick
 

A:Solved: Bizarre Issue // Excel 2003 & 2007 Macros

Read other 8 answers
RELEVANCY SCORE 120.4

I have a report that contains macros to update all the information that is put in. It is in excel 97 and my business just recently updated to 2003 and now I get a compile error when I run the reports. How can I fix this error?
 

A:Solved: convert excel 97 macros to excel 2003 macros

Read other 8 answers
RELEVANCY SCORE 107.6

Running Windows Vista Premium Home Edition.

I have an Excel 2003 spreadsheet.that I originally created on Excel Office Professional Edition 2003. Also, have Excel 2007 Home and Student Edition installed. I uninstalled the Excel 2003 software, but now when I clik on this created Excel 2003 spreadsheet with Excel 2003 it will not open. It says there is an invalid path. I reinstalled Excel 2003 and it opens. I tried to save this as an .xlsx extension and then uninstalled Excel 2003. It wouldn't open. So something is occurring here. On other Excel 2003 created spreadsheets, they open without issue.

Then I have a program with an .exe extension. It needs to open using Excel 2007. With both Excel 2003 and Excel 2007, it will not open. It freezes and then I get an error message saying it cannot open with another Excel other than 2007. If I right clik on the .exe program, there is no "Open with". I even tried opening a blank Excel 2007 spreadsheet and then cliking on "Open". but it is a bunch of gibberish. My IT person says you can't open the program that way, You have to launch it as an .exe program using Excel 2007.

Any ideas on what is going on? By the way, I have both Excel versions on my laptop running Windows XP and I do not have these issues at all.
 

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...

http://officearticles.com/misc/best_install_procedures_for_microsoft_office.htm

Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc... Read more

Read other 2 answers
RELEVANCY SCORE 107.2

Iím using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.NewSearch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

A:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

Read other 7 answers
RELEVANCY SCORE 106.8

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
Application.Quit
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled
 

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers
RELEVANCY SCORE 105.2

i am using macros to create charts on a 2nd sheet. i need to make 3 total and then move them to the right spot. the first two go without any issues however, the 3rd doesnt move or risize like it should. it seems like the problem is because i use the mouse to move the chart and the screen scrolls down. also, is there a way to assign the chart title with a block from the spreadsheet?

thanks
 

A:Solved: excel 2003 macros

Read other 16 answers
RELEVANCY SCORE 104.4

Hey Guys!

Using "record macro", i created a small table, with different fields that i use to fill information in. On my work sheet, every time i need to fill in information, i run my recorded macro, and it inserts a table where i need it to be, very handy.
What i can't figure out is, how to put a number in that table, that would automatically increase, every time i run this macros and insert a new table?
Let's say, i have a "100-05-00" number in cell A1. my table ranges from B1 to X10. So when i run my macro and insert the next table at B11, how can i have A11 automatically change to "100-05-01", and so on?

Appreciate any help!
 

A:Solved: Autonumbering in Macros, Excel 2007

Read other 16 answers
RELEVANCY SCORE 104

ok here goes nothing.... i'm a big noob at excel macros and i shurelly would need a little help.. i have a table (it has like 40-50 collmns amd 2000-3000 rows).... on D collumn i have a lot of names (like 20)...

i need a macro that splits my original excel table (or only that sheet) in 20 smaller tables (or sheets) and the criteria should be the names from that collumn

the names from that collumn are not in any order.... so bassiclly i could sort the table by name (starting with that collumn) and this can be done using a macro (i can record one while i push the button ) but how do i split my table in 20 different tables???

if anyone wold like to help me i'ld much apreciate it

thank you
 

A:Solved: macros in office excel 2003 sp3

Read other 16 answers
RELEVANCY SCORE 104

Is there a way to clear, and add Fill color to an Excel spreadsheet? Please see the attached file.

I need this to be compatible with Excel 2003 & 2007.
 

A:Solved: Excel 2007 & Excel 2003

Read other 16 answers
RELEVANCY SCORE 102

I am having a problem in Excel 2007 opening an Excel-2003 created workbook that contains links to other workbooks. I have no problem in Excel 2003 opening this file with the "Don't Update" option - the value of the formula displays even though the other workbooks are not accessible.

In Excel 2007, when opening this file it prompts that the workbook contains links that cannot be updated. Selecting the first option of the prompt "Continue" retains the workbook references in the cells and displays the "#VALUE" error message. If I click on one of those error cells, the smart tag show the message "A value used in the formula is of the wrong data type." The cell type is numeric and the cell contents should be numeric.

The second option when opening is "Edit Links". According to Microsoft, breaking the link to these other sources should replace the formula with the formula value. My does not do that.

Neither option works for me. I've tried adjusting the error checking and update options under "Excel options". I've tried copy & paste special w/ values with the referencing cells. I've tried changing the cell format. Nothing seems to allow me to open the 2003 workbook in Excel 2007 and see the values of cell that reference an inaccessible workbook.
 

A:Solved: Excel 2007 Link Problem to 2003 Worksheet

Can you upload a sample spreadsheet?
 

Read other 2 answers
RELEVANCY SCORE 100.8

I want to create a shortcut to run Excel from the command line and in that command or batch be able to run a macro from the workbook in my XLSTART folder. This way, the user does not have to run the macro from Excel menus.

I also want to create a shortcut to run Word from the command line or batch to run a macro (a global macro) when Word opens. Again, the user does not have to get inside Word to select a macro from the menus.

I have searched the internet and found that neither program has command line switches to immediately run a macro at the Office program start up.

Thanks
 

A:Solved: Run Excel and Word Macros From Command Line Office 2007

Read other 9 answers
RELEVANCY SCORE 98.8

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?

Leanne
 

A:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?

 

Read other 3 answers
RELEVANCY SCORE 98

Hi,
I transferred all my old Excel (2003 and before) files to my new notebook which has Vista HP and Excel 2007. I open an old Excel file and it looks OK but when printing or print previewing, every line appears double-spaced and the document runs over to a second page.
If I change the row height it prints the squeezed up text but still double-spaces. If I copy the whole content of the spreadsheet into a new blank spreadsheet it prints normally.
Is there any setting in Excel 2007 that I might have missed ?
Thanks.
RB
 

A:Printing Excel 2003 files with Excel 2007 give double spacing

Read other 7 answers
RELEVANCY SCORE 96.8

When I open a spreadsheet in Excel 2003 that was created in Excel 97, the pages with macros open with only the columns showing. It looks as if the row that appears has an infinate length. I've tried changing the row hieght, and everything else I can think of, but can't view the spreadsheet normally. Other tabs in the spreadsheet do not appear either.
 

A:Solved: excel 97 display problem in excel 2003

Read other 10 answers
RELEVANCY SCORE 96.8

I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The interesting thing is that if I try to open the same file that I have saved within the last year (before I got 2007) then I can do it? That is, I have a cache folder of files that I go get to do calculations then save in a new job folder. The ones in the new job folder will open (also 2003), but the ones in the original cache will not? I would truly appreciate any suggestions. Thank you.

A:Can't open 2003 Excel Files in Excel 2007?

Have you attempted to set them up in 'Compatibility Mode." Not sure if this will help, just hoping it will. I have been testing the new Microsoft Office 2010 Beta 64 bit, and have yet to have this problem, and like you I have a great deal of files in 2003 (never used 2007)'

I think you can still download MS Office 2010 beta from Microsoft's download site. Good Luck.

BTW, Welcome To The Seven Forums.

Read other 9 answers
RELEVANCY SCORE 96.8

Does anyone know how to run Excel 2003 print macro on Excel 2007 or higher? When I tried running my 2003 macro, the VBA editor pops up w dialogue box, " Run-time error '1004': Method 'ActivePrinter' of object'_Application' failed ".

This is my code: Application.ActivePrinter = "Epson LQ-300 ESC/P 2 on USB003"

Can anyone help?

Thanks!
 

A:How to run Excel 2003 print macro on Excel 2007?

Welcome to TSG hope we can help you and you can help others.

I'm not an Excel macro guy but you code looks reasonable. What happens if you run this. I suspect printer name is a little off.

MsgBox "The name of the active printer is " & Application.ActivePrinter
 

Read other 1 answers
RELEVANCY SCORE 96.8

I purchased Excel 2007 to take advantage of the larger number of rows and columns. My SS applications are very large and I run out of columns. But after trying my Excel 2003 in the new 2007 software, I find that 2007 runs 10-20 times slower, making it completely unusable. Googling the problem shows it's a widespread issue. MS help desk essentially no help. Any suggestions?
 

A:Excel 2007 Runs MUCH Slower than Excel 2003

The biggest thing that slows Excel 2007 is also what you wanted it for - the greater number of cells. If your formulas have cell references like A:A or $1:$1, then that is a lot more cell references for it to process.
Read this http://msdn2.microsoft.com/en-us/library/aa730921.aspx and maybe you will get some ideas on how to make your files process faster.
 

Read other 2 answers
RELEVANCY SCORE 96

I received the following from a user creating and saving macros in her personal macro workbook. I have been unable to duplicate the problem when creating macros in my Excel program, but when I copy her macros into my own personal macro workbook folder, I then have the same problem:

"I use macros in Excel, and have somehow created multiple templates because Excel asks me to create a new template every time I record a new macro. I recorded the latest macro yesterday. Now whenever I launch a new file in Excel, it goes through a series of steps where it shows each of my 3 personal templates opening, and then I don't even get a new blank file of Excel open, and I have to hit new file."

I have googled this and didn't find anything like this - may not have used good search terms. Anyone have an idea what may be going on here?
 

A:Excel 2007 Macros

Read other 7 answers
RELEVANCY SCORE 95.6

I would like a macro that will compare Accounting system data and Bank statement data. I am comparing the date and amount for an exact match. If there isn't a match, I need the macro to list the exceptions. I am using Windows XP.
 

A:Using Macros in Excel 2003

Read other 10 answers
RELEVANCY SCORE 94.8

Hi there.

I'm trying to open an Excel 2007 document with Excel 2003. I thought that I had downloaded what I needed to be able to do that, but I guess not. Is there a way to do this? I suppose I could upgrade to newer version if I need to. If so, should I go ahead and get the newest version and get it over with?

Thanks for your help and time. Have a good day.
 

A:Open an Excel 2007 doc with Excel 2003?

Have you tried the office 2003 compatibility pack https://www.microsoft.com/en-us/download/details.aspx?id=3
 

Read other 5 answers
RELEVANCY SCORE 94.8

Why does the second line of the code shown below produce an error in Excel 2007 and not in Excel 2003? The error is:
Run Time Error Ď1004í, Unable to set the Text Property of the Characters class

ActiveSheet.Shapes("btnJobSummary").Select
Selection.Characters.Text = "Prepare Job Summary" & Chr(10) & "for " & CurrentJob

CurrentJob is defined as: Public CurrentJob As String

In this case it equals: RockMont Rev 7-9-04

No problem at all in Excel 2003 and earlier. If CurrentJob is something shorter (e.g. MyFile), there is no error. I don't think the spaces are a problem either because I still got the error after adding Chr(34) before and after CurrentJob in my code. Any ideas? Thank you.
 

A:Error in Excel 2007 but not in Excel 2003

Hello, welcome to the board!

The text is too long. Use an ActiveX control instead of a Forms control. Then you can use similar code...
Code:
Public Const strCurrentJob As String = "RockMont Rev 7-9-04"
Dim btn As CommandButton

Sub FooTest()
Set btn = Sheet1.CommandButton1
btn.Caption = "Prepare Job Summary" & Chr(10) & "for " & strCurrentJob
End Sub
HTH
 

Read other 3 answers
RELEVANCY SCORE 94.8

Does anyone know the best way to setup a Macro in Excel 2007 that will work in Excel 2003 as well?

I have an Excel 2007 workbook that I am using a macro to change the "Fill Color" and "Font Color" of cells. However, I will get everything working in Excel 2007, but when I open the workook in Excel 2003 I get many debug errors.

If I change the code in Excel 2003, and then re-open in Excel 2007 I get debug errors.

There must be a way to setup teh workbook to work on both Excel 2007 & 2003.
 

Read other answers
RELEVANCY SCORE 94.8

Based on what I learned using Oulook 2007, in Excel 2007, I created a list of macros in a Module1 which each one adds certain words or points to any number of cells I select. I created a Module2 which identifies all the macros of Module1, and in Userform1, it is connected to Module2 to show the macros.
But when I run the Userfomr1, it shows the Commbobox of Macro Names, and when I select the macro and click on the commandbutton in the Userform1, it does not run the macro.
This did it in Outlook 2007...so what do I change to these codes so it works in Excel please?
MOdule 1

Sub End_Cell_Colen()
Set yrange = Selection.Cells

For Each cl In yrange

If Len(cl.Formula) = 0 Then
Else: cl.Value = cl.Formula & """"
End If
Next cl
End Sub
Sub Front_Cell_Colen()
Set yrange = Selection.Cells

For Each cl In yrange

If Len(cl.Formula) = 0 Then
Else: cl.Value = """" & cl.Formula
End If
Next cl
End Sub

Sub JoinAndMerge()
Dim outputText As String
Dim inputRange As Variant
Const delim = " "

On Error Resume Next

For Each cell In Selection
outputText = outputText & cell.Value & delim
Next cell
With Selection
.Clear
.Cells(1).Value = outputText
.Merge
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.WrapText = True
End With
End Sub

Sub EndCellSemmiColen()
Set yrange = Selection.Cells

For Each cl In yrange

If Len(cl.Formula) = 0 Then
Else: cl.Value = cl.Formula & ";"
End If
Next cl
End Sub
S... Read more

A:Excel 2007 CommboBox With Macros

Read other 16 answers
RELEVANCY SCORE 94.8

I am in the process of trying to write a macro that includes inserting pictures on the spreadsheet in a specific place with a specific size depending upon specific things happening. I tried recording a macro in Excel 2007 to start the ball rolling, but it won't record anything to do with the pictures. I went back to Excel 2003 and did it successfully, and then copied the macro over to 2007 and it ran fine. What the heck? Does anybody know if this is an inherent problem with Excel 2007? What's going on?

Thank you

A:Recording Macros In Excel 2007

What are you trying to do, exactly?

Read other 4 answers
RELEVANCY SCORE 94.8

I am using Win7 MS Office 2007(Home/Student). I have activated the developer in Excel but the record macros option is greyed out - is this a problem with this version of Excel?
 

Read other answers
RELEVANCY SCORE 94.8

Hi Everyone, I am new here so hope I get right.
On using Excel 2007 I encountered a problem, hyperlinks did not work. I asked help from a different forum to this and it was suggested to go through the microsoft fix it, it worked and hyoerliks were activated, but now the programm is ever so slow while calculating cells, I have to admit that I do ask quite a bit from it but it never took so long, i estimated its taking about 3 to 4 minutes to calculate cells and this after disabling the auto calculation.

Can anyone help please.

Thank you
 

A:Problem with Excel 2007 - 2003

few neat tricks on here http://www.decisionmodels.com/
 

Read other 1 answers
RELEVANCY SCORE 94.4

Can I ask for help in a similar vein to last post, I have another CSV file thatís down loaded
where text is in column D and I want to enter equivalent in column E as below which is used to build a pivot table on column E headings in correct order to match input journals, again varying number of rows each time file extracted.

Change formula to below for each type
D E
Layaway Part Payme to 9Layaway Part Payme
Gift Voucher sale to 8Gift Voucher sale
Sales without VAT to zSales without VAT
Visa / Mastercard to 1Visa / Mastercard
Cash to 1xCash
Layaway Part Payment Clearing to 3Layaway Part Payment Clearing
Gift Voucher Redemption to 4Gift Voucher Redemption
Credit note redeemed to 5Credit note redeemed
Till Differences to 6Till Differences
Cash to 1Cash
POS Payment/Outpayment. to 8POS Payment/Outpayment.
prod Sales to Zprod Sales
 

A:loops in macros Excel 2003

Again my question: what do the numbers stand for under what I imagine should be E?
 

Read other 1 answers
RELEVANCY SCORE 94.4

OK it's not my fault I am working on XP with Office 2003 (you never know work may catch up with the rest of the world one day!)

I am trying to pull a macro together for our sections watchlist so when someone enters "L" into a cell it will automatically shade it blue, "C" will shade it a different colour and so on and so forth. I have tried using conditional formatting but that only gives me the option of setting 3 conditions (4 if you count the default blank lol)

As it is I have 12 different options with 12 different colours to denote Leave, Courses, Duties, Sick etc, etc

Can anyone help. I have played about with the Macro recorder but it has confused me to the point of getting a headache and resorting to asking for help.
 

A:Excel 2003 Macros help needed!

does this help at all
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90
 

Read other 3 answers
RELEVANCY SCORE 94

I've recorded and combined a few macros into one and - while it is really large - I never thought anything of it until I got the following error while trying to run it:

"Compile Error
Procedure too large"

I can certainly split these up into separate procedures, but it would save time to have them all as one. Is there a way to override this error?

I am using Windows XP w/ SP2 and Excel 2003.

Thanks in advance for any help.
 

A:Solved: Excel Macros too large problem

It is probably quite possible that you can considerably reduce the size of the Macro by rewriting it. Recorded Macros are notorious for having superfluous code in them.
If you post it I am sure that one of the Excel gurus can rewrite it for you, or at least point you in right direction.
 

Read other 3 answers
RELEVANCY SCORE 94

Hi all,

I am new to the forum and to troubleshooting computer issues, but this one is driving me insane. I have noticed that my desktop is very slow at running Excel 2007 macros, when I believe that it should not be. I decided to do a test, and run it on my machine and then on my friend's machine.

The test the following: I run a loop of 100,000 iterations of putting the i'th number on the i'th row, and time it. Here are my results (in the first column) and my friend's in the second:

1.___3.84___6.14
2.___3.80___6.14
3.___3.82___6.14
4.___4.57___6.14
5.___5.93___6.12
6.___7.77___7.15
7.___10.23__6.09
8.___10.90__6.14
9.___11.83__6.46
10.__12.58__6.17
11.__13.17
12.__13.90
13.__14.03
14.__14.73
15.__14.09
16.__14.09
17.__14.08
18.__14.12
19.__14.14
20.__14.05


Can anyone explain why mine starts out so quickly (the speed I expect, given the computer specs) and climbs to 14 seconds and hangs out there?

The real issue is that I'm writing code that should normally take on the order of 15-20 minutes to run through all the operations, but instead is taking 2-3 hours. Running several iterations of that is extremely slow and time-consuming.

Here is the code that I used. I don't think that it's relevant, as the exact same code generated the two sets of results on the two computers, but here it is anyway:

Private Sub CommandButton1_Click()
Dim time1, time2, time3
Dim i, n As Integer

For n = 1 To 20
time1... Read more

Read other answers
RELEVANCY SCORE 93.6

Thanks for taking a look at my issue. I new to the boards but not new to the IT industry.

I have a user running Windows XP on a desktop and until recently he had Office 2003 loaded. I've done an email (exchange) upgrade migration that required me to upgrade his 2003 to 2007. I uninstalled 2003 completely and then loaded 2007 fresh. In the new 2007 Excel, when I open a document created in 2003 (a .xls) everything looks great except for a few subtle differences that I can deal with. The problem is when I try to print or even do a print preview, some of the cells in the workbook shift to a different location further down the page. I have loaded the Office file converter program and saved the .xls to a .xlsx with no change. I am able to open the same file on my Win7/Excel 2007 desktop and it previews and prints as it should.

Any ideas?

Thanks,
IslandHopper
 

A:Excel 2003/2007 Printing Problem

Hi, welcome to the forum,
Sounds strange, there is no difference except maybe that you have chosen a special font?
Have you checked your printer settings?
 

Read other 2 answers
RELEVANCY SCORE 92.8

I am at my wits end. I have been creating an addin for Excel 2007. I am using the Custom UI editor. Everything was working ok until yesterday. Then none of the new macros that I added would run. I would get the following message.

"Cannot run the macro 'RibbonXOnAction'. The macro may not be available in this workbook or all macros may be disabled."

All my security settings are wide open. I have searched the web high and low and cannot find a solution to this issue. Please help me.

Thanks
Gregg
 

A:All Ribbon Macros quit functioning in Excel 2007

Hi there, welcome to the board!

Is this something you can post, so we can take a look at it and test it? If sensitive material, we can find alternatives. Can you post your code, both VBA and XML? Can you describe to us how your VBA code is setup? Have you tried it on another machine? With this very little information I'm going to take a stab in the dark and point the finger at your XML, it's very touchy, and just one wrong character could render your project unusable (i.e. the error you're receiving). Since we have no idea what you're using your RibbonXOnAction for, we can't really help at all. The more you post, the better we can help you. Please, be very, very specific.
 

Read other 1 answers
RELEVANCY SCORE 92.8

Help needed please? I just installed Office 2007 over Office 2002 Running XP win PRO. the Macros in one main column in my workbook (the onlu Macros in that book) that was working perfectly 10 min ago won't work???
All the Dropdowns I installed are there with there Lists and working perfectly! But the one Column with VBA which is activated by these Dropdown's wont work since I installed 2007 and yes I have vallidated it etc! It is NOT a Pirated edition. Can somone help please Dasha
 

Read other answers
RELEVANCY SCORE 92.4

Hi all,

I've got a series of Excel 2003 spreadsheets with macros. They run just fine on a Windows XP machine. However, we recently moved them to a Windows 7 Pro machine. We still run them in Excel 2003, only now on a Windows 7 system. Problem is, they don't run right. No errors, but the one that is giving me grief needs to read from a csv text file. I don't thinki it is opening and/or reading the input fule. I don't understand why.
Like I said, everything runs OK on WinXPSP3. I think I have all of the permissions set correctly. UAC is turned off and Elevated priveleges is turned off as well.

Anyone have any ideas?

Thanks in advance.

A:Excel 2003 Macros do not run correctly on a Windows 7 system.

Hi Honu425

According to Windows 7 Compatibility Centre, it is compatible with Excel 2003 with Service Pack 3. Do you have Office Excel SP3 installed?

http://www.microsoft.com/windows/compatibility/Windows-7/en-us/Details.aspx?type=Software&p=Microsoft%20Office%20Excel%202003%20Service%20Pack%203&v=Microsoft&uid= 11&l=en&pf=1π=6&s=office%20frontpage%202003&os=32-bit

Read other 1 answers
RELEVANCY SCORE 92

Hi People!

I need help fast! I have a table as shown;

Date TC1 TC2 TC3 TC4 TC5 Min LOC Max LOC
4/12/12 9.3 9.5 9.1 8.3 9.0
4/13/12 9.5 9.9 9.3 7.3 8.0
4/14/12 9.3 8.3 7.1 9.3 9.0
4/15/12 7.3 9.0 9.7 8.3 8.0

What I need:
I need to find the location (LOC) for the occurrence of the Max & Min value in each row.

Question:
Is there a way in Excel 2003 or 2007 where I can obtain the top header title for each occurrence?
If there are multiple occurrences at the same row; can I get them too?
 

A:Solved: How to get an occurrence location in Excel 2003/2007

Read other 11 answers
RELEVANCY SCORE 92

Hello. I'm having an issue with formulas not working in Excel 2003. I've created a spreadsheet with about 1200 rows in Excel 2007. There are two tabs, one contains all the data, and the other has my working formulas. When I save, I make sure that I save with compatibility to 1997-2003. This works fine when I initially open the spreadsheet in Excel 2003, but if I filter any one column once, my formulas on a separate tab all change to #NAME?

Is there something I can do to keep this from happening?

Mario
 

A:Solved: Losing Formulas from Excel 2007 to 2003

Read other 8 answers
RELEVANCY SCORE 91.6

Please can someone help me.I manage a band and we have a database of 3,000 contacts. The headings are name,location,email, website. I wanted to put all this into my contacts sheet so that rather than getting a mailing list program I'll just use outlook and distribution lists. I was going to set up different address books for each location. i.e USA.

A box saying you have not named the ranges keeps coming up. Honestly i dont have a clue and could really do with a step by step, baring in mind i know nothing.

Problem is that it wont import from Excel into Outlook. Im getting desperate now their album is out in February and i have not used the direct mailing yet.

I cant find a step by step idiots guide to doing this anywhere.

Can someone help there is a free album in it if you can lol

Please help.
 

Read other answers
RELEVANCY SCORE 91.6

Anyone know what's up with this, or how to solve it?

We've got a script written for Excel 2003, that seems to be working, but we need it to work in 2007... and it's not!!!

This makes no sense (except that it is on a Microsoft produce and should have been expected,... ).

Has anyone else had this issue, and solved it?

Can you share that solution please?

(I'm trying to find a Excel 2003 machine right now, but still trying to save time by getting this to work on the hardware in place...)

Much thanks,
J.
 

A:Excel 2003 VBA vs. Excel 2007 VBA...

Read other 9 answers
RELEVANCY SCORE 88.4

I am trying to create a code that will autofilter data on an Excel worksheet. The code works fine to filter the data, but it does not hide the AutoFilter Arrows.

Below is the code I am using. What (if anything) is wrong with the code below?
Code:

ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>", Visibledropdown:=False
 

A:Solved: Excel 2007 Macro -> Hide Excel AutoFilter Arrows

I noticed that the code above (in Post #1) that the AutoFilter Arrows were beinf truned off on Field 2, but none of the others.

I have played around, and done some research to come up with the code below:
Code:

Dim c As Range

For Each c In ActiveSheet.Range("A1:D1")
ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>"
c.AutoFilter Field:=c.Column, Visibledropdown:=False
Next

Does anyone have a better solution?
 

Read other 1 answers
RELEVANCY SCORE 88

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers
RELEVANCY SCORE 86.8

Created a worksheet with formulas, in Excel 97, and saved it on floppy and hard drive. Can open worksheet from floppy and hard drive in Excel 97 but not Excel 2003. Formula cells become #NAME?

Sample of formula:
='C:\blp\api\dde\Blp.xla'!BLP(C190&" equity","ask",,,RTD("BLOOMBERG.RTD","","IZU+UV Equity","ASK"))

How can I resolve? Thanks.
 

A:Solved: Can't Open Excel 97 File in Excel 2003

Read other 7 answers
RELEVANCY SCORE 86

Hey all,

Does anyone know if it's possible to convert macros from Excel 97 (Excel Basic) to Excel XP/2002 (Visual Basic) ? Or do I have to do these manually?

Any help is appreciated

Thanks!
 

A:Help!! Convert Excel 97 Macros to Excel XP (2002) ???

Read other 9 answers
RELEVANCY SCORE 85.6

When I bought my newest computer, it had MS Office 2007 installed.
My data from Excel 2000 was backed up and downloaded to my new computer.
The company I bought my new computer from transferred all my data for me.
Problem is:
all the old Excel data is still coming up as Excel 2000.
Question:
Is there a way to convert the old data to Excel 2007?
Business workbook has much much data that I need to get ready for a new year soon and I'd like to use the Excel 2007 for this?
Thank you for your help.
 

A:Solved: Excel 2000 to Excel 2007

After you have opened an Excel 2000 file, do a 'Save As' to the new 2007 format.

lol
Hew
 

Read other 2 answers
RELEVANCY SCORE 84.4

I created a macro but cant seem to figure out a few different things
First open the file named SPL1275-3A, next open the files called HLC M, then run the macro. as you can see the macro works fine for this file but when the file does not contain the same number of station the macro continues to loop because its looking for a station that is not used, for example try it on the file SPL1275-3B which is the same file exept it has 1 less station.

Can any body help!!!
 

A:Solved: Excel macros

Hi

Your macro script have loops for each and every block of data you want to process. That is you have created 10 loops for 10 blocks of data. The file "SPL1275-3A" runs OK because it has 10 blocks. File "SPL1275-3B" failes to complete the loop because the it runs the 9th loop find the END character.

To solve it, you can change the whole of the macro to only run the number of times the character END character appears and use only one loop to do that.

or otherwise use the function below to count the number of rows in the sheet you are processing and then terminate when you reach that row number.
Function GetLastCell(ws As Worksheet) As Range
Dim LastRow&, LastCol%
' Error-handling is here in case there is not any
' data in the worksheet
On Error Resume Next
With ws
' Find the last real row
LastRow& = .Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByRows).Row
' Find the last real column
LastCol% = .Cells.Find(What:="*", _
SearchDirection:=xlPrevious, _
SearchOrder:=xlByColumns).Column
End With
Set GetLastCell = ws.Cells(LastRow&, LastCol%)
End Function

Enjoy!!

Your Question:
"I created a macro but cant seem to figure out a few different things
First open the file named SPL1275-3A, next open the files called HLC M, then run the macro. as you can see the macro works fine for this file but when the file does not contain the same number of station the macro continues to loop ... Read more

Read other 2 answers