Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 2nd 11, 05:50 AM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 2
Default Need lot of help with linking spreadsheets

Ok, so I want to start this out saying that I'm not asking for someone to code this all for me...I know that would be dumb. I just need help being pointed in the right direction. I do have a limited knowledge of VB.

Ok so what I want to do is:

I have a file (a) that is created nightly...saved under a new name based on the date.
I want to create a program/file that, when run, will
open a second static file (b)
then run a macro to update specific cells within (b) with specific data from (a).
- the data in (a) is always saved to the same cells in each new sheet
- the data in (b) needs to move over each night. (if I need to make several programs to do this that's fine, but I was thinking that there has to be a way to update that with some sort of array)
- once the data is updated, I want to run a macro I have already created to print several copies of some sheets in the wb.
- and finally I would like to save, and email the new file to a specific person's email.

can someone please point me to some tutorials that will detail how to do each of the things I need? Like I said, I'm gladly willing to look up the stuff and do the work. I just keep getting sent to random threads here when I google stuff so I figured this would be easier.

  #2   Report Post  
Old March 2nd 11, 09:09 AM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 2
Default

so far I have:

[code]Sub test()
'
' test Macro
'
Dim fileName As String
Dim fileName1 As String
' prompt the user to get the name of the file(s) to open

fileName = Application _
.GetOpenFilename()

fileName1 = Application _
.GetOpenFilename()

' opens both files
Excel.Application.Workbooks.Open (fileName)
Excel.Application.Workbooks.Open (fileName1)

' format the cells
' to make sure they copy correctly
Range("B1:B26").NumberFormat = "Genral"

' for loop to get data

For i = 6 To 23
Select Case i
Case Is = 6 ' assign: net sales
%2

Last edited by dctrs8tn : March 2nd 11 at 09:12 AM
  #3   Report Post  
Old April 9th 12, 12:54 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 1
Default

Iam not sure if there is amcse "fix" for this or not in Zimbra Desktop.mcitp, , We often have appointments that overlap. (One starts at 9 & ends at 10:30 70-640 exam ,
while another starts at 10 & ends at 11) The normal calendar view in Zimbra causes the overlapping appointments to also 70-680 exam, overlap visually rather than being shown side by side so you cannot easily read the description in both appointments. Is there a setting somewhere than can change this view?photo retoucher,


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linking between spreadsheets Ed Excel Worksheet Functions 5 April 27th 09 11:10 PM
Linking Spreadsheets [email protected] Excel Worksheet Functions 1 April 7th 08 09:37 PM
linking spreadsheets Excelnewbie Excel Worksheet Functions 0 September 24th 07 06:40 PM
Linking spreadsheets charlie59 Excel Discussion (Misc queries) 0 September 18th 07 05:00 PM
Linking different spreadsheets NoviceIan Excel Discussion (Misc queries) 2 July 20th 05 11:59 AM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017