Output Data To Word Document
-
@scottalanmiller said:
@garak0410 said:
Oh from the various advice I get from the forums when seeking development suggestions. Every time I seek Excel/VBA help, someone will usually say RUN from it and get on ASP.NET. Could be trolls?
Kind of. Possibly just people who don't really have a good grasp on how this stuff works and want to post something. VBA cannot be easily replaced. They are probably confusing it with VB, which should always be replaced. Or just trolls.
Pretty much everything is Office here...and with our Exchange Online subscription, we do have SharePoint online which does play nicely with Access. It would take me a few more years of study before I got even one thing off of VBA here. So for now, I will embrace it...
-
@garak0410 said:
@scottalanmiller said:
@garak0410 said:
Oh from the various advice I get from the forums when seeking development suggestions. Every time I seek Excel/VBA help, someone will usually say RUN from it and get on ASP.NET. Could be trolls?
Kind of. Possibly just people who don't really have a good grasp on how this stuff works and want to post something. VBA cannot be easily replaced. They are probably confusing it with VB, which should always be replaced. Or just trolls.
Pretty much everything is Office here...and with our Exchange Online subscription, we do have SharePoint online which does play nicely with Access. It would take me a few more years of study before I got even one thing off of VBA here. So for now, I will embrace it...
I'm not sure that there is any replacement for VBA. You'd have to replace Office entirely, unless I am missing some automation capability.
-
@scottalanmiller said:
@garak0410 said:
@scottalanmiller said:
@garak0410 said:
Oh from the various advice I get from the forums when seeking development suggestions. Every time I seek Excel/VBA help, someone will usually say RUN from it and get on ASP.NET. Could be trolls?
Kind of. Possibly just people who don't really have a good grasp on how this stuff works and want to post something. VBA cannot be easily replaced. They are probably confusing it with VB, which should always be replaced. Or just trolls.
Pretty much everything is Office here...and with our Exchange Online subscription, we do have SharePoint online which does play nicely with Access. It would take me a few more years of study before I got even one thing off of VBA here. So for now, I will embrace it...
I'm not sure that there is any replacement for VBA. You'd have to replace Office entirely, unless I am missing some automation capability.
Our main metal building program has a ton of raw, text based data that is imported into Excel via some very heavy VBA. And when I say heavy, I mean it. It would take me at an expert level to move this to another language and format. So for now, just learning it. And so far, I am liking Access...I think it may work and hope it will work well with SharePoint Online.
-
@garak0410 moving off of MS Office would be huge, I'm sure. Although, in theory, if you are using Access you can put the backend on SQL Server and at least not be tied to JetDB. Then you can use anything to access the data.