1
Looping to create new workbooks using a set “transaction” number
I’m playing around a bit and can’t figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 – 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when “.SaveAs Filename:=Start” comes back around [...]
Answer Question
| August 12, 2009 10:49 PM
Excel VBA, Excel workbooks, LOOP statement, Microsoft Excel 2003, Sequence number generation, VBA, Visual Basic for Applications
I’m playing around a bit and can’t figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 – 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when “.SaveAs Filename:=Start” comes back around [...]
Answer Question
| August 12, 2009 10:49 PM
Excel VBA, Excel workbooks, LOOP statement, Microsoft Excel 2003, Sequence number generation, VBA, Visual Basic for Applications
how to generate sequece number in an existing table
We are having two datamart one is GDM and other is IDM. Now what to do: 1)Establish a unique royalty_transaction_id in GDM.this should be assigned to every single sales record when inserted in Global_sales_table. 2)Established a reversed royalty transaction id in GDm.This should be assigned to reversed sales transaction and it should point to the [...]
Answer Question
| July 21, 2008 4:20 AM
Data marts, Global Data Mart, International Data Mart, Sequence number generation
We are having two datamart one is GDM and other is IDM. Now what to do: 1)Establish a unique royalty_transaction_id in GDM.this should be assigned to every single sales record when inserted in Global_sales_table. 2)Established a reversed royalty transaction id in GDm.This should be assigned to reversed sales transaction and it should point to the [...]
Answer Question
| July 21, 2008 4:20 AM
Data marts, Global Data Mart, International Data Mart, Sequence number generation
1
