Jump to content
Sign in to follow this  
Karicula

Copy Excel Range to Master Workbook

Recommended Posts

Karicula

I need to be able to copy an excel range without reading the data into an array - when I use the array it does not bring over the date data in the correct format and it converts it to "2.01E+13" which isn't all that helpful. I am downloading the original data from a website that creates the file in TXT format and then converting it to an .xls

Any ideas on how to approach this issue would be appreciated!

Data Copier To Post.au3

Share this post


Link to post
Share on other sites
Karicula

This is the code:

; Set up the variables

#include <Excel.au3>

#include <Array.au3>

#include <Constants.au3>

#Include <string.au3>

#Region Variable declarations

Global $sXlsMasterFile = "C:\1data\SLD_Data_Master.xls"

Global $DLFile = "C:\1data\Tester.xls"

#EndRegion

#Region new code

$oExcel = ObjCreate("Excel.Application")

$oExcel.Visible = 2

$oExcel.WorkBooks.Open($sXlsMasterFile)

$oExcel.WorkBooks.Open($DLFile)

$oExcel.Application.ActiveSheet.Range("A2:BB16").select

$oExcel.Application.ActiveSheet.Range("A2:BB16").copy

;$oExcel.WorkBooks.Visible($sXlsMasterFile) tried this

;$oExcel.WorkBooks.($sXlsMasterFile).Select tried this

$oExcel.WorkBooks.Select($sXlsMasterFile) ; tried this

$oExcel.Application.ActiveSheet.Range("A2:BB16").select

$oExcel.Application.ActiveSheet.Range("A2:BB16").paste

#EndRegion

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.