ProFox

profox@leafe.com

2704 discussions

Using Office Automation - Excel (2016), SaveAs to overwrite existing file without prompt
by MB Software Solutions, LLC 02 Mar '20

02 Mar '20

Players: VFPSP2, Win10 Pro, existing Excel 2016 XLSX file I'm using automation coding to open an exisitng Excel file, write to it, and then save it as the same name. How can I force that without the system asking me to confirm? What's the SET SAFETY OFF equivalent? My HWP Tamar Granor/Ted Roche book is at home so hoping to get a tip before the work day is over. Here's my line of coding saving it: this.oExcel.ActiveWorkBook.SaveAs(ADDBS(this.cPath)+this.cFile) (Did the Office automation book get released into the public domain like Hackers Guide and Stonefield Database Toolkit did yet?) tia, --Mike

3 2

ProFox List Statistics for February 2020
by List Administrator Account 01 Mar '20

01 Mar '20

================================================== ProFox List Statistics February 2020 ================================================== Subscriber Count at End of Month: ProFox: 295 ProFoxTech: 181 ================================================== Total Posts: 54 (Down 47.06% from January 2020) Total [OT] Posts: 0 (Unchanged from January 2020) Total [NF] Posts: 36 (Up 80.0% from January 2020) Daily Message Counts for February 2020 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 M 3 - 3 T 4 - 2 W 5 - 7 T 6 - 3 F 7 - 5 S 8 - 8 T 11 - 2 W 12 - 2 T 20 - 11 F 21 - 3 S 22 - 1 M 24 - 4 T 25 - 1 F 28 - 1 Message Counts By Day of Week for February 2020 ------------------------------------------------ DOW Count --- ----- Mon - 7 Tue - 5 Wed - 9 Thu - 14 Fri - 9 Sat - 10 Distinct Posters to the List (changes relative to January 2020) ------------------------------------------------ Non-OT messages: 25 (Down 24.24%) OT messages: 0 (Unchanged) NF messages: 14 (Up 40.0%) Total number: 25 (Down 24.24%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Charles Hart Enzer, M.D. 2. 5 Eric Selje 3. 5 Johan Nel 4. 4 Tracy Pearson 5. 4 MB Software Solutions, LLC 6. 3 Ted Roche 7. 2 John Weller 8. 2 Michael Savage 9. 2 Fred Taylor 10. 2 Malcolm Greene 11. 1 Richard Kaye 12. 1 List Administrator Account 13. 1 Gianni Turri 14. 1 Alan Bourke 15. 1 Gérard LOCHON 16. 1 Rick Schummer 17. 1 Chris Davis 18. 1 Koen Piller 19. 1 Desmond Lloyd 20. 1 Vince Teachout Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 14 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Charles Hart Enzer, M.D. 2. 5 Johan Nel 3. 3 Eric Selje 4. 3 Ted Roche 5. 3 Tracy Pearson 6. 2 John Weller 7. 2 Fred Taylor 8. 2 Malcolm Greene 9. 1 Garrett Fitzgerald 10. 1 Jürgen Wondzinski 11. 1 Gérard LOCHON 12. 1 Koen Piller 13. 1 Vince Teachout 14. 1 MB Software Solutions, LLC Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 10 Charles Hart Enzer, M.D. 2. 5 Eric Selje 3. 5 Johan Nel 4. 4 Tracy Pearson 5. 4 MB Software Solutions, LLC 6. 3 Ted Roche 7. 2 John Weller 8. 2 Michael Savage 9. 2 Fred Taylor 10. 2 Malcolm Greene 11. 1 Richard Kaye 12. 1 List Administrator Account 13. 1 Gianni Turri 14. 1 Alan Bourke 15. 1 Gérard LOCHON 16. 1 Rick Schummer 17. 1 Chris Davis 18. 1 Koen Piller 19. 1 Desmond Lloyd 20. 1 Vince Teachout Top 10 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Johan Nel 2. 1 List Administrator Account 3. 1 Michael Savage 4. 1 Desmond Lloyd 5. 1 Garrett Fitzgerald 6. 1 Jürgen Wondzinski 7. 1 John Weller 8. 1 Charles Hart Enzer, M.D. 9. 1 roger tremblay 10. 1 Rick Schummer Top 14 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 [NF] Gmail No Longer Makes Bulleted/Numbered Lists 2. 6 [NF] Yahoo Email Settings 3. 6 VFP6 and VFP9 Legacy Application Support Help 4. 5 Is there a way to uto open the last project? 5. 5 [NF] X# Summit 6. 5 Problem Calling in Excel 7. 4 Error reporting via email (was [NF] Yahoo Email Settings) 8. 2 [NF] X# Status report 10 Feb 2020 9. 2 [NF] X# Bandol 2.3 FOX release 10. 1 ProFox List Statistics for January 2020 11. 1 AW: [NF] X# Summit 12. 1 [NF] University of Maine System - Business Intelligence and Data Warehouse Team Lead 13. 1 Southwest Fox 2020: Call for Speakers 14. 1 [NF] SOLVED - Gmail No Longer Makes Bulleted/Numbered Lists Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 14 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 14 [NF] Gmail No Longer Makes Bulleted/Numbered Lists 2. 6 [NF] Yahoo Email Settings 3. 6 VFP6 and VFP9 Legacy Application Support Help 4. 5 Is there a way to uto open the last project? 5. 5 [NF] X# Summit 6. 5 Problem Calling in Excel 7. 4 Error reporting via email (was [NF] Yahoo Email Settings) 8. 2 [NF] X# Status report 10 Feb 2020 9. 2 [NF] X# Bandol 2.3 FOX release 10. 1 ProFox List Statistics for January 2020 11. 1 AW: [NF] X# Summit 12. 1 [NF] University of Maine System - Business Intelligence and Data Warehouse Team Lead 13. 1 Southwest Fox 2020: Call for Speakers 14. 1 [NF] SOLVED - Gmail No Longer Makes Bulleted/Numbered Lists

1 0

Southwest Fox 2020: Call for Speakers
by Rick Schummer 28 Feb '20

28 Feb '20

We've issued the Call for Speakers (http://www.swfox.net/CallForSpeakers.aspx) for Southwest Fox 2020. If you're interested in presenting, please read the document referenced in that page and consider submitting sessions via the Geek Gatherings Submission Web site. The dates for the conference are November 12-15, 2020. We hope to see many of you there. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Re: String Reference to Object
by Gene Wirchenko 25 Feb '20

25 Feb '20

At 11:07 2018-02-15, Gene Wirchenko <genew(a)telus.net> wrote: >At 10:57 2018-02-15, "Fernando D. Bozzo" <fdbozzo(a)gmail.com> wrote: >>To talk with an example, if you have this: >> >>oObj = createobject("custom") >>reference = "oObj" >> >>The you have at least 3 options: >> >>1) The way you know => &reference..referredto >> >>2) Using evaluate => =Evaluate(reference + ".referredto") >> >>3) My preferred: Caching the object and then using it: >> >>oRef = Evaluate(reference) >>? oRef.refered1 >>? oRef.refered2 >>... > > I was hoping to avoid evaluate(), but your third way makes > sense. I will check if it works in all the contexts I am thinking > of. (I was using "object" and "reference" rather loosely.) Unfortunately, it does not work in my usual use case: as an alias. Example: use ccli where=evaluate("ccli") && Nope ? where.clcode Sincerely, Gene Wirchenko

9 9

[NF] Gmail No Longer Makes Bulleted/Numbered Lists
by Charles Hart Enzer, M.D. 22 Feb '20

22 Feb '20

- Recently, gmail stopped making both Bulleted and Numbered Lists *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Tiny Country, Huge Dreams* *ארץ זעירה, **חלומות ענקיים* *עם ישראל חי* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 14

[NF] X# Bandol 2.3 FOX release
by Johan Nel 13 Feb '20

13 Feb '20

Hi all, Following the X# Status report, V2.3 was released to FOX subscribers. March should see the next public release. https://www.xsharp.info/articles/xsharp-bandol-2-3

1 0

[NF] X# Status report 10 Feb 2020
by Johan Nel 11 Feb '20

11 Feb '20

Hi all VFPers, A status report was published on the X# website for those interested. Templates have being added for most VFP functions, so some help in adding the details would be highly appreciated. Well for those converting c# code, the compiler switch /cs (case sensitive) can now be set for those who love it. https://www.xsharp.info/articles/progress-report-feb-10-2020 Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> X# Runtime: https://github.com/X-Sharp/XSharpPublic FoxShow interview: https://blog.aksel.com/2019/07/why-xsharp-might-be-tool-foxpro.html --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

[NF] Yahoo Email Settings
by John Weller 08 Feb '20

08 Feb '20

A friend is using a program I wrote to send emails requesting a piece of information using SMTP with CDO. The program is only used twice a year. Last time it was used it was set up for his Sky account which worked fine however this time it has stopped working so he set up a Yahoo account which is not working either. Can anyone confirm the correct settings for Yahoo and SMTP please? We have tried outgoing mail server = smtp.mail.yahoo.com, port = 465 and 587, use ssl = .T., authenticate = .T. and username = 'name'@yahoo.com. Thanks John John Weller 01380 723235 07976 393631 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 8

[NF] X# Summit
by Johan Nel 08 Feb '20

08 Feb '20

Hi all, October is going to be a busy month it seems. The X# team plan a conference in Germany for those who cannot make it to SWFOX. https://www.xsharp.info/articles/x-summit-2020 Johan Nel George, South Africa.

5 4

[NF] University of Maine System - Business Intelligence and Data Warehouse Team Lead
by Garrett Fitzgerald 05 Feb '20

05 Feb '20

If anyone is interested in living in the Great State of Maine, check out the below. :-) https://maine.hiretouch.com/job-details?jobID=60402&job=business-intelligen… --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox