Search:
Type: Posts; User: Robbo
Search:
Search took 1.44 seconds.
-
Excel VBA DIR but need to add username and password?
is there an easy way of updating this, without loads of code basically needs a user name and password? if run command does prompt
If...
-
just added the sort and filter
and worked no extra code required
-
Having issues with this bit of code, all my other sheets work but not this one
Sub removeblanks()
ActiveWorkbook.Worksheets("Cumulative List").AutoFilter.Sort.SortFields.Clear
...
-
you may be on to something
so i can select a slicer and set in VBA i then would have to force the update graphs and then do a copy to sheet.
need to do the for all 3 jumbos but also need to...
-
How to use for Daily reports:-
1 Select `Name`.. Jumbo 1.
2 Select `Date`.. today’s date example - 11/03/2021
3 Press `Update Graphs`.
4 Press `Print`.
5 Select `Name`.. Jumbo 2.
6 Repeat...
-
Yeah the slicers are removed but there’s hidden columns someone before me did the sheet just didn’t want to have to completely re do
-
Hiya there’s one macro which updates the original sheet but not the copy sheets
Open the zip file and look at the update macro without copy and pasting this 6 times need it to generate the 6...
-
Hiya basically I need to change the pivot table then save the sheet
Any idea how I can do this ?
-
Just wondering if anyone can help
need to automate an excel sheet which will run a macro to update then copy the sheet to end
have manually done but don't even know where to start automating...
-
have added a zip file the cells basically want to scale from red to green if below 50 red
-
excel sheet red to green on percentage
however top part of sheet showing 50% as red
however lower sections showing as a dark green tried format painter
just cant get the lower fields to show...
-
yes if you change the time now its working was just the format of the date which wasn't working correctly
cheers
-
think have resolved it
had to change date formula to
=DATE(MID(Data_log_10[@Column1],51,4),MID(Data_log_10[@Column1],48,2),MID(Data_log_10[@Column1],45,2))
and seems to pickup correctly now
-
Hiya
doesn't quite work correctly its just showing me the last entry
=VLOOKUP(A386&" 22:0",Jumbo1!G:H,2)
DB_FLOW_PARA.s_ProcessValues.r_Totalizer_1;"24.09.2020 20:08:23";28997...
-
wondering if any one can help the best way to do this
23.09.2020
24.09.2020 JR 16484 24.09.2020 14:08:26
25.09.2021 24.09.2020 14:08:26
so formula for number is
=VLOOKUP(A385&"...
-
think worked it out
If Time() > TimeValue("06:00:00") And Time() < TimeValue("14:00:00") Then 'Days
ThisWorkbook.Worksheets("Home").Range("D8:D17").Locked = True
ElseIf Time() >...
-
Trying to get excel to open and check the time then run some stuff
If Now > Time(8, 0, 0) And Now < Time(8, 10, 0) Then 'Days
ThisWorkbook.Worksheets("Home").Unprotect Password:="123"
...
-
still didn't get any further on with this? anyone got a VB6 app which could start me off
-
yeah offline and lock out think best to keep info in an access database for recording sourcesafe seems to show in *.ini files
-
if you look on here the best thing I could find was on plant source code was called
File/Document Management System
however only let me use one and was set in directory which couldn't change ...
-
gonna have a look at source safe, but would mean have to install on other pc`s for everyone to use?
-
its not version control of VB, but version control of a file or folder, lock out when updating then increments and upload back, will have to put a logon front end etc but need something that works...
-
ive been looking and found a file management application but didn't work quite rite, is there anything in VB which I could customise, sample was using a access database but only worked to one...
-
really need a software version control in vb6 so can backup files, folder and lock increment backups have login access and reports who has file out what changes where made really need help with this...
-
-
need a starting point basically needs to be able to back up a file/s or folders, check in check out, control users and version control, lock if user has the files out, report let them know who,...
-
all sorted had the ignore dulpicate entrys on turned off worked yippy
did it al myself no help from ere!!!
-
more info
in text box i have this
=DLookUp("Attended","Personnel","Date Like [Date of Training] And Title1=Title")
and the first line gets -1 however i need to do a count on this "Attended"...
-
to help the sub query is this
SELECT COUNT(Attended) AS Attend
FROM Personnel
WHERE Attended=-1 And [Date] Like [Date of Training] And Title1=Title;
and goes on report as
Attend
-
basically want to put the value of the sub query into the text box have tried using the dlookup but didnt work
have tried referenecing the child tag, no look, have run out of ideas
if you can...
-
hiya had to do a different way as it not on change of one cell maybe 2 maybe 20, so did on activate, then check the range each cell and then change there colour if they match just means you have to...
-
have this bit of code and works well when your typing in each cell however these values will be pasted in, multiple at a time,
and come up with a mismatch error
any ideas how i can get round...
-
hiya cheers for your help got this to work
Public Sub Worksheet_Change(ByVal Target As Range)
If Target.Column >= 6 And Target.Column < 16 Then
Select Case Cells(Target.Row,...
-
problem is now im checking the range, which i did on first example
then have to select the cell i want to check so target is selectiong the correct number?
so depending where i click it will do...
-
ok well the changes are in colums 6 to 15 the total i want to check is in 16 (value) and the formatiing of color index is in 17
this doesnt quite work correctly
-
hiya wud i be best doing this by cell then?
whats esyest way to ammed the code its been a long day
-
Any one help
trying to get this to work can change the fon and cell colour but cant put a value in the CELL
the C B A and AA
everytime have in the code they move it back to the top so only...
-
been on this for about and hour and cant work it out
have 2 columns
on with
C1
C3
C4
C5
-
basically i run a reprt from SAP and export to excel
basically i need to find the top 10 from the list for example LINE C1 PALLET WRAPPING MACHINE and frequency and maybe cost, need easy...
-
can u helpm with my problem
have the hyperlinks in a cell just tryin to put the hyperlink in the body of an email, can get text but want the link
code is =
Sub NEWACTION()
|
Click Here to Expand Forum to Full Width
|