Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you do an Excel Data Import using vbscript?

Status
Not open for further replies.
realty205

realty205

Technical User
Aug 1, 2008
10
US
I was hoping that I could do an Excel Data Import utilizing vbscript. Does anyone know if this is possible? Anyone have a sample?
 
Sort by date Sort by votes
Do you know how to do it in Excel VBA ?
If not then use the Excel macro recorder doing the import manually.
Finally it's just a matter of executing the code with OLE automation from VBScript.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Hello,
I wrote a script that opens a csv file, sets all the cell columns to auto fit, edits the cell formats of certain columns, (zip to 5 zeroes so the leading zeroes don't get dropped) and then writes the file out as an excel spreadsheet. Is that something that could fit into what you are trying to do?

Bob
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
VBSCRIPT dont work windows 11 23h2 ???
Replies
2
Views
311
SoftwareRT
SoftwareRT
bdwilcox
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
865
SoftwareRT
SoftwareRT
Alexvb6
  • Question
Deprecation of VBScript + Classic ASP: How to Ask Microsoft to cancel their planned craziness
Replies
0
Views
148
Alexvb6
Alexvb6
Brianfree
  • Locked
  • Question
Excel Rows to Column 1
Replies
2
Views
228
Brianfree
Brianfree
joaodaffonsojr
  • Locked
  • Question
vbscript import xml data to excel
Replies
0
Views
110
joaodaffonsojr
joaodaffonsojr

Part and Inventory Search

Sponsor

Back
Top