I do have one more question though. I have written some code that goes through all of the word files in a specified folder. It opens them and then renames them. Most of the files it opens and changes them just fine, but when on some of them it prompts me to convert them to rtf files and then it will open them, is there anyway to automatically have vb click ok for me when the box pulls up?
What's the difference betweening Dimming the variable as an Excel application and creating an object?
Sub OpenMyFile()
Dim xl As New Excel.Application
xl.Application.Workbooks.Open "H:\MRP Project\F99-Misc & Sleeves.xls" 'opens your excel file
xl.Application.Visible = True ' Shows excel application
Set xl = Nothing
End Sub
Rib
I know a little about nothing and even less about everything.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.