Excel VBA Help...

[chanman525]

I'm a very basic VB programmer who has just gotten the task of taking a pretty big spreadsheet and automating it. There are 4 .xls files that I need to pull information from and place into certain cells. This needs to be run once a week. I really don't even know the first place to start. Does anyone have any good links on importing information from other spreadsheets?

Also, this informations needs to be placed into a certain row each week. We run this on Saturday 6/23 and so all of the information will need to be placed into that row. Next week, it will need to be the row beside it...and so on. If anyone has any documentation on that it would be awesome.

Thanks for any info you can provide.

 

[SkipVought]

Hi,

Is this tabular data?

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[chanman525]

Yes it is, I'm dealing mainly with columns of a spreadsheet.

 

[SkipVought]

You can easily use Data>Get External Data>New Database Query - -Excel Files -- The workbook you want to access -- the sheet you want to query.....

Once a QueryTable is added to the sheet, you can Data>Refresh to get up-to-date data.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[chanman525]

Well it's not that simple. Some information has math involved between 2 reports. Such as, adding the direct hours from report 1 and 3 and dividing it by the Units / Hour from report 2.

So I believe that I'm going to need to use code or a macro to do this. I just don't know how to pull information from other spreadsheets using code.

 

[SkipVought]

Pull it from the other workbooks using Query, one query per sheet.

Once in your workbook, manipulating the data ought to be pretty simple.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[rlmOC]

Hi,

I currently have a command button on my spreadsheet that will copy a specified range and automatically attach it using Faxmaker, the user is then taken to the Outlook screen where they currently have to type in [Fax:18889999999,18889999999] then click the send button in Outlook.

I would like the TO: field in Outlook to automatically populate with two numbers taken from the spreadsheet and then automatically send the fax.

I am not sure how to reference the TO: field or Send since faxmaker is already taking me to Outlook, so I don't believe I can create a Outlook Application.

Thanks in advance,

rlmOC

 

[SkipVought]

rlmOC,

Please post in a NEW THREAD.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}