Size limit for input file in VBA?

**cyc1120** · 03-28-2008, 10:47 AM

Hi all,

I have a macro that read XML files and then extract data from it.

I have been using it to extract data from 400 mb files and it works perfectly. However, when I go to larger file sizes (800 mb, 6 gig), VBA/Excel doesnt' seem to be reading it. I don't think there is an error in my code so I was wondering if there is a file size limit in Excel.

Here is a sample of my code:

Please Login or Register  to view this content.

So, if the file was read, the value of Fsuccess would be True. However, when the file sizes are big, it returns False.

Thanks

**Leith Ross** · 03-28-2008, 12:31 PM

Hello cyc1120,

Welcome to the Forum!

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please read the Do's and Don'ts here in the Forum. Click on the link below...

Forum Rules

Sincerely,
Leith Ross

Size limit for input file in VBA?

LinkBack

Thread Tools

Rate This Thread

Display

Size limit for input file in VBA?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions