I have produced a graph within an Excel application with months "Jan-05", "Feb-05", "Mar-05", etc along the x-axis. However, a colleague requires to use this in the Netherlands where (unsurprisingly) regional settings are in Dutch. Producing this graph, the month names are translated to Dutch...
Hi all,
I wish to launch Business Objects from a VB6 executable.
I need to pass in the UserID & password from user input and therefore want to bypass the startup prompt. I know I can use the command line, but if the password is incorrect then I get the prompt up.
I want to recognise the...
Your problem is that the .avi postscript is not assigned to any application, so the shell command does not know what application to startup to run the .avi file.
Try specifying the application in which to open the avi in the Shell command ie
x=vba.shell("C:\Program Files\...\xxx.exe...
The answer to this has been supplied in another thread.
Basically, set your field ControlSource to
=Iif(HasData,[RSFieldName],"")
and if there is no data being returned then the Field will be displayed empty. Since the fields are displayed then so will the labels.
You've got to open it in some application. Use internet explorer if you want to view it read only
Private Sub Form_Load()
Shell "C:\Program Files\Internet Explorer\Iexplore.exe f:\b.jpg"
End Sub
Use the COUNTIF function in your occur column
eg =COUNTIF(nrLookup,">=" & B3) - COUNTIF(nrLookup,">" & C3)
where nrLookup is your lookup range
B3 contains your lower range
C3 contains your upper value
To keep your sanity, try arranging your data in a table (maybe in a hidden sheet) and look up the values you want.
The top row allows lookup to work in both directions.
For tidyness' sake, I have named the range nrTable.
0 1 2 3
0 0 85 110
0 0 0.5 0.5
500000 0 0.75 1
1000000 0.1 1 1.2
Then use...
The following should work. You need to set a reference to 'Windows Script Host Object Model'
Function PathTransToUNC(sPath As String) As String
Dim oWSHNet As Object, drv
Dim sDriveLetter As String, sUNC As String
Dim bNextOne As Boolean
bNextOne = False
sDriveLetter = Left(sPath, 2)
If...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.