Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Excel/SQL/Database Thoughts

  • Please log in to reply
No replies to this topic

#1 Xerakon


  • Members
  • 2 posts
  • Local time:10:31 AM

Posted 18 April 2014 - 11:11 AM



Welp, I've signed on with a small business and have been thrown the operations hat, which includes IT work. Here's my problem currently:


Our parent company sends us an excel workbook (with 200 worksheets) everyday that we then have to sort through and shoot different worksheets to our clients. We have been using a macro to cut out the sheets that we want to new workbooks that we then e-mail to our clients each day. This is a very time-consuming process and frequently breaks because new worksheets are constantly being added.


We have a website with MySQL. I was wondering if it would be an easier process to upload workbooks each day and give the clients a password-protected link so that they can view the information that is pertinent for them. Is this possible? Is it difficult? Or do you guys have any other ideas?



BC AdBot (Login to Remove)


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users