Thanks for the info Guys
Type: Posts; User: HowardC; Keyword(s):
Thanks for the info Guys
I have Windows 8 operating system
When I tried logging into Skype, I get the following message
Help us protect your account
We detected something unusual and need to verify your account....
I have several libraries created on Windows 7. However, when trying to create a new library nothing happends. I guess I have reached the maximum level. Is there a way to increase the number of...
Thanks Maud, never thought of this. Have amended code and it works perfectly
I have code to copy the Data in Col F (closing Balances) and to paste value these in Col C (Opening Balances) from row 3 onwards, except where the data contains an = sum formula. Where there is an ...
Thanks for your input, much appreciated
Agree 100%. I'm going to use your suggestion by placing an apostrophe in front of the section as mentioned by you
The source files were developed by someone else so I did not want to amend their code, but I will ask the person to put an apostrophe in front of their code as this is the easiest way
Thanks for pointing this out Maud. I was hoping that there may be another way. I will put an apostrophe in front of the message Box for all the files containing this message box statement
Sorry for the confusion caused
See code below from original workbook which generates the message box in the source workbook. When calling this from the destination workbook, I want OK...
Thanks for the help. I used your code and called it from within my macro using application.run "DisplayMsgBox", but the message box still appears and I have to select the "OK" button to...
Thanks for the info Maud, however the message box with the OK button still appears
I have a macro that opens several files and activates a particular macro that brings up a message box that prompts the user the "OK" button
I would like code to would automatically accept the "OK"...
Thanks for your input dguillett
Thanks for the help and your input
I have a spreadsheet, where I want to open all the files that are listed on sheet "workspace" in a folder called C:\Pull as well as the sub-folders
I have tried to write code to do this -see code...
Thanks for the reply. Much appreciated
Thanks for the useful link, much appreciated
I have a workbook that contains a macro to copy files from one folder to another. I would like the code amended so that if the file in the destination folder already exits, it must not overwrite the...
Thanks for the help chaps
I am using Windows 8 and Office 2013
I would like to know how to set a default folder when opening up files using Office 2013
Thanks for the advice
Managed to sort out my macro by breaking it down into two sections
Dim LastRow As Long
LastRow = Sheets("Income...
I have a macro to print a worksheet.
When printing I want "revenue" Cell A2 to print in the header from A3 to A27 and "Costs" A28 to print in he header thereafter
See Attached file containing...
Thanks for the help , much appreciated