grego9
Last Activity: Aug 18 '14, 03:49 PM
Joined: Feb 19 '07
Location:
-
Thanks for your help twinnyfo - you got me thinking differently about how to solve it! -
I re-engineered the solution. I copied the contents of the rollifrp.xls into the Master spreadsheet and then "copied" that tab to create a new file with the naming convention outlined above. Worked a treat. Shame I couldn't figure out how to address the original problem - but at least I will sleep at night now.Leave a comment:
-
Thanks - I've tried that and it still falls over. This code works elsewhere in the same workbook - bit of a puzzler. I've even tried picking up a different file and then saving that down instead - but it still falls over!
Thanks for your persistence on this one!
I might have to take a break before I go insane!Leave a comment:
-
I think the problem is regarding which sheet is active. If I put
ThisWorkbook.Ac tivate before ActiveWorkbook. SaveAs StDocName2 the code saves the "MASTER - FX Reconciliations Modelvista.xls" with the right name and in the right location - However it is the rollifrp.xls file that I want saved down. A bit strange as I have the
Windows("rollif rp.xls").Activa te
command in the code. Do you think this would be...Leave a comment:
-
Thanks for the reply. However, the directory already exists and the code can be executed fine when I simply go to debug and set run to cursor to the last line of code. It does everything I want it to - the only thing I don't want it to do is pop up the run time error when running the macro each time!
Thanks!Leave a comment:
-
HELP!!! Problem saving file in excel
I am running a macro from an excel file called "MASTER - FX Reconciliations Modelvista.xls" (excel 2010 in compatibility mode to save in 2003 format) from a button in the spreadsheet. The macro takes data from a file called "rollifrp.x ls" (after a small amount of manipulation) and pastes it into the
"MASTER - FX Reconciliations Modelvista.xls" file. It then attempts to save the rollifrp file down with a new...Last edited by Rabbit; Aug 18 '14, 03:47 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
Works perfectly! Thank-you so much, that will save me a lot of time!Leave a comment:
-
I am a bit of a novice with VBS so I'm not sure what the difference is betweem VBS and VB.net!Leave a comment:
-
VBS script required to remove " from .ttx file
I have a file that is stored in C:\users\123456 \ with the name export.ttx . I want to create a VBS script that opens up this file, removes all the " in the file (and replaces these " with nothing)and then saves down the amended file as a .csv file. I am not sure where to start. To be clear I want the rest of the file contents to be unchanged - I only want to remove the "'s. Can anyone offer any help?
thanks -
Document not saved when using VBA in Excel 2010
I have an excel 97-2003 file called "MASTER - FX Reconciliations Modelvista.xls" that I open using Excel 2010. Within this file I run a VBA macro with the name FXcurr. This macro picks up a file called rollifrp.xls (97-2003 Worksheet) makes some amendments to it and then saves it down to a file path detarmined by the entries in two cells of the MASTER - FX Reconciliations Modelvista.xls file. The macro errors and returns a "Document...Last edited by Rabbit; Apr 9 '14, 04:25 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
copy Access 2003 table over to excel 2007 on startup
I am trying to write some code to copy over a Microsoft Access (2003) table to a specific sheet of a Microsoft Excel (2007) workbook
I want the code to reside in the excel workbook and copy the table into excel when the excel file is opened.
I have been struggling at the first hurdle just getting the table copied over. I found the following code but when I copy it into a module I cannot step into the macro to run... -
I ended up sussing this one without using VBA
The values in column AF were the ones that were changing and the ones I wanted to timestamp. I put this formula in AU6.
=IF(ISBLANK(AF6 ),"",IF(AU6="", NOW(),AU6))
I put this in AV6 (gives the iteration number and the data held):
=IF(AT6<>"",IF( AV6="",0&" - "&AT6,IF(RIGHT( AV6,LEN(AV6)-4)=""&AT6,AV6,M OD(LEFT(AV6,1)+ 1,10)&"...Leave a comment:
-
Add today's date to another cell after cell value changes ExcelVBA
I am trying to write a procedure so that when data in row AF of Excel is amended then the date the amendment took place is entered into column AM. I thought I would start by trying to get it to work for one cell rather than a range and did the following:
Private Sub Worksheet_Chang e(ByVal Target As Range)
Application.Ena bleEvents = False
If (Target.Address = "$AF$7") Then... -
Perfect - Thanks for your persistence! You have saved me from insanity!Leave a comment:
-
Hi guys - thanks for your continued help on this. I made the relevant changes but I keep getting a sum of zero. In the file that ggeu uploaded it sums to 5. The actual result should be the sum of all the numbers in column H of the HYP-ST Cash tab where the criteria equal what's entered into the function on the summary tab. So in the example of ACTIVELY MANAGED and R-R plc this should sum to 62405. I am confused! Any further help greatly ap...Leave a comment:
-
I have attached the file
I have attached the file so you can see what is going on. I tried the Variant change but the range of cells that the data is held in is in a different tab to the where the main formula sits - so I would need the
a = Range(Cells(1, 1), Cells(484, 8))
formula to reference the other sheet name - how would I bake this in?
thanks for your continued help on this!...Leave a comment:
-
Just tried to attach it - it says it is an invalid file - It's 3MB in size is that likely to be the issue?Leave a comment:
-
Excel 2000 Function problem
I have written the following function to total up the values in a column where the values in columns 5 and 6 of a range I have created (called "lori") are equal to the values on another summary tab (details lower down)
Function StCashTotalGBP( Managed, Entity)
Counter = 1: StCashTotalGBP = 0
Do While Counter <= Range("lori").R ows.Count
If Range("lori").I tem(Counter, 5)... -
How to close a message box that is called from another procedure
I simply want to close a message box that is called from another procedure. I don't want to alter the other procedure - I want the message box to appear but then the macro that I am writing to simply close the message box that gets called (so effectively cliecking ok on it!)
Help! it's driving me mad! -
Excel range reference
I am trying to write a macro that will simply copy and paste a set of formulas contained in range w255 to w269 of my Excel 2000 spreadsheet. I want these formulas to be copied to the next row in column W after the last populated cell in column W.
I have used the formula
=CELL("Address" ,INDEX(W:W,MAX( MATCH(99999999, W:W),MATCH("ZZZ Z",W:W))))
to locate the last used cell in column W
this...
No activity results to display
Leave a comment: