Windows 7/Excel Compatibility problems

[variandick]

I have been told some people are having trouble running Excel VBA Macros with Windows 7. It doesn't seem reasonable but has anyone heard of any problems?

 

[Norie]

I'm using a laptop with Windows 7 and a dual core 64-bit processor.

I have no compatibility/version issues, though I originally thought I might.

 

[sandyacre]

So just wait for a fix from windows?

 

[nehpets12]

If I have 2 files open with the same name but differant file extentions windows 7 can not seem to find the differance between file types test.xls test.txt

this code works fine on other windows versions but not windows 7

Sub Macro1()

      Workbooks.OpenText Filename:= _
        "C:\Documents and Settings\My Documents\test.txt", Origin:=437, _
        StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(5, _
        1)), TrailingMinusNumbers:=True
    ActiveWorkbook.SaveAs Filename:= _
        "C:\Documents and Settings\My Documents\test.xls", FileFormat:= _
        xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False
    Workbooks.OpenText Filename:= _
        "C:\Documents and Settings\My Documents\test.txt", Origin:=437, _
        StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(6, _
        1)), TrailingMinusNumbers:=True
    Range("A1:A7").Select
    Selection.Copy
    Windows("test.xls").Activate
    Range("B1").Select
    ActiveSheet.Paste
    Range("A1").Select
End Sub

 

[Norie]

Stephen

Why not create references to the files when you open them?

Then you probably wouldn't need to worry about referring to them by name.

 

[Maverick0927]

Reaching Wits End...

Been using Windows 7 and Office 2007 since November and continually run into problems with using Excel. It seems that when I drag down a formula or value from the proceeding line the program stalls and won't save. It is then necessary to recover/restart the program having lost the work since the last good save.
I use the spreadsheet everyday to record share values.. Works some days - but doesn't others. Its driving me bonkers. Can't find a suitable avenue to report the fault either. Any help very welcome.
Maverick0927

 

[RoryA]

Do you have Office fully patched up to date? Are you running Windows Defender?

 

[Maverick0927]

Do you have Office fully patched up to date? Are you running Windows Defender?

Thank you for the response.

Yes, PC and Office 2007 fully patched and up to date.

No, I don't use Windowns Defender.

Maverick

 

[RoryA]

What antivirus do you use, and does it have an Office plug-in?
Also, have you tried running Office Diagnostics from Excel? (Resources section under Excel Options)

 

[Maverick0927]

I use Trend Micro Internet Security 2010. I don't know whether or not it has an Office plug-in.

No, not tried running diagnostics from Excel - wasn't aware of it.

Typically - tried my Excel this morning and all is fine - presumably something corrupts it at some point?

Maverick

 

[RoryA]

I couldn't say - I have no issues running Excel (2003, 2007 or 2010) on Windows 7.