Nick;
Your not sending this off in a different direction but, rather, making me think.
I have to note that while I'm not new at using VBA I am a neophyte at using the iSeries and
importing records as our organization just started using this technology. So I am in a learning
phase right now.
From what I can gather by surfing around, as well as your link, is that I should be able to set
up my own access to the iSeries(?).
I'd be interested in a "snippet" of code that would get me started-everything I've read is a
little beyond me, at this point..
Would you happen to have any links to a "Importing data into Excel from a DB2 database on an
iSeries using VBA - for dummies"?
Anyway, thanks for the interest.
--
Regards
Rob
"Nick Hodge" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Rob
>
> Without wishing to send this off in a different direction, you can set the 'Where' clauses on
> a worksheet, so the users just change a date range for example and the data just changes.
>
> I have a post here that may help describe this
>
> http://excelusergroup.org/blogs/nick...ters-odbc.aspx
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> (E-Mail Removed)DTHIS
> web: www.excelusergroup.org
> web: www.nickhodge.co.uk
>
>
>
>
>
> "RobWN" <(E-Mail Removed)> wrote in message news:O3RRx$(E-Mail Removed)...
>> Thanks Nick;
>>
>> While it certainly will give me food for thought I'm looking for something simpler (for me at
>> least).
>>
>> The download of the data is one step in a multi step process.
>>
>> I have a button that updates the DTF "Where" parameters and then simply creates a new sheet
>> in the workbook and advises the user where the DTF is located. The user then uses the iSeries
>> Navigator transfer function "Transfer Data from iSeries" to load the required records to the
>> sheet and carries on.
>> While this process works well I was hoping for some "magic" to relieve the user of navigating
>> to the DTF.
>>
>> I would not profess to being an expert and after Googling my eyes out I come close but can't
>> seem to find what I'm after (probably not asking the right question!).
>>
>>
>> Again, thanks.
>> --
>> Regards
>> Rob
>> "Nick Hodge" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Rob
>>>
>>> In Excel I do this all the time, but never use a macro to get the data. I simply get the
>>> data from Excel using Data>Import External Data>New database query. Using the client Access
>>> ODBC driver I set up the data feed and then pass the model to the team with a right
>>> click>refresh instruction. If there is any post processing to be done I set up either a
>>> button or a change event.
>>>
>>> It is in fact rare that we use data table, we get it to pivot tables, this removes many of
>>> the further needs for post-processing. granted, we needed to train users, but they love the
>>> 'what-if' solutions in a pivot table.
>>>
>>> May not answer the question, but hopefully gives some food for thought
>>>
>>> --
>>> HTH
>>> Nick Hodge
>>> Microsoft MVP - Excel
>>> Southampton, England
>>> (E-Mail Removed)DTHIS
>>> web: www.nickhodge.co.uk
>>> web: www.excelusergroup.org
>>>
>>>
>>>
>>>
>>> "RobWN" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>>> I use the addin to transfer records directly to a worksheet.
>>>> Is there anyway to automate this procedure?
>>>>
>>>> Currently my macros will set up a sheet and advise the user of the directory where the DTF
>>>> is stored.
>>>> I'd rather have this as an automatic procedure i.e.. upon calling the routine for the
>>>> download have the DTF execute automatically.
>>>> I've tried creating a BAT file but the output is display only vs. loading direct to the
>>>> sheet.
>>>> .
>>>>
>>>> --
>>>> Regards
>>>> Rob
>>>>
>>
>>
Similar Threads
