When you opened the excel file other man saved, have you thought “Why didn’t he move cursor to A1 cell” before ? Not to be thought so, conversely, I will introduce the way to move cursor in all sheets to top left, move scroll bars in all sheets to top left and activate first sheet.
Here’s the way to connect to the database from Excel VBA. (Excel から VBA を使わずにデータを取得・表示する方法もあります。 例: Windows, Excel: データベースから直接値を取得して表示する)
This is the code I frequently use.
It recursively exports file list in a directory on Microsoft Office Application, like Excel. It is written in VBA.
VBA can be written in object oriented way, but I didn’t because I had to write the code as soon as possible.
- A user clicks the button on the sheet.
- The program show a folder browsing dialog.
- User chooses the folder, then the program make the list of file in the folder.
- The program exports the file list onto a form (or sheet).
- Create a module file and create the following functions.
- get file list
- handle folder browsing dialog
- Create a dialog to show the result.
- Create a button on the sheet and add function on clicking.