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

gsdanger

Board Regular
Joined
Jul 12, 2010
Messages
88
Office Version
  1. 365
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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

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