Fix for JNF 2.1 VBA

Ideas and discussions on third party tools and utilities

Moderator: Forum Moderator

Post Reply
User avatar
agida
Apprentice Crafter
Posts: 79
Joined: Thu Nov 15, 2007 4:59 am

Fix for JNF 2.1 VBA

Post by agida » Mon May 04, 2009 9:28 pm

Sorry it was JNF 2.0 version.

I found the places that need to be changed. In the VBA it is this for the Status.txt load.

Public Function DownloadTimeStamp()
Dim hFileLocation As String

hFileLocation = Worksheets("GetFromSWGCraft").Cells(4, 6).Value & "\status.txt"
'panino76 - Old location
'DownloadBinaryFromURL "http://www.swgcraft.com/sendfile.php?file=status.txt", hFileLocation
DownloadBinaryFromURL "http://www.swgcraft.org/dev/public/status.txt", hFileLocation
'DownloadBinaryFromURL "http://www.swgcraft.co.uk/dev/public/status.txt", hFileLocation

The following worksheet also need modification.
GetFromSWGCraft

Replace the resource files to these:
http://www.swgcraft.org/dev/sendfile.ph ... azi.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... fin.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ria.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tra.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... era.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tis.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... pse.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tar.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... rry.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ath.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ity.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... pid.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... uri.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... oor.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... wca.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... tus.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ant.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... lla.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ire.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... der.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ner.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... nas.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ime.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... est.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... ter.csv.gz
http://www.swgcraft.org/dev/sendfile.ph ... cyn.csv.gz

I think that's all I changed to get it to work.
Agida - Rebel Ace - Master Shipwright - Flurry
Shop near Nashal /wp 4636 4459
Image
http://www.swg-piloten.com/html/agida_s ... _shop.html

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests