Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
zelarra821's latest activity
zelarra821
reacted to
cheekybuddha's post
in the thread
Solved
Export to Excel and leave the workbook open
with
Love
.
Have you tried commenting out these two lines: ' ... xlBook.Close savechanges:=True xlApp.Quit ' ... ?
Apr 27, 2024
zelarra821
reacted to
arnelgp's post
in the thread
Solved
Export to Excel and leave the workbook open
with
Love
.
maybe.. 'xlBook.Close savechanges:=True xlApp.Visible = True
Apr 27, 2024
zelarra821
replied to the thread
Solved
Export to Excel and leave the workbook open
.
Solved: Private Sub CmdExportarExcel_Click() Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As...
Apr 27, 2024
zelarra821
replied to the thread
Solved
Export to Excel and leave the workbook open
.
Maybe this xlApp.Visible = False Set xlSheet = Nothing Set xlBook = Nothing xlApp.Visible = True I suppose that if Excel is visible...
Apr 27, 2024
zelarra821
replied to the thread
Solved
Export to Excel and leave the workbook open
.
If I do that, the code doesn't work
Apr 27, 2024
zelarra821
posted the thread
Solved
Export to Excel and leave the workbook open
in
Modules & VBA
.
Hello, people. I have this code to export a form to Excel: Private Sub CmdExportarExcel_Click() Dim xlApp As Excel.Application Dim...
Apr 26, 2024
zelarra821
replied to the thread
Solved
Error with Input Mask
.
Thanks, June7
Apr 13, 2024
zelarra821
reacted to
June7's post
in the thread
Solved
Error with Input Mask
with
Love
.
Usually BeforeUpdate event is used for data validation. I never allow empty string in fields so I would not set control equal to ""...
Apr 13, 2024
zelarra821
reacted to
arnelgp's post
in the thread
Solved
Error with Input Mask
with
Love
.
maybe add code to the Change event?
Apr 13, 2024
zelarra821
reacted to
CJ_London's post
in the thread
Solved
Error with Input Mask
with
Love
.
If the season is always a year why bother with the second year? You can just have a calculated value in a second control =[season] + 1
Apr 13, 2024
zelarra821
reacted to
The_Doc_Man's post
in the thread
Solved
Error with Input Mask
with
Love
.
The ONLY possible misunderstanding is whether there could EVER be a split season as 2024/2026 (skipping a year). If not, entering the...
Apr 13, 2024
zelarra821
reacted to
CJ_London's post
in the thread
Solved
Error with Input Mask
with
Love
.
Understand perfectly, just asking why do it that way? Your way what is to stop the user entering 2924/1950? So you need validation to...
Apr 13, 2024
zelarra821
replied to the thread
Solved
Error with Input Mask
.
It's possible to do what I want if you use this input mask: and then you insert this code: 9999/9999;0;_ (9 is optional and 0 is...
Apr 13, 2024
zelarra821
replied to the thread
Solved
Error with Input Mask
.
It seems good, but it should be able to add a entire season (2024/2025) as only 2024 y fill it to 2024/2025.
Apr 13, 2024
zelarra821
replied to the thread
Solved
Error with Input Mask
.
It must be two years, like football season. I don't know if you understand me.
Apr 13, 2024
Home
Members
Top
Bottom