Search:

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...

can any one help

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()