Running excel background

[timpepu]

HI !

Is it possible to drive excel in the background without seeing it (hidden) ?

Bs

Timo

 

[HiTechCoach]

Yes. I use Automation to do it.

 

[timpepu]

Yes. I use Automation to do it.

I like to use one excel file background , do you have any example

Bs

Timo

 

[HiTechCoach]

It would help to know what you are want to do with the Excel file.

 

[HiTechCoach]

See if this helps:

Export Data To Excel

 

[timpepu]

See if this helps:

Export Data To Excel

Purpose is to retrieve data directly from a text file into Access, but before I did it in Excel, where the field is edited in a couple of which I can not do in Access a field A example 000500000 was changed to 500 and field B 22221111 was changed to 2222-1111.

Bs
Timo

 

[HiTechCoach]

If it we me, I would skip Excel altogether. I do not see why you need Excel to do that. Access can import the file directly and make the same changes.

When importing data. I generally import the data to a temp/work table. Run queries and/or VBA code to clean up the data, make new fields, etc. Once that data is "clean", then I import tot he final destination table(s).