How to Keep the Wokbook Invisible after Saving Another

Goeie Naand, Hmerman,

Welkom by hierdie Forum!

See this Link

Regards.

Middag Hmerman,

Verskoon die Engels, ter wille van die Forum.

I do not have access to Excel 2013, and I don't know if it is to be "Blamed" either. I have tested your problem in Excel 2010, and cannot replicate the issue you have. The Hidden Workbook remains Hidden whatever I do, until I Unhide it.

If your problem persists, may I suggest that you, attach a sample workbook with your complete Code, etc..

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.


Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Groete.

Goeie More, Hmerman,

Jy gooi 'n taai toffie!

I got up at 2 am this morning, to tackle your clear as mud effort.LOL

Just kidding. There is a big difference between Hiding a Workbook and setting the visibility of an Application(Excel) to False. Please try to steer a wide berth from this practice until you are totally confident with your Coding skills, and knowledge of same, as it may cause havoc with program failures and "Crashes". One example was your Userform which you could just close, making you believe that you have exited Excel, while "back at the ranch", it is not the case. Excel is still running in the background, and waits to pounce when you try something else in or with any other Code and or Workbook!

I have also taken the liberty to change a few other things. The "Update Database" Button has been removed from the userform, and it now appears within the Sheet itself. Try it, and you will see what it does. Some control measures were attached to it to prevent it from repeatedly appending the same data to the existing "Databasis".

It might be necessary for you to change references to Directories in the Code, to suit.

Please see if you can make do with the Workbook as I have it now, or let me know if you would want it changed.

Lekker dag.

Hi Hmerman,

Yet another option, where I forgot to add selecting the "Databasis". This can only be done from within the sheet in the "Toets" Workbook though.

Is this O.K. with you?

Groete.

Haai Winon,
Baie dankie hiervoor!

Just to clarify, I sent you a bare minimum of my Userform and Spreadsheet (as requested) that consist of a 6 page Multipage with Option - and Check buttons as well as with a Button and Image control that opens the Windows Camera App and loads the Latest jpg file into the Image Control (I included only the code I struggled with and a mock up Userform with two buttons). This excluded the QueryClose Event where the closemode checked for values 0, 1, 2 and 3 depending on what the User does. Of course you did not know this, therefore I am sorry I did not include it in my explanation.
The static database table (that never grows) consists of formulas that calculates the Soil Health Information that the User of the Userform inputs on the Userform and the Database is either created (if it does not exist) or the values are appended to existing data in the database that sits in dropbox that is linked to a Excel Spreadsheet with a pivot table that refreshes from the database, I also do not want the user to fiddle with the spreadsheet from which the static database gets it value i.e. xlVeryHidden sheets. This I also did not explain like in this long winded paragraph. So sorry.
*I would love to use PostgresSQL or something similar for the database, but I do not know SQL and how to get the data into the database over the Internet or how to accommodate 30 users' data at the same time.

The above reason is why I use the

Please Login or Register  to view this content.

method. It also looks and feels like a very very light app.

With regards to my problem code you solved it:
Firstly, I should always use the Application.Visible method with QueryClose Event. As in your example.
Secondly, as I can glean from your examples, setting the ShowModal to True means I cannot open a saved Workbook or work in one.

With regards to your question:
Yes, it is O.K. as I did not think about using Counta to validate the static database with the GrondGData Array size.

Thank you very much.

Mooi dag vir jou ook.

Groete,

Hi Hmerman,

Thank you for the feedback. If you have that many other undisclosed controls and features in your setup, it might not even be necessary for the Counta bit, since the Pivot Table should take care of that.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Dankie, en voorspoed met jou projek.