Click here to Skip to main content
15,923,051 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Split cells with comma and space Pin
manju 34-Feb-19 23:47
manju 34-Feb-19 23:47 
GeneralRe: Split cells with comma and space Pin
Richard MacCutchan4-Feb-19 23:56
mveRichard MacCutchan4-Feb-19 23:56 
GeneralRe: Split cells with comma and space Pin
Richard Deeming5-Feb-19 1:17
mveRichard Deeming5-Feb-19 1:17 
AnswerRe: Split cells with comma and space Pin
Maciej Los5-Feb-19 1:41
mveMaciej Los5-Feb-19 1:41 
Questiondatagridview that was bound to dataset Pin
ClintSoft4-Feb-19 15:38
ClintSoft4-Feb-19 15:38 
QuestionLoad xlsx filr from folder and write to new workbook Pin
manju 33-Feb-19 20:25
manju 33-Feb-19 20:25 
QuestionRe: Load xlsx filr from folder and write to new workbook Pin
Richard MacCutchan3-Feb-19 22:23
mveRichard MacCutchan3-Feb-19 22:23 
AnswerRe: Load xlsx filr from folder and write to new workbook Pin
manju 34-Feb-19 21:39
manju 34-Feb-19 21:39 
Hi,

I have updated the code where it loads the file from some path.
And setting it to myData.
Set myData = Workbooks.Open("D:\B_Test.xlsx")
Set sh1 = myData.Sheets(1)
Set sh2 = myData.Sheets(2)


Now how can i change the code so that it writes to a new workbook and and set that to myData.

Set myData = "New WorkBook"


Thanks
Sharan
GeneralRe: Load xlsx filr from folder and write to new workbook Pin
Richard MacCutchan4-Feb-19 22:00
mveRichard MacCutchan4-Feb-19 22:00 
GeneralRe: Load xlsx filr from folder and write to new workbook Pin
manju 34-Feb-19 23:49
manju 34-Feb-19 23:49 
QuestionMacro Substitution en VB.Net Pin
Member 141390043-Feb-19 17:00
Member 141390043-Feb-19 17:00 
AnswerRe: Macro Substitution en VB.Net Pin
Eddy Vluggen3-Feb-19 22:45
professionalEddy Vluggen3-Feb-19 22:45 
GeneralRe: Macro Substitution en VB.Net Pin
Member 141390049-Feb-19 13:24
Member 141390049-Feb-19 13:24 
GeneralRe: Macro Substitution en VB.Net Pin
Member 141390043-Mar-19 6:18
Member 141390043-Mar-19 6:18 
GeneralRe: Macro Substitution en VB.Net Pin
Eddy Vluggen3-Mar-19 6:28
professionalEddy Vluggen3-Mar-19 6:28 
AnswerRe: Macro Substitution en VB.Net Pin
Maciej Los5-Feb-19 2:38
mveMaciej Los5-Feb-19 2:38 
GeneralRe: Macro Substitution en VB.Net Pin
Member 141390049-Feb-19 13:25
Member 141390049-Feb-19 13:25 
GeneralRe: Macro Substitution en VB.Net Pin
Member 141390043-Mar-19 6:17
Member 141390043-Mar-19 6:17 
QuestionCompute Sum on a column based on criteria Pin
Member 1412885424-Jan-19 6:54
Member 1412885424-Jan-19 6:54 
AnswerRe: Compute Sum on a column based on criteria Pin
Richard Deeming24-Jan-19 8:41
mveRichard Deeming24-Jan-19 8:41 
GeneralRe: Compute Sum on a column based on criteria Pin
Member 1412885424-Jan-19 17:47
Member 1412885424-Jan-19 17:47 
QuestionRe: Compute Sum on a column based on criteria Pin
Ralf Meier24-Jan-19 19:58
mveRalf Meier24-Jan-19 19:58 
AnswerRe: Compute Sum on a column based on criteria Pin
Member 1412885424-Jan-19 21:07
Member 1412885424-Jan-19 21:07 
AnswerRe: Compute Sum on a column based on criteria Pin
Ralf Meier24-Jan-19 21:22
mveRalf Meier24-Jan-19 21:22 
QuestionUnable to load xlsm file with Office 2016 Pin
manju 323-Jan-19 20:18
manju 323-Jan-19 20:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.