Excel 2007 upgrade to Office 365 - 2007 spreadsheet macros/VBA not working

gsdanger

Board Regular
Joined
Jul 12, 2010
Messages
83
Office Version
  1. 2019
Platform
  1. Windows
:confused: I have a fully functioning Excel 2007 spreadsheet with a few macros and VBA code utilised to achieve a result.
A couple of days ago, I bought a new laptop and also bought Office 365 to install.
I have done the installation of the Office application and now my macros/VBA are having difficulty running on the new Office 365 Excel platform.
What do I need to do to have my 2007 spreadsheet working in the new Excel app?

Please assist.

Regards...GSDANGER
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Further to my excel problem previously stated.
I am getting a "run-time error 52 Bad file name or number"

The following code is highlighted...

Public Function outputtext(text As String)
Dim MyFile As String, fnum As String
MyFile = ThisWorkbook.Path & "\temp.txt"
fnum = FreeFile()
Open MyFile For Output As fnum
Print #fnum , text
Close #fnum
End Function

The line in bold is where the code stops...
Does this assist in nutting out what I need to do? I hope so.

Regards...gsdanger
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,212
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top