Sign in to follow this  
Followers 0
Karicula

Copy Excel Range to Master Workbook

3 posts in this topic

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



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

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

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  
Followers 0