Import data from external file
Hey!
I want a little help.
I have a spreadsheet where I want to lay a button. Click-VB script I need, which does the following:
Open a DialogBox with an Excel file you can open, and the contents of the cell (5 pieces) inserts into the table.
Thank you for your help in advance!
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Big thanks, but not working.. if put the code in button, automatically pop-up the window and if open a file, this message alert:Untitled.jpg
Hi, lomajpure,
the run time error is not surprising as the parent to a range is a worksheet, not a workbook.
Using ActiveSheet might result in another run-time error if any of the sheets is a Chart.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks