If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Rate Thread | Display Modes |
#16
|
|||
|
|||
2 instances of Outlook10?
On 12-Sep-2019 9:54 AM, GS wrote:
Yes, you're right. But I believe a registry modification is required if, whenever you double-click an excel file icon, you need to have it open in a new instance - which is my situation. I'm curious why you need to open in a new instance! I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... It really isn't practical to have all these functions in one large excel file. I prefer to have them all operating completely independently - thus the need for different instances. And if I need to create a brand new excel file it needs to be completely separate from all the other excel things going on all day in the background. |
Ads |
#17
|
|||
|
|||
2 instances of Outlook10?
On 12-Sep-2019 9:51 AM, GS wrote:
Yes, you're right. But I believe a registry modification is required if, whenever you double-click an excel file icon, you need to have it open in a new instance - which is my situation. Why not just invoke the "Open in new window" command by holding down the Ctrl key beforehand? personal preference - I only need to use one hand And every time I open a new excel file it needs to be in a new instance so as not to interfere with the several other excel files running VBA programs continuously on the same device. Ah ha; - that's what I suspected! Makes sense... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#18
|
|||
|
|||
2 instances of Outlook10?
On 12-Sep-2019 9:54 AM, GS wrote:
Yes, you're right. But I believe a registry modification is required if, whenever you double-click an excel file icon, you need to have it open in a new instance - which is my situation. I'm curious why you need to open in a new instance! I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... It really isn't practical to have all these functions in one large excel file. I prefer to have them all operating completely independently - thus the need for different instances. And if I need to create a brand new excel file it needs to be completely separate from all the other excel things going on all day in the background. Thanks! See my response above... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#19
|
|||
|
|||
2 instances of Outlook10?
On Thu, 12 Sep 2019 10:57:10 +1200, malone wrote:
I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... Have you previously shared any of your VBA code, perhaps in the microsoft.public.vb.general.discussion newsgroup or one of the other VB-related newsgroups? I wouldn't mind taking a look to see what I can adapt for my own purposes. |
#20
|
|||
|
|||
2 instances of Outlook10?
On 12-Sep-2019 11:38 AM, Char Jackson wrote:
On Thu, 12 Sep 2019 10:57:10 +1200, wrote: I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... Have you previously shared any of your VBA code, perhaps in the microsoft.public.vb.general.discussion newsgroup or one of the other VB-related newsgroups? I wouldn't mind taking a look to see what I can adapt for my own purposes. I'd be very wary about sharing my code. Or even showing it to anyone! I'm no software engineer or coding guru. My knowledge of VBA has been a slow self-learning curve over the past 20 years - mainly with help from Google searches. Indeed, some of the code I've copied and pasted from VBA experts' pages I still don't really understand. But as long as it works for my applications, that's what matters. I suspect a professional coder would cringe at my attempts and for a novice my efforts might do more harm than good! |
#21
|
|||
|
|||
2 instances of Outlook10?
On Thu, 12 Sep 2019 10:57:10 +1200, malone wrote:
I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... Have you previously shared any of your VBA code, perhaps in the microsoft.public.vb.general.discussion newsgroup or one of the other VB-related newsgroups? I wouldn't mind taking a look to see what I can adapt for my own purposes. It would be helpful if you could see how the target apps' object models can be accessed for those elements exposed to automation. That, of course, is entirely dependant on the OEM making an application API available! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#22
|
|||
|
|||
2 instances of Outlook10?
It really isn't practical to have all these functions in one large excel
file. I prefer to have them all operating completely independently - thus the need for different instances. And if I need to create a brand new excel file it needs to be completely separate from all the other excel things going on all day in the background. Given the nature of what you're doing, that kind of overhead would likely cause Excel to crash (frequently)! What you're doing keeps each process running in independant threads without any association to the other instance; - much safer and more reliable IMO! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#23
|
|||
|
|||
2 instances of Outlook10?
On Thu, 12 Sep 2019 12:25:00 +1200, malone wrote:
On 12-Sep-2019 11:38 AM, Char Jackson wrote: On Thu, 12 Sep 2019 10:57:10 +1200, wrote: I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... Have you previously shared any of your VBA code, perhaps in the microsoft.public.vb.general.discussion newsgroup or one of the other VB-related newsgroups? I wouldn't mind taking a look to see what I can adapt for my own purposes. I'd be very wary about sharing my code. Or even showing it to anyone! I'm no software engineer or coding guru. My knowledge of VBA has been a slow self-learning curve over the past 20 years - mainly with help from Google searches. Indeed, some of the code I've copied and pasted from VBA experts' pages I still don't really understand. But as long as it works for my applications, that's what matters. I suspect a professional coder would cringe at my attempts and for a novice my efforts might do more harm than good! I understand. Most of my own VBA code in recent years has been work related, and thus of no particular interest to anyone but me, but I recently coded a Sudoku solver from scratch. I only spent a few hours on it so it's limited to Easy and Medium puzzles. I'd have to add another logic block if I wanted it to handle the more difficult puzzles. I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. |
#24
|
|||
|
|||
2 instances of Outlook10?
On 12-Sep-2019 1:45 PM, Char Jackson wrote:
On Thu, 12 Sep 2019 12:25:00 +1200, wrote: On 12-Sep-2019 11:38 AM, Char Jackson wrote: On Thu, 12 Sep 2019 10:57:10 +1200, wrote: I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... Have you previously shared any of your VBA code, perhaps in the microsoft.public.vb.general.discussion newsgroup or one of the other VB-related newsgroups? I wouldn't mind taking a look to see what I can adapt for my own purposes. I'd be very wary about sharing my code. Or even showing it to anyone! I'm no software engineer or coding guru. My knowledge of VBA has been a slow self-learning curve over the past 20 years - mainly with help from Google searches. Indeed, some of the code I've copied and pasted from VBA experts' pages I still don't really understand. But as long as it works for my applications, that's what matters. I suspect a professional coder would cringe at my attempts and for a novice my efforts might do more harm than good! I understand. Most of my own VBA code in recent years has been work related, and thus of no particular interest to anyone but me, but I recently coded a Sudoku solver from scratch. I only spent a few hours on it so it's limited to Easy and Medium puzzles. I'd have to add another logic block if I wanted it to handle the more difficult puzzles. I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. Â*I download a web page to a text file using VBA's Shell function together with GNU wget.exe and then parse that file to get the required information. That's all pretty simple in VBA. |
#25
|
|||
|
|||
2 instances of Outlook10?
On Thu, 12 Sep 2019 16:56:44 +1200, malone wrote:
On 12-Sep-2019 1:45 PM, Char Jackson wrote: On Thu, 12 Sep 2019 12:25:00 +1200, wrote: On 12-Sep-2019 11:38 AM, Char Jackson wrote: On Thu, 12 Sep 2019 10:57:10 +1200, wrote: I have numerous VBA excel programs running concurrently, and completely independently, doing things like monitoring a weather station, controlling and analysing the output from security cameras, regularly updating pages on my web site, regularly downloading web pages and extracting selected data therein, and more.... Have you previously shared any of your VBA code, perhaps in the microsoft.public.vb.general.discussion newsgroup or one of the other VB-related newsgroups? I wouldn't mind taking a look to see what I can adapt for my own purposes. I'd be very wary about sharing my code. Or even showing it to anyone! I'm no software engineer or coding guru. My knowledge of VBA has been a slow self-learning curve over the past 20 years - mainly with help from Google searches. Indeed, some of the code I've copied and pasted from VBA experts' pages I still don't really understand. But as long as it works for my applications, that's what matters. I suspect a professional coder would cringe at my attempts and for a novice my efforts might do more harm than good! I understand. Most of my own VBA code in recent years has been work related, and thus of no particular interest to anyone but me, but I recently coded a Sudoku solver from scratch. I only spent a few hours on it so it's limited to Easy and Medium puzzles. I'd have to add another logic block if I wanted it to handle the more difficult puzzles. I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. *I download a web page to a text file using VBA's Shell function together with GNU wget.exe and then parse that file to get the required information. That's all pretty simple in VBA. Excellent, thanks. |
#26
|
|||
|
|||
2 instances of Outlook10?
I also have some limited experience using VB6 and VBA to retrieve and parse
web content, and that's what you're doing that caught my eye. I made an Excel solution to download volunteer info entered on a website, and parse the info to data fields on a worksheet. I designed the web page to append the data to a text file that Excel dumped into an array, picked up the last record already on the sheet and parsed any following data from the file. User was notified if there was no new data. As this is a proprietary solution for a client, I can only offer to assist you with your own project. (FYI: I am a professional Excel Applications developer) -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#27
|
|||
|
|||
2 instances of Outlook10?
On 13-Sep-2019 5:59 AM, GS wrote:
I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. I made an Excel solution to download volunteer info entered on a website, and parse the info to data fields on a worksheet. I designed the web page to append the data to a text file that Excel dumped into an array, picked up the last record already on the sheet and parsed any following data from the file. User was notified if there was no new data. As this is a proprietary solution for a client, I can only offer to assist you with your own project. (FYI: I am a professional Excel Applications developer) Thanks for your offer but I'm reasonably comfortable with the way my programs are running currently. The only outstanding problem I have is dealing with errors associated withÂ* computers on the LAN needing to talk with each other over a rather flaky wifi. |
#28
|
|||
|
|||
2 instances of Outlook10?
On 13-Sep-2019 5:59 AM, GS wrote:
I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. I made an Excel solution to download volunteer info entered on a website, and parse the info to data fields on a worksheet. I designed the web page to append the data to a text file that Excel dumped into an array, picked up the last record already on the sheet and parsed any following data from the file. User was notified if there was no new data. As this is a proprietary solution for a client, I can only offer to assist you with your own project. (FYI: I am a professional Excel Applications developer) Thanks for your offer but I'm reasonably comfortable with the way my programs are running currently. The only outstanding problem I have is dealing with errors associated with* computers on the LAN needing to talk with each other over a rather flaky wifi. I've already agreed with what you are doing as the way to go. My post is a reply for Char Jackson; - he was asking to see your code and I'm offering to assist with his own code specifically for his project.g -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#29
|
|||
|
|||
2 instances of Outlook10?
On Thu, 12 Sep 2019 16:21:05 -0400, GS wrote:
On 13-Sep-2019 5:59 AM, GS wrote: I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. I made an Excel solution to download volunteer info entered on a website, and parse the info to data fields on a worksheet. I designed the web page to append the data to a text file that Excel dumped into an array, picked up the last record already on the sheet and parsed any following data from the file. User was notified if there was no new data. As this is a proprietary solution for a client, I can only offer to assist you with your own project. (FYI: I am a professional Excel Applications developer) Thanks for your offer but I'm reasonably comfortable with the way my programs are running currently. The only outstanding problem I have is dealing with errors associated with* computers on the LAN needing to talk with each other over a rather flaky wifi. I've already agreed with what you are doing as the way to go. My post is a reply for Char Jackson; - he was asking to see your code and I'm offering to assist with his own code specifically for his project.g Thanks, Garry. I don't have anything at the moment that I'm having trouble with. My stuff is all working. |
#30
|
|||
|
|||
2 instances of Outlook10?
On Thu, 12 Sep 2019 16:21:05 -0400, GS wrote:
On 13-Sep-2019 5:59 AM, GS wrote: I also have some limited experience using VB6 and VBA to retrieve and parse web content, and that's what you're doing that caught my eye. I made an Excel solution to download volunteer info entered on a website, and parse the info to data fields on a worksheet. I designed the web page to append the data to a text file that Excel dumped into an array, picked up the last record already on the sheet and parsed any following data from the file. User was notified if there was no new data. As this is a proprietary solution for a client, I can only offer to assist you with your own project. (FYI: I am a professional Excel Applications developer) Thanks for your offer but I'm reasonably comfortable with the way my programs are running currently. The only outstanding problem I have is dealing with errors associated with* computers on the LAN needing to talk with each other over a rather flaky wifi. I've already agreed with what you are doing as the way to go. My post is a reply for Char Jackson; - he was asking to see your code and I'm offering to assist with his own code specifically for his project.g Thanks, Garry. I don't have anything at the moment that I'm having trouble with. My stuff is all working. That's great! I appreciate the feedback... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
Thread Tools | |
Display Modes | Rate This Thread |
|
|