Search:
Type: Posts; User: westconn1
Search:
Search took 1.34 seconds.
-
that was only to make the appearance of the option button on or off, it would not affect the colour changing
of course the code as above only works for the mouseup of the specific option button,...
-
assuming this is for an option button, it does not toggle, it can only be changed by having another option button in a group (on a single container), to select a different option
if you only want a...
-
you need a reference to the printerdlg, which probably is not installed on the new machine, look for missing reference
-
depending if you want a formula or vba
assuming all the dates are in a single column like column A
=INT((MAX(A:A)-MIN(A:A))/30)
of course just calculating for 30 day months only is a bit rough, if...
-
i would think this would be against the terms of the site
-
assuming that the comma is just a decimal or thousands separator not a list of multiple numbers
you should not store formatted numbers, just numeric as some numeric field type, leave formatting for...
-
your attachments are broken
-
you should be able to test quite simply in excel vba
Dim p As PageSetup
Set p = Sheets("sheet1").PageSetup
p.Application.PrintCommunication = Falsethough as print communication is a property...
-
probably would work when you leave the textbox, else you need to put code in keypress or some other key event to monitor for spaces as the are typed, remove spaces as typed, then put back if some...
-
shellexecute will allow you to open a webpage in the default browser, but not interact with it
w10 still has internet explorer installed, even though they don't want you to use it any longer,...
-
there are many examples in this forum of basic code to access web pages, but as not all web pages are equal, any or none of may work for you
also any code to access web pages may go of of date as...
-
did you try dividing rhe width of the grid by the number of columns and making that the width of each column?
-
some sort of status bar, then update during the loop
or change to an egg timer cursor or similar, then change back when loop finishes
-
i am sure it would be possible, back in vb5 i created a datepicker, just using std controls, a command button, labels and picturebox,
also i had forgotten, but there was a thread here recently...
-
If LCase(Left(i.Name, InStr(i.Name, ".") - 1)) = LCase(n) Then to make code easier and probably more efficient i put "prom" into variable n
as this is case sensitive I converted both to lcase to...
-
then you need to buy vb6 where ever you can find it, as suggested, it certainly is not available from microsoft
-
thank you right on the money, so easy i have been really missing this, no idea how it might have got changed
-
probably too late by then, most modern bar code scanners just work as a keyboard input, so it may be possible to detect some keyboard input and the active control, change the focus and warn the user...
-
i think this one will do what you want with minimum changes
http://www.cpearson.com/excel/SetParent.aspx
-
you can download and use visualstudio, which includes vb.net, for free, but it is not vb6 which is now obsolete in the real world, only us dinosaurs still using it
the licencing for vb6 is quite...
-
instead of this you would have loop through all the items in the zip file and compare each to list 3, a huge amount of extra processing
you can use the API to match items in the listbox for exact...
-
there is an option 16 for copyhere that will allow to overwrite any existing files without prompt, but as far as i know, nothing to skip existing files
-
this fixes the month headers to as described
For i = 9 To 12
.TextMatrix(0, i - 9) = CStr(mvarYear - 1)
.TextMatrix(1, i - 9) = MonthName(i)
Next
...
-
-
not sure when it stopped working correctly, but it has been for a while now
-
hard to move the execution point that way though
-
recently i have found that i can not drag blocks of code when editing or drag the code execution point when stepping through code
i am not sure if there are any other symptoms
this is not...
-
do not post the executable, only the project and sample data files, i doubt many will email you
-
try like
for i = 9 to 12
.TextMatrix(0, 0) = CStr(mvarYear - 1)
.TextMatrix(1, 0) = MonthName(i)
next
For i = 1 To 10
.TextMatrix(0,...
-
you could try replacing sleep with doevents
-
that object library refers to word 2019, whether this is relevant to your problem is unclear
maybe you can try late binding to see if it changes anything
change like
Dim mword As Object, mdoc...
-
can you open the docx or docm files if you do it manually from windows?
-
use the google sheets API
see
https://ramblings.mcpher.com/integratingappswithotherplatforms/googlesheetsv4apifromvba/
-
it may be that a dialogue asking the user to allow macros is being shown, as it is not visible to be dismissed the document is just hanging waiting for response
test by reducing the security level...
-
i am sure there is a chat client server example in codebank vb6
-
copy the complete ranges into arrays change all the data in the array and rewrite to cells, will be much faster
-
-
you can try like
Set sh = CreateObject("shell.application")
Set n = sh.Namespace(Text11.Text & "downloaded\kof95.zip")
Set nn = sh.Namespace(Text11.Text & "downloaded\")
dest = nn.self.Path &...
-
test for each p in printers then set one that is known can work without error, may need to test if printer is online
-
that looks like a slow way to do it
just loop through the files in the zip and use dir (or the shell equivalent) to check if each already exists in the destination, if not then extract, no need to...
|
Click Here to Expand Forum to Full Width
|