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.

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

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

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.

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!

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

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

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.

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.

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.

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

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.

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

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.

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