Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to perform a TASK on another workbook
All references I can find describe running a macro that is located in
another workbook. I want to perform a task ON another workbook using a routine in the current workbook. I can't add the routine to the other book because it's a datafile(.xls) generated from another program. Specifally I want to "find" a value and then copy it into the current workbook. I can open the workbook but don't seem to be able to perfom any tasks on it. EtimeFile = "C:\My Documents\Work files\emplabdt.xls" 'used at home Set XL = CreateObject("Excel.Application") XL.Workbooks.Open (EtimeFile) XL.Visible = True Set paycode = Worksheets([emplabdt.xls]!Sheet1).Columns("A").Find("Pay Code") paycode.Select -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to perform a TASK on another workbook
A "brief" look shows that you need to change worksheets to workbooks, etc.
Set paycode = Worksheets([emplabdt.xls]!Sheet1).Columns("A").Find("PayCode") Set paycode = Workbooks("emplabdt.xls").Sheets(1).Columns("A").F ind("PayCode") "JimKusche" wrote in message ... All references I can find describe running a macro that is located in another workbook. I want to perform a task ON another workbook using a routine in the current workbook. I can't add the routine to the other book because it's a datafile(.xls) generated from another program. Specifally I want to "find" a value and then copy it into the current workbook. I can open the workbook but don't seem to be able to perfom any tasks on it. EtimeFile = "C:\My Documents\Work files\emplabdt.xls" 'used at home Set XL = CreateObject("Excel.Application") XL.Workbooks.Open (EtimeFile) XL.Visible = True Set paycode = Worksheets([emplabdt.xls]!Sheet1).Columns("A").Find("Pay Code") paycode.Select -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i use one workbook to perform instructions i another | Excel Discussion (Misc queries) | |||
New Workbook Task Pane | Setting up and Configuration of Excel | |||
Reference a Macro to perform Cell formula | Excel Discussion (Misc queries) | |||
New Workbook Task Pane | Excel Discussion (Misc queries) | |||
Can you perform ctrl+shift+; in a macro to display time? | Excel Discussion (Misc queries) |