Updating Older Excel Macro That No Longer Runs
Updating Older Excel Macro That No Longer Runs
(OP)
Our office has an older Excel VBA macro that has lost functionality.
The macro had full functionality in Excel 2007, then partial functionality in later versions. The macro has now completely stopped working in Excel 2013.
We no longer have access to the employee that originally developed the code, so we are looking for help. The Workbook is unlocked so we can get into the code; we just don't know how to fix.
Does anyone have tips on how to get this type of problem resolved? Are there freelance coders that specialize in things like this?
It seems like this might be a common problem. Maybe there are websites where people have posted how to resolve these compatibility type problems.
Any tips or points in the right direction would be appreciated.
Thanks in advance.
The macro had full functionality in Excel 2007, then partial functionality in later versions. The macro has now completely stopped working in Excel 2013.
We no longer have access to the employee that originally developed the code, so we are looking for help. The Workbook is unlocked so we can get into the code; we just don't know how to fix.
Does anyone have tips on how to get this type of problem resolved? Are there freelance coders that specialize in things like this?
It seems like this might be a common problem. Maybe there are websites where people have posted how to resolve these compatibility type problems.
Any tips or points in the right direction would be appreciated.
Thanks in advance.





RE: Updating Older Excel Macro That No Longer Runs
Plz post your macro or the workbook.
Plz point out on what statement you get a Debug error.
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
It is the Office bit level that is important, the Windows bits should make no difference.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
Sub Makedoc()
Application.ScreenUpdating = False
Set appWD = CreateObject("Word.Application")
appWD.Visible = True
appWD.Documents.Add
For x = 2 To 10
file = "C:\TEMP\temp" & x & ".prn"
appWD.Documents.Open Filename:=file
appWD.Selection.WholeStory
appWD.Selection.Copy
appWD.ActiveWindow.Close
appWD.Selection.Paste
Next x
It throws up the following error:
Run-time error '91':
Object variable or With block variable not set
and the debugger highlights the "appWD.Selection.Paste" line.
I have attached the spreadsheet as well.
Any help would be appreciated.
RE: Updating Older Excel Macro That No Longer Runs
Should have added that my system is clean and there are no 'gremlins'.
Dik
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
Dik
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
1. you output all your data into the .csv files
2. Open the "SYS K 5 YR" and the "Geopak System Format" spreadsheets and enable all macros
3. In the "SYS K 5 YR" you click load all data files and it populates all the tabs in that spreadsheet from the csv files
4. You click create temp files and it creates the .prn files
5. Final step, which is where it is bogging down, you click print system and it is suppose to combine all the .prn files into one word document and format that document
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
Can you tell me the file name and/or the location where the *.doc file is stored? I cannot locate it, if it is created. When I enter all three buttons, nothing appears to happen.
Dik
RE: Updating Older Excel Macro That No Longer Runs
RE: Updating Older Excel Macro That No Longer Runs
Dik
RE: Updating Older Excel Macro That No Longer Runs
I don't think that Open Office will be able to run the Excel/Word macro as-is.
https://wiki.openoffice.org/wiki/Documentation/FAQ...
www.nxjournaling.com