Put this macro into a regular module in the Bif file to get the number from the
data file
Option Explicit
Sub GetID_SAS()
Dim lr As Long
Dim myid As String
Application.ScreenUpdating = False
Application.DisplayAlerts = False
myid = InputBox("ID to get, ie 103")
Workbooks.Open Filename:="Tota
. I didn’t to it cause
incompability of dates system.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Brajesh Kumar Porwal
Envoyé : jeudi 11 août 2011 11:43
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Split data order wise
Hi Danial,
You can see 14 order names in file of ‘Total order data’ then I want to
order wise split data. For example output file of
“BIIF_0811_0911_D_ShLead_1”. Similarly I want to 14 files just click in
macro. Because I have spent lot time copy paste.
--
--
One Team One Dream One Goal
Wa
Hi,
Can you explain a bit more ? there are 2 workbooks in your archive.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Brajesh Kumar Porwal
Envoyé : jeudi 11 août 2011 08:50
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Sp
