Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
Hi Experts, i have a question with three column involved in it.
column A (where a number is entered [if required] whenever the file is opened) column J ( where the previous total is stored) column P (P1=J1+A1) when ever this file is opened Column A should get set to '0' (zero) automatically, and column J should get the value that is stored in column P. i am not sure if this makes any sense to you guys. please ask for clarification. PLEASE HELP!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
Change sheet name to match the sheet you want the update done in.
In the Workbook module place the following code: Private Sub Workbook_Open() With Sheets("Sheet1") .Range("J1").Value = .Range("P1").Value .Range("A1").Value = 0 End With End Sub -- Kevin Backmann "Mir Khan" wrote: Hi Experts, i have a question with three column involved in it. column A (where a number is entered [if required] whenever the file is opened) column J ( where the previous total is stored) column P (P1=J1+A1) when ever this file is opened Column A should get set to '0' (zero) automatically, and column J should get the value that is stored in column P. i am not sure if this makes any sense to you guys. please ask for clarification. PLEASE HELP!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
Hi Sir it does not work for me...
"Kevin B" wrote: Change sheet name to match the sheet you want the update done in. In the Workbook module place the following code: Private Sub Workbook_Open() With Sheets("Sheet1") .Range("J1").Value = .Range("P1").Value .Range("A1").Value = 0 End With End Sub -- Kevin Backmann "Mir Khan" wrote: Hi Experts, i have a question with three column involved in it. column A (where a number is entered [if required] whenever the file is opened) column J ( where the previous total is stored) column P (P1=J1+A1) when ever this file is opened Column A should get set to '0' (zero) automatically, and column J should get the value that is stored in column P. i am not sure if this makes any sense to you guys. please ask for clarification. PLEASE HELP!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
Do you have macros enabled?
Is the code in the ThisWorkbook code module? What happens when you step through the code? In article , Mir Khan wrote: Hi Sir it does not work for me... "Kevin B" wrote: Change sheet name to match the sheet you want the update done in. In the Workbook module place the following code: Private Sub Workbook_Open() With Sheets("Sheet1") .Range("J1").Value = .Range("P1").Value .Range("A1").Value = 0 End With End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
I have Macros enabled and work with different other macros. when i step
through it it works the way the macro is designed but when i save and close the file after entering data in column A and re-open the file nothing happens column A, J and P remains the same. Please help. "JE McGimpsey" wrote: Do you have macros enabled? Is the code in the ThisWorkbook code module? What happens when you step through the code? In article , Mir Khan wrote: Hi Sir it does not work for me... "Kevin B" wrote: Change sheet name to match the sheet you want the update done in. In the Workbook module place the following code: Private Sub Workbook_Open() With Sheets("Sheet1") .Range("J1").Value = .Range("P1").Value .Range("A1").Value = 0 End With End Sub |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
Hi Sir, nothing happens when i open the file. it works when i run it from the
visual basic editor. i want it to work when we open the file. "Mir Khan" wrote: I have Macros enabled and work with different other macros. when i step through it it works the way the macro is designed but when i save and close the file after entering data in column A and re-open the file nothing happens column A, J and P remains the same. Please help. "JE McGimpsey" wrote: Do you have macros enabled? Is the code in the ThisWorkbook code module? What happens when you step through the code? In article , Mir Khan wrote: Hi Sir it does not work for me... "Kevin B" wrote: Change sheet name to match the sheet you want the update done in. In the Workbook module place the following code: Private Sub Workbook_Open() With Sheets("Sheet1") .Range("J1").Value = .Range("P1").Value .Range("A1").Value = 0 End With End Sub |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
You haven't answered as to whether the code is in the workbook code
module (by default named ThisWorkbook)... If the code IS there, it will run automatically when you open the file. In article , Mir Khan wrote: Hi Sir, nothing happens when i open the file. it works when i run it from the visual basic editor. i want it to work when we open the file. "Mir Khan" wrote: I have Macros enabled and work with different other macros. when i step through it it works the way the macro is designed but when i save and close the file after entering data in column A and re-open the file nothing happens column A, J and P remains the same. Please help. "JE McGimpsey" wrote: Do you have macros enabled? Is the code in the ThisWorkbook code module? What happens when you step through the code? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
On File Open
I didn't knew where workbook code module, but now i know and it is working
fine. Thanks a bunch... JE McGimpsey :). I really appreciate your help. "JE McGimpsey" wrote: You haven't answered as to whether the code is in the workbook code module (by default named ThisWorkbook)... If the code IS there, it will run automatically when you open the file. In article , Mir Khan wrote: Hi Sir, nothing happens when i open the file. it works when i run it from the visual basic editor. i want it to work when we open the file. "Mir Khan" wrote: I have Macros enabled and work with different other macros. when i step through it it works the way the macro is designed but when i save and close the file after entering data in column A and re-open the file nothing happens column A, J and P remains the same. Please help. "JE McGimpsey" wrote: Do you have macros enabled? Is the code in the ThisWorkbook code module? What happens when you step through the code? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming |