Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.09 seconds.
Search: Posts Made By: smiler44
Forum: Excel 06-26-2018, 12:30 PM
Replies: 3
Views: 119
Posted By smiler44
Re: How is return value generated

thank you both of you really helpful.
the code is probably a more professional route but all i want is simple, found or not found.

you have been really helpful

thank you for the quick replies...
Forum: Excel 06-26-2018, 11:02 AM
Replies: 3
Views: 119
Posted By smiler44
How is return value generated

I found this code on the internet. It checks that URL's are still valid. Saves me clicking each one of my favourites to see they are still valid.


Public PageSource As String
Public httpRequest...
Forum: Excel 06-26-2018, 10:47 AM
Replies: 2
Views: 671
Posted By smiler44
Re: Get list of files and sub folders

sorry I never got notification of a reply.

Thank you RX_ I will check

smiler44
Forum: Excel 06-26-2018, 10:44 AM
Replies: 1
Views: 535
Posted By smiler44
Re: Help needed to modify the following macro

this will find the first blank cell in column A so you could use this if there are no gaps in column A to find the next blank cell/row

Sub Macro1()
Dim lst As String
Dim lr As String...
Forum: Excel 06-26-2018, 10:30 AM
Replies: 2
Views: 111
Posted By smiler44
Re: Link/Import SharePoint Excel File

this is a few years old but I know it worked for me at work. this will download a file from sharepoint. you will need the full path of the file you want to download



Option Explicit
Private...
Forum: Excel 02-27-2018, 01:07 AM
Replies: 2
Views: 671
Posted By smiler44
Get list of files and sub folders

I am after a macro that will list all the files and sub folders in folder x and then also list all the files and sub folders that are in the sub folders of x and so it goes on.

This is where it...
Forum: Excel 09-03-2017, 11:16 PM
Replies: 7
Views: 2,184
Posted By smiler44
Re: Break Excel 2003 password

here's the help file as well

smiler44
Forum: Excel 09-03-2017, 11:16 PM
Replies: 7
Views: 2,184
Posted By smiler44
Re: Break Excel 2003 password

here you go scott-atkinson
i'll upload the help file as well


this is the path where the files were kept on my pc
"C:\Program Files (x86)\Excel Tool VBA Password Recovery\Excel Tool VBA...
Forum: Excel 06-19-2017, 10:48 PM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

Gasman, thank you for the formula, its been of great help. I have used it during the week and I can now add it into my spread sheet to use properly.

thanks again

smiler44
Forum: Excel 06-12-2017, 01:29 PM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

very kind Gasman thank you, I'll study it tomorrow

smiler44
Forum: Excel 06-12-2017, 05:45 AM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

sorry Gasman for some reason I did not get an email to say you had replied.

A2 + C2 = 09.06.17 but there is a bank holiday on 29.05.17 so new date should be 10.06.17 not 08.06.17

I don't...
Forum: Excel 06-10-2017, 01:02 AM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

In the attached example only look at the cells highlighted Green ignore the rest and then see the macro referred to.
I am at the moment running the macro using the F8 key as need to modify the file...
Forum: Excel 06-10-2017, 12:50 AM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

No worries Gasman, I thought it was me :)

In your example you are adding 11 calendar days to 28.05.17 but as 29.05.17 is a bank holiday you need to add 12 and end up with 09.06.17
just as you...
Forum: Excel 06-09-2017, 03:01 PM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

I have just found this formula via a Goggle search
=B2-A2-COUNTIF(E2:E11,">="&A2)+COUNTIF(E2:E11,">"&B2)

it can take note of bank holidays but needs to know the start and end date so it can work...
Forum: Excel 06-09-2017, 02:08 PM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

Gasman, sorry I think we have our wires crossed or I really am missing something.
It is not working days I need but calendar days not including bank holidays.
May had 31 days with 2 of them in...
Forum: Excel 06-09-2017, 12:56 PM
Replies: 16
Views: 2,191
Posted By smiler44
Re: formula for adding calaender days

Gasman, thank you. that thread got rather heated.
The result seemed to be a macro for working out the number of working days between 2 dates. I was after a formula to add x number of calendar days...
Forum: Excel 06-09-2017, 11:25 AM
Replies: 16
Views: 2,191
Posted By smiler44
formula for adding calaender days

I want to add a number of days to a date and get the new calendar date but also account for bank holidays.

cell A1 a date
number of days to add
bank holidays in cells A3:I3

something like...
Forum: VB.NET 06-07-2017, 01:59 AM
Replies: 2
Views: 3,162
Posted By smiler44
Help going from VB 5 to VB.Net

I'm thinking of getting VB. Net and would like some advice please.

I have a project written in Visual Basic version 5.
Will VB.net be able to do the same things as VB5?

what is the best way...
Forum: Excel 04-15-2017, 08:32 AM
Replies: 7
Views: 2,184
Posted By smiler44
Re: Break Excel 2003 password

oh, cheers Gasman I never knew that. when I clicked on the zipped file I downloaded nowt seemed to happen.
thanks anyway

smiler44
Forum: Excel 04-14-2017, 11:38 PM
Replies: 7
Views: 2,184
Posted By smiler44
Re: Break Excel 2003 password

found the file I wanted

smiler44
Forum: Excel 04-14-2017, 01:51 PM
Replies: 7
Views: 2,184
Posted By smiler44
Break Excel 2003 password

I have to add a macro to an xls workbook, I assume it is Excel 2003.
The existing VBA code is password protected. Can you recommend something to break the password?

I thought I had something to...
Forum: Excel 02-16-2017, 02:30 PM
Replies: 1
Views: 797
Posted By smiler44
Re: get range and copy part of range

more searches via Google and getting different bits of code I have come up with this. It filters, copies just the cells I want from the visible cells and pastes to another sheet.
I will add a do...
Forum: Excel 02-16-2017, 09:55 AM
Replies: 1
Views: 797
Posted By smiler44
get range and copy part of range

I want to filter a spread sheet. There may be just one row plus the header of more rows plus the header.

I want to copy column A and first visible cell after the header to column C and last used...
Forum: Excel 12-18-2016, 01:02 PM
Replies: 1
Views: 1,158
Posted By smiler44
Re: I want to ask user to save file after it's sent as attachment in email!

why prompt them, why not just add code to save the file?

x = MsgBox(" do you want to save file", 36, "confirm")


If x = 6 Then ' yes
' not sure is this...
Forum: Excel 10-18-2016, 12:33 PM
Replies: 2
Views: 672
Posted By smiler44
Re: please can you explain this code?

thanks. i need the code i think as i will run this on different spread sheets.

smiler44
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:46 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World