createportfolio | Create Portfolio is a guide | Portfolio library

I have a portfolio report I build from VBA code on monthly and ad-hoc basis. It works fine today, but the underlying VBA is far from optimized. The code sniplet below is repeated 5 times as there are 5 projects in the system now, but it will grow to 50 shortly. Is there anyone that have suggestions as to how I can utilize VBA more elegantly performing the copying to the locations specified in the code (see sniplet below)

I am trying to send some data from one razor page to another. For my scenario a user is trying to register an account. When they submit their info they have a confirmation code sent to their email (in this case the 'email' is stored in a file in C:/) then when they go back to the webapp to input the code and confirm it then the account is registered and is sent to the next page. I am having trouble knowing what user is currently operating on the webapp. So, on the registration page they input their info then a code is generated and they are sent to a 'confirmation' page where they put the code BUT when they reach the next page I am unable to know who's confirmation code is the correct one for the current user, I need to pass either the userID that just registered or the actually confirmation code to the confirmationPage? I think you can save the user information by opening a session but I only wanted to start the session after their account is fully registered and confirmed.

I believe you can use ViewData in this scenario but when I tried using ViewData the object sent to the next page was null and did not have the information I needed

Register Model

I am trying to create a simple drop-down menu populating it with categories from a local database. I am using .NET Core 2.2. I am following a demo that uses an earlier version of ASP.NET MVC where they use ViewBag to transfer a list from the controller to view. For some reason, ViewBag doesn't work giving me a compiling error of "ViewBag does not exist in the current context". After a little bit of research, I opted to use ViewData which seems to work from the controller but I am having a little bit of trouble displaying the category Name from my model as when I run the page the drop-down options display "Model.Visportfolio.Category" rather than the category Name itself.

I am fairly new to HTML so I tried replicating the code from the demo but I am having trouble accessing the fields of my Category class. I tried using ViewBag as from my research, ViewData and ViewBag are "interchangeable" but no luck.

HTML for where I call my drop-down menu, code does not compile as it says CategoryName and CategoryId does not contain the definition and no accessible extension method

I calling a stored procedure and it has an int return value. However there is an error on returning the value back to my back end.

I am trying to doing an fetch call to retrieve a list of objects and just print its content for now. when the call is made a 502.3 error and stackoverflowexception error happens on the return call. See code below