Add-In Worksheet as a Data Repository vs. External Workbook

[Nadine]

Hello and thank you for any attention my post may receive.

Is it possible or good practice to have an excel add-in to store data? The single add-in will be used on two computers only.

The user's will save/paste data from their input pages to a single worksheet in the add-in on a twice-daily basis.

Only one of the user's workbooks will be used to retrieve/report the data from the add-in worksheet.

And can formulas be used in the add-in worksheet?

I know I can develop a more formal database, but due to business restrictions this is not possible, i.e. MS Access is not an option - Excel is one of the few applications the business allows.

Or should I just create a third workbook for the two user workbooks to save/paste to? I do not want to create a shared-workbook environment.

 

[dmt32]

Hi,
personally I would suggest you go for your last option - create a master workbook (database) that users can access over your network to read/write data from your template (input) workbooks.
You will need to develop code to do this but do be mindful that you cannot have the database workbook open in read / write mode whist others need to send data to it.

Have a look at this thread:Standard entry from another worksheet
#Post 10 & see if any help to you

Dave

 

[Nadine]

Hi,
personally I would suggest you go for your last option - create a master workbook (database) that users can access over your network to read/write data from your template (input) workbooks.
You will need to develop code to do this but do be mindful that you cannot have the database workbook open in read / write mode whist others need to send data to it.

Have a look at this thread:Standard entry from another worksheet
#Post 10 & see if any help to you

Dave

Thank you Dave!

The third option is what is currently in place. It is only open through code to paste the data from the two source workbooks. Which opens, updates, and closes in the background.

I will have a look and consider #Post 10 from the thread you suggested.

Thank you again for your advice, which essentially I was wanting to hear. I think I wanted to ask the wider community for advice for my own convincing....and you have done that!

Have a great day!

 

[Nadine]

Hi,
personally I would suggest you go for your last option - create a master workbook (database) that users can access over your network to read/write data from your template (input) workbooks.
You will need to develop code to do this but do be mindful that you cannot have the database workbook open in read / write mode whist others need to send data to it.

Have a look at this thread:Standard entry from another worksheet
#Post 10 & see if any help to you

Dave

Dave that is some cool code. I have projects that this will definitely be used.

Thank you for the direction, and a bigger thank you for your time and experience.

 

[dmt32]

Dave that is some cool code. I have projects that this will definitely be used.

Thank you for the direction, and a bigger thank you for your time and experience.

most welcome - code could use some updating but hopefully gives you enough to work with

Dave