Open excel file using access vba

Excel Resource. Sheets 1. Sheets "Main". Range "C2" End sub. Premium Project Management Templates. About the Author: PNRao. Related Posts. Hide Developer Tab in Excel Ribbon. October 8th, 0 Comments. Show or Hide Unload a userform. October 2nd, 1 Comment.

April 12th, 2 Comments. Workbook Dim ws As Excel. Cells i, "C". Save 'Clean up xl. Sergey S. Thanks again Sergey!! This works perfectly with only one minor change. Open strInputFile. No big deal but wanted to mention it for potential future viewers of this post. I also clicked the up arrow of this answer but since I am brand new to this site apparently my votes don't count yet. Yes, of course needed here, I edited the answer.

If answer worked for you, accept it, a green check mark will appear below the vote counter — Sergey S. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. InvokeVerb "Open" End Sub. Was this reply helpful?

Yes No. Sorry this didn't help. Thanks for your feedback. The Application. FollowHyperlink selectedFile works but I need to now select the first 4 rows of my now open workbook to delete those rows and move them up. Windows 1. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question 9. Report abuse. Details required :. Cancel Submit. Sandro Peruz. Ciao, Sandro.