prepare a .csv file for UL to HikaShop

CNXTim · #31 07-09-2014, 03:26 PM

Thanks Charles,

Looking forward to that and getting this "Little Shop of Horrors" up and selling.

charlesdh · #32 07-09-2014, 04:32 PM

Hi,

The code as is should work. However, if the format of the actual file is different it will not work.
Also, If you are wanting to run the code on files you receive each month you will need to have the code in a separate workbook and have it "Open" the new data file and the run the rest of the code. Check your "PM"

Off for the nite will be back tomorrow

charlesdh · #33 07-10-2014, 01:51 PM

HI,

I need more info from you.

The file that you want to convert to "CVS" how do you get it.
Do you open it?
Will the file name be different each time?
What is the Sheet name that has the data that you want to convert.
I attached a copy of the converted file.

charlesdh · #34 07-31-2014, 04:08 PM

Hi,

I now know what I was waiting for. When we populate the CVS sheet do you need headers in It.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM
excel cannot open the file .xlsx because the file format or file extension is not val	teddysika	Excel	1	11-22-2012 06:06 AM
error: You are attempting to save a file format that is blocked by file block setting	zatlas1	Office	8	04-28-2012 02:37 PM
Prepare report/list of all highlighted items	nrschmid	Word	1	10-05-2011 06:26 PM
ms office drawing tools that can help to prepare small kinds of scaffold mladder etc	aligahk06	Office	0	07-19-2010 08:47 AM