LinkBack URL
About LinkBacks
Why is it possible to import a table from a web page into Excel but not possible to import data from a downloadable (Excel) file into Excel?
Why is it possible to import a table from a web page into Excel but not possible to import data from a downloadable (Excel) file into Excel?
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Because a table from a website is text so is directly parse-able, and Excel workbook is a binary object that isn't.
Ah, that explains why then.Originally Posted by Kyle123
From a practical POV, I will need to manually download the Excel file from the website and then direct the VBA code to the downloaded file to bring it in, right?
Well you could automate the download from VBA read the data and kill the workbook if you so wished. Downloading from the web is pretty trivial, but it gets a little more complex when usernames and passwords are involved
Thanks Kyle. I'll give it a go
Here's where I have reached so far...
Please Login or Register to view this content.
Solved. The function to build the array could be more efficient/neater code but it seems to do the job.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks