I have a file called MyExcel.xlsx, which resides in C:\MyProject\List
I want to get the first empty row in MyExcel.xlsx, if possible, without opening the Excel File.
How is this getting done?
Thanks
I have a file called MyExcel.xlsx, which resides in C:\MyProject\List
I want to get the first empty row in MyExcel.xlsx, if possible, without opening the Excel File.
How is this getting done?
Thanks
Hello,
You can open the file in the background without notification or alerts even if its already open and close it in the background once empty row found. It will appear as if it was never opened. The code below will return the first empty row via message box. You can quote out the message box and use r.Row as the row number if needed.
Please Login or Register to view this content.
Last edited by playaller; 05-24-2014 at 11:29 PM.
Shelton A.
If Helpful, Add Reputaion!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks