Search results for query: *

John, Renaming the Excel.xlb file worked! Thanks so much. I truly appreciate the quick feedback. Enjoy the star! Kevin.

Tek-tippers, I am having a slight problem in Excel 2000, and I need your help. Somehow, last week, the Worksheet Menu Bar (i.e. File, Edit, View) disappeared from my Excel profile. To fix, I did the typical: Tools > Customize > Toolbars > scrolled to the bottom, and Worksheet Menu Bar was no...

Ramzi and PVW, Thank you for the tips, the error was contained in the path name. I was missing one letter!! ugh!! I checked prior to posting and didn't catch it. Thanks for the quick responses. Kevin.

I am currently attemping to save a file (save or overwrite if there is an existing file in this directory) to a specified path via this code: fname = "L:\GlobalscSh\Data Standards Documentation\GSC QA\" & ThisWorkbook.Name Application.DisplayAlerts = False ThisWorkbook.SaveAs...

Nevermind, I figured it out: I forgot to add a function to call the sub procedure: Function Call_RunExcel() RunExcel End Function Now it works... kevin v.

Everyone, Currently I am attempting to open a designated excel workbook, execute a macro contained in that workbook, then save and close the workbook via VBA in Access. This is the code I currently have: Public Sub RunExcel() Dim objExcel As New Excel.Application Dim objExcelDoc As Object...