Over 1 million tech questions and answers.

Copy Macros From Excel 2003 To Excel 2007

Q: Copy Macros From Excel 2003 To Excel 2007

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)

Preferred Solution: Copy Macros From Excel 2003 To 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: 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

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

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

Read other 8 answers

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

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

Read other 8 answers

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

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 ?

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

Read other 7 answers

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...


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

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
.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

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
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version
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

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

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

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?


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

Hey, I'm using Excel 2002 SP3. When trying to record a macro, I can copy from one cell but I cannot paste it to another....the "Paste" command is grayed out when either clicking Edit or right clicking the mouse. What is the correct method for doing a Paste while recording a macro?
Thanks, Vic

A:Copy and Paste in Excel Macros

Read other 6 answers

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

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

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

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

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

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...
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

Read other 3 answers

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

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
.Cells(1).Value = outputText
.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

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

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

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

Read other 3 answers

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
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

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?


A:Solved: excel 2003 macros

Read other 16 answers

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

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:


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

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

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

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.


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

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

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,

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

Read other 9 answers

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.


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

Read other 9 answers

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?


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

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


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

Read other 9 answers

I want to share an Excel spreadsheet, but how do I prevent a user from being able to cut/copy data in this spreadsheet? I protected the spreadsheet, but I am still able to copy all the contents and paste them onto a new spreadsheet (where the data is then freely editable), which kind of defeats the purpose of protecting the spreadsheet. Is there a box I should check to prevent a user from being able to cut/copy the contents of a spreadsheet? Is there a way to do this *without* VBA code?

A:How to prevent cut/copy in Excel 2003?

They can't cut or copy the data if they can't select it. In the "Protect Sheet" options, uncheck "Select locked cells" and "Select unlocked cells" and all that they can do is look at it and print it.

A creative person could still find a way to copy the contents though. They could "print" the worksheets to a PDF file using a program like PrimoPDF and then open the PDf file and copy the contents in Acrobat Reader.

Read other 2 answers

I converted a excel 207 file to 2003 and it changed in size from 6MB to 31MB. How do I find the key reasons for the massive size and how to reduce it?

A:Excel 2007 to 2003

It happens in both versions when saving a file created with the other version and it will occur for almost all files. Basically it's because the data within the file gets saved twice. Once in the original format in which it was saved, and then again in the format you are saving it to.

Read other 3 answers

I have designed a small program in both excel 2003 and 2007, both are set up identically, users can only enter data in 3 unlocked cells, all other cells on the sheets are locked, my problem is as follows

in the excel sheet 2007 the user can use the tab key, the enter key or the arrow keys to move between the 3 unlocked cells c1,c2,c3, if the user has entered data in c3 and then use's one of the above keys c1 is highlighted, but in excel 2003 the arrow keys and tab key works to move between c1,c2 and c3, but if thre user has entered data in c3 and press's the right arrow or tab key the excel sheet stops responding, the enter key doe's not work either

any idea's please

A:excel 2003 & 2007

Read other 13 answers

I am running Excel 2007 and have run into an annoying little issue relating to copying and pasting data either from one worksheet to another or one workbook to another. When I highlight my selection hit control C than go to another worksheet and hit control V -- about 90% of the time nothing is in the clipboard to paste -- and I have to go back to the original and hit control C again than go back and hit control V (second attempt always works) --- at first I thought I may have an error in my keyboard buttons but this never occurs in word or Access outlook or even this forum. I mentioned it is about 80% of the time I have tested a spreadsheet it always happens in, by moving it to another computer running 2007 and do not have a problem -- Any ideas, as mentioned I can get around it but it very aggravating.



Read other answers

Just lately my installation of MS Excel 2007 will only copy the values in the cells thus making it imposible to copy formulas. I have not, to my knowledge, made any changes to the installation. Is there an option that might have been changed by mistake making this the default for copying cells?

A:Excel 2007 will only copy values not formulas

Read other 6 answers

Cut, copy option is not working in Excel 2007 while using mouse

A:Cut, copy option is not working in Excel 2007

did you try keyboard shortcuts like ctrl c for copying & ctrl v for pasting ctrl x is cut and ctrl z is for undo ctrl y is for redo

Read other 1 answers

My situation is this:

I have 2 instances of Excel 2007 open, one with the worksheet to copy from, the other with the worksheet to copy to. I highlight the desired cell in the source workbook and copy to the destination workbook. Everything works fine for a number of runs. Then, the paste attempts only paste blank cells, without any error message.

You can continue to copy and paste within the worksheet, and in all other programs, but any copy and paste that spans the two instances of Excel will yield blank cells. Once I save the documents, even after a reboot to ensure clipboards are cleared, the problem still exists.

Any idea what could be causing this?

Read other answers


In Excel 2003, I am coping a tab with it's data into another tab.

I have attached an xls file, Main Tab (contains a form, I removed unnecessary data) and Copy Tab has a button that would copy the main tab (using vba code) into another tab.

I noticed the checkboxes id gets reassigned to a different checkboxes ids.
ie. main tab - checkbox id 1199, and after coping it changes to a diff id.

How do I make the checkboxes ids stay the same?. In my vba code I use the default (main tab) checkboxes ids to checkmark right checkbox.

I hope it makes sense what I am trying to accomplish.

Please advice,

Thank you

A:Solved: Excel 2003 copy tab Question

A workaround for this would be to rename the checkboxes in your code. In each of the copied sheets, they have been renamed to their defaults 'check box 3'
ActiveSheet.Shapes("Check Box 3").Name = "Check Box 1199"

Read other 3 answers

I have a shared 2003 excel spreadsheet that has sheets for each user to input data into on a daily basis. I then have a master sheet that I compile all the data onto. Usually i have to copy the data from each user sheet individually, and then paste it on the master sheet. From there I filter the data on the master and build reports from that data. And there lies the problem, it is very time consuming to do that on a bi-weekly basis.

What i'm seeking to do is have a formula to do that for me automatically or some way to compile that data quickly on the seperate sheet. All this data is in the same workbook. I need to be able to compile all the individual cells in column A of the user sheets, and paste them into column A of the master sheet(colum b from users to column b of master, etc), without adding cells together, or anything like that. Each individual cell in a column from each user sheet needs to be copied and have it's own cell of the same column of the master sheet. I have 15+ user sheets with two tables of data, and two masters for each table of data, that needs to be transferred over bi-weekly for reporting.

Anyone know a formula or process that could do this either automatically or quickly without having to manually copy and paste the data? I do not have access to VBA or the ability to install anything since this is a work computer.

A:Excel 2003 Data copy formula

Read other 6 answers

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

Hi - This is a problem occurring at work.

We use Windows XP and Office 2007 (although our managers are on Office 2010, they have also experienced this same issue). We use two monitors, so we can use two programs side by side. One fairly common use is to have two instances of Excel open, one on each monitor. We want to be able to copy a range of cells from one workbook to another. This sometimes works, but more often than not, on the second C&P action, the paste only selects the same range of cells, but pastes nothing.

I'm really hoping this question makes sense.

Can anyone suggest why this is happening? It is confusing in its inconsistency.

I can't think of any other technical information to provide, but if there is something extra that is needed to resolve this, please let me know and I will check when I get back to the office tomorrow morning.


A:Excel 2007 Copy & Paste between Workbooks Problem

Read other 11 answers


I'm running a Win7 32-bit system with Office 2003 installed, all latest patches are installed as well. I have these periodic (and very sporadic) errors when working in a spreadsheet or document where the application stops working when copying and pasting information between sheets, cells, documents etc. and the computer freezes up and I have to reboot. The error is "Microsoft Office has encountered an error and needs to close". This has become very frustrating when working on templates and losing large amounts of information. I haven't been able to find any troubleshooting tips pertaining to these issues and it is happening across 3 or 4 computers in our network now. These are new Dell Latitude E6410 laptops with clean installs on them.

Anyone have any ideas?


A:Excel/Word 2003 copy and paste crash

Have you ever sent an "error report" to MS? (I certainly never do, I'll admit.) I am curious as to what the error report generated would be - something to do with your anti-virus, perhaps?

Read other 3 answers